Tools · Services

google_sheets

Changes things

Read / write Google Sheets cells, ranges, formulas, and sheet structure.

When to use: Use this to read cell ranges, append rows, or create/modify Google Sheets. Writes must be explicitly enabled.

Example

The call

tool call

{
  "tool": "google_sheets",
  "arguments": {
    "action": "batch_get",
    "spreadsheet_id": "1AbC…",
    "ranges": [
      "Q3!A1:D20"
    ]
  }
}

Needs a connected Google account

So it isn't run here, and no output is shown: nothing on this page is made up.

Name	Type	Description
action*	string	—`add_sheetappend_valuesbatch_getclear_valuescreate_spreadsheetget_metadataget_valuesupdate_values`
spreadsheet_id	string	—
range	string	—
ranges	array	—
values	array	Two-dimensional list of rows; each row is a list of cell values.
value_render_option	string	—`FORMATTED_VALUEFORMULAUNFORMATTED_VALUE`
title	string	—

* required

Work in GitHub, Slack, Jira, Linear, Notion, Google, Stripe and more.