Skip to content

Google Sheets

Updated View as Markdown

Read explicit spreadsheet ranges and prepare targeted updates. Keep analysis tied to the original cells and revisions.

Example workflows

Copy a prompt into your connected AI client after connecting this integration. Choose resources you can access and review the supported command before running it.

Review a spreadsheet range

Read range 'Forecast!A1:F20' in the Google Sheet I provide. Summarize the totals and flag missing or inconsistent values. State which cells support each finding. Do not modify the spreadsheet.

Explore this command: google-sheets.sheets.spreadsheets.values.get

What you can do (17)

What you can do

Available commands: 17 (4 read, 13 write). Enable only the commands your application needs.

Command Effect
Applies one or more updates to the spreadsheet — google-sheets.sheets.spreadsheets.batchupdate Write
Creates a spreadsheet, returning the newly created spreadsheet. — google-sheets.sheets.spreadsheets.create Write
Returns the spreadsheet at the given ID — google-sheets.sheets.spreadsheets.get Read
Returns the spreadsheet at the given ID — google-sheets.sheets.spreadsheets.getbydatafilter Write
Returns the developer metadata with the specified ID — google-sheets.sheets.spreadsheets.developermetadata.get Read
Returns all developer metadata matching the specified DataFilter — google-sheets.sheets.spreadsheets.developermetadata.search Write
Copies a single sheet from a spreadsheet to another spreadsheet — google-sheets.sheets.spreadsheets.sheets.copyto Write
Appends values to a spreadsheet — google-sheets.sheets.spreadsheets.values.append Write
Clears one or more ranges of values from a spreadsheet — google-sheets.sheets.spreadsheets.values.batchclear Write
Clears one or more ranges of values from a spreadsheet — google-sheets.sheets.spreadsheets.values.batchclearbydatafilter Write
Returns one or more ranges of values from a spreadsheet — google-sheets.sheets.spreadsheets.values.batchget Read
Returns one or more ranges of values that match the specified data filters — google-sheets.sheets.spreadsheets.values.batchgetbydatafilter Write
Sets values in one or more ranges of a spreadsheet — google-sheets.sheets.spreadsheets.values.batchupdate Write
Sets values in one or more ranges of a spreadsheet — google-sheets.sheets.spreadsheets.values.batchupdatebydatafilter Write
Clears values from a spreadsheet — google-sheets.sheets.spreadsheets.values.clear Write
Returns a range of values from a spreadsheet — google-sheets.sheets.spreadsheets.values.get Read
Sets values in a range of a spreadsheet — google-sheets.sheets.spreadsheets.values.update Write

Connect and use

Connect and use

This connection uses your provider account.

Connect this integration, enter your provider credentials, choose commands and save. Complete provider authorization if prompted.

Get your provider credentials

Follow these steps for Google Sheets, then enter the issued values in the connection form below.

  1. In an existing Google Cloud project, enable Google Sheets API and reuse or create a Web application OAuth client. Register https://api.tooluse.net/v1/oauth/callback as an authorized redirect URI, or enter your separately registered redirect URI in this connection. Fill Google OAuth client ID and secret, choose commands, save, then Sign in to provider. Read commands request spreadsheets.readonly; enabling writes requires fresh consent for spreadsheets access. Consent-screen publishing and Google verification may be required. An existing access token is optional and expires; an API key alone cannot authorize private spreadsheets. Use spreadsheet IDs and explicit A1 ranges, then create a separate Tooluse.net API key.

Official credential setup

Where to enter credentials

In the integration page, sign in, choose your workspace and open Connect. If a Credentials choice is shown, select Use my credentials. Fill the following connection fields and save. Provider credentials belong in this form, never in an MCP configuration or tool input.

Connection field Requirement
Google access token (optional with OAuth) Optional
Google OAuth client ID Optional
Google OAuth client secret Optional
Registered OAuth redirect URI (optional) Optional
Return URL after authorization Optional

Open API keys and create a Tooluse.net key for the enabled commands.

Set TOOLUSE_API_KEY in your client and use the shared MCP configuration.

Configure Claude Code, Codex or Cursor once

Permissions and results

If you have more than one workspace, check the selected workspace in the connection or API-key dialog before saving. Roles, enabled commands, expiry and revocation use Tooluse.net's existing permissions. Disabling a connection or revoking a key immediately prevents new calls.

Send one Claude tool_use block per request. Keep the same Idempotency-Key when retrying the same request; use a new key for a new call. The response includes the shared Tooluse.net receipt and Claude tool_result. Check both HTTP status and the returned tool result before treating a call as successful.

Your connection's daily allowance and key permissions also apply. Adding a connection does not make a provider request.

Calls return the shared execution receipt and a Claude tool_result. Provider output varies by operation; consult the provider documentation for its response fields. Unconfirmed calls should be checked before retrying.

Call from your client

Use the shared MCP configuration. Refresh your client's tool list after saving the connection or changing key permissions, then call the returned tool name with the example input below.

Configure Claude Code, Codex or Cursor once

Discover your enabled tools

List permitted tools in Claude format. Read every page using page and size (maximum 100) until all results have been received. Use the returned name, not a catalog capability identifier, in the tool_use block.

curl 'https://api.tooluse.net/v1/tools' \
  -H "Authorization: Bearer $TOOLUSE_API_KEY"

Find this command in the tool list permitted by your key. Replace svc_FROM_YOUR_TOOL_LIST with its returned name. Use a new Idempotency-Key for each new call and retain it when retrying that same call.

HTTP call

curl 'https://api.tooluse.net/v1/tool-calls' \
  -H "Authorization: Bearer $TOOLUSE_API_KEY" \
  -H 'Content-Type: application/json' \
  -H 'Idempotency-Key: replace-with-a-new-call-id' \
  --data '{
  "type": "tool_use",
  "id": "toolu_example",
  "name": "svc_FROM_YOUR_TOOL_LIST",
  "input": {
    "path": {
      "spreadsheetId": "example"
    }
  }
}'

Send one Claude tool_use block per request. Keep the same Idempotency-Key when retrying the same request; use a new key for a new call. The response includes the shared Tooluse.net receipt and Claude tool_result. Check both HTTP status and the returned tool result before treating a call as successful.

Commands

Applies one or more updates to the spreadsheet — google-sheets.sheets.spreadsheets.batchupdate

Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not valid then the entire request will fail and nothing will be applied. Some requests have replies to give you some information about how they are applied. The replies will mirror the requests. For example, if you applied 4 updates and the 3rd one had a reply, then the response will have 2 empty replies, the actual reply, and another empty reply, in that order. Due to the collaborative nature of spreadsheets, it is not guaranteed that the spreadsheet will reflect exactly your changes after this completes, however it is guaranteed that the updates in the request will be applied together atomically. Your changes may be altered with respect to collaborator changes. If there are no collaborators, the spreadsheet should reflect your changes.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
path object Required additionalProperties: false
path.spreadsheetId string Required The spreadsheet to apply the updates to.
body — Required $ref: "#/definitions/BatchUpdateSpreadsheetRequest"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Creates a spreadsheet, returning the newly created spreadsheet. — google-sheets.sheets.spreadsheets.create

Creates a spreadsheet, returning the newly created spreadsheet.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
body — Required $ref: "#/definitions/Spreadsheet"

Full JSON Schema

Full JSON Schema

Example input

{
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Returns the spreadsheet at the given ID — google-sheets.sheets.spreadsheets.get

Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids is not returned. You can include grid data in one of 2 ways: Specify a field mask listing your desired fields using the fields URL parameter in HTTP Set the includeGridData URL parameter to true. If a field mask is set, the includeGridData parameter is ignored For large spreadsheets, as a best practice, retrieve only the specific spreadsheet fields that you want. To retrieve only subsets of spreadsheet data, use the ranges URL parameter. Ranges are specified using A1 notation. You can define a single cell (for example, A1) or multiple cells (for example, A1:D5). You can also get cells from other sheets within the same spreadsheet (for example, Sheet2!A1:C4) or retrieve multiple ranges at once (for example, ?ranges=A1:D5&ranges=Sheet2!A1:C4). Limiting the range returns only the portions of the spreadsheet that intersect the requested ranges.

This is a read operation. Provider rate limits and data access rules still apply.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
query.commentsViewMode string Optional The comments view mode to apply to the spreadsheet. This allows viewing the spreadsheet with comments omitted or included. If one is not specified, COMMENTS_VIEW_MODE_OMITTED is used. enum: ["COMMENTS_VIEW_MODE_UNSPECIFIED","COMMENTS_VIEW_MODE_DEFAULT_FOR_CURRENT_ACCESS","COMMENTS_VIEW_MODE_OMITTED","COMMENTS_VIEW_MODE_INCLUDED"]
query.excludeTablesInBandedRanges boolean Optional True if tables should be excluded in the banded ranges. False if not set.
query.includeGridData boolean Optional True if grid data should be returned. This parameter is ignored if a field mask was set in the request.
query.ranges array Optional
query.ranges[] string Optional The ranges to retrieve from the spreadsheet.
path object Required additionalProperties: false
path.spreadsheetId string Required The spreadsheet to request.

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "spreadsheetId": "example"
  }
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Returns the spreadsheet at the given ID — google-sheets.sheets.spreadsheets.getbydatafilter

Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. For more information, see Read, write, and search metadata. This method differs from GetSpreadsheet in that it allows selecting which subsets of spreadsheet data to return by specifying a dataFilters parameter. Multiple DataFilters can be specified. Specifying one or more data filters returns the portions of the spreadsheet that intersect ranges matched by any of the filters. By default, data within grids is not returned. You can include grid data in one of two ways: Specify a field mask listing your desired fields using the fields URL parameter in HTTP. Set the includeGridData parameter to true. If a field mask is set, the includeGridData parameter is ignored. For large spreadsheets, as a best practice, retrieve only the specific spreadsheet fields that you want.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
path object Required additionalProperties: false
path.spreadsheetId string Required The spreadsheet to request.
body — Required $ref: "#/definitions/GetSpreadsheetByDataFilterRequest"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Returns the developer metadata with the specified ID — google-sheets.sheets.spreadsheets.developermetadata.get

Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the developer metadata's unique metadataId. For more information, see Read, write, and search metadata.

This is a read operation. Provider rate limits and data access rules still apply.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
path object Required additionalProperties: false
path.metadataId integer Required The ID of the developer metadata to retrieve.
path.spreadsheetId string Required The ID of the spreadsheet to retrieve metadata from.

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "metadataId": 1,
    "spreadsheetId": "example"
  }
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Copies a single sheet from a spreadsheet to another spreadsheet — google-sheets.sheets.spreadsheets.sheets.copyto

Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
path object Required additionalProperties: false
path.sheetId integer Required The ID of the sheet to copy.
path.spreadsheetId string Required The ID of the spreadsheet containing the sheet to copy.
body — Required $ref: "#/definitions/CopySheetToAnotherSpreadsheetRequest"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "sheetId": 1,
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Appends values to a spreadsheet — google-sheets.sheets.spreadsheets.values.append

Appends values to a spreadsheet. The input range is used to search for existing data and find a "table" within that range. Values will be appended to the next row of the table, starting with the first column of the table. See the guide and sample code for specific details of how tables are detected and data is appended. The caller must specify the spreadsheet ID, range, and a valueInputOption. The valueInputOption only controls how the input data will be added to the sheet (column-wise or row-wise), it does not influence what cell the data starts being written to.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
query.includeValuesInResponse boolean Optional Determines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values.
query.insertDataOption string Optional How the input data should be inserted. enum: ["OVERWRITE","INSERT_ROWS"]
query.responseDateTimeRenderOption string Optional Determines how dates, times, and durations in the response should be rendered. This is ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. enum: ["SERIAL_NUMBER","FORMATTED_STRING"]
query.responseValueRenderOption string Optional Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. enum: ["FORMATTED_VALUE","UNFORMATTED_VALUE","FORMULA"]
query.valueInputOption string Optional How the input data should be interpreted. enum: ["INPUT_VALUE_OPTION_UNSPECIFIED","RAW","USER_ENTERED"]
path object Required additionalProperties: false
path.range string Required The A1 notation of a range to search for a logical table of data. Values are appended after the last row of the table.
path.spreadsheetId string Required The ID of the spreadsheet to update.
body — Required $ref: "#/definitions/ValueRange"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "range": "example",
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Clears one or more ranges of values from a spreadsheet — google-sheets.sheets.spreadsheets.values.batchclear

Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges. Only values are cleared -- all other properties of the cell (such as formatting and data validation) are kept.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
path object Required additionalProperties: false
path.spreadsheetId string Required The ID of the spreadsheet to update.
body — Required $ref: "#/definitions/BatchClearValuesRequest"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Clears one or more ranges of values from a spreadsheet — google-sheets.sheets.spreadsheets.values.batchclearbydatafilter

Clears one or more ranges of values from a spreadsheet. For more information, see Read, write, and search metadata. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges matching any of the specified data filters will be cleared. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc.) are kept.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
path object Required additionalProperties: false
path.spreadsheetId string Required The ID of the spreadsheet to update.
body — Required $ref: "#/definitions/BatchClearValuesByDataFilterRequest"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Returns one or more ranges of values from a spreadsheet — google-sheets.sheets.spreadsheets.values.batchget

Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges.

This is a read operation. Provider rate limits and data access rules still apply.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
query.dateTimeRenderOption string Optional How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. enum: ["SERIAL_NUMBER","FORMATTED_STRING"]
query.majorDimension string Optional The major dimension that results should use. For example, if the spreadsheet data is: A1=1,B1=2,A2=3,B2=4, then requesting ranges=["A1:B2"],majorDimension=ROWS returns [[1,2],[3,4]], whereas requesting ranges=["A1:B2"],majorDimension=COLUMNS returns [[1,3],[2,4]]. enum: ["DIMENSION_UNSPECIFIED","ROWS","COLUMNS"]
query.ranges array Optional
query.ranges[] string Optional The A1 notation or R1C1 notation of the range to retrieve values from.
query.valueRenderOption string Optional How values should be represented in the output. The default render option is ValueRenderOption.FORMATTED_VALUE. enum: ["FORMATTED_VALUE","UNFORMATTED_VALUE","FORMULA"]
path object Required additionalProperties: false
path.spreadsheetId string Required The ID of the spreadsheet to retrieve data from.

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "spreadsheetId": "example"
  }
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Returns one or more ranges of values that match the specified data filters — google-sheets.sheets.spreadsheets.values.batchgetbydatafilter

Returns one or more ranges of values that match the specified data filters. For more information, see Read, write, and search metadata. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges that match any of the data filters in the request will be returned.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
path object Required additionalProperties: false
path.spreadsheetId string Required The ID of the spreadsheet to retrieve data from.
body — Required $ref: "#/definitions/BatchGetValuesByDataFilterRequest"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Sets values in one or more ranges of a spreadsheet — google-sheets.sheets.spreadsheets.values.batchupdate

Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOption, and one or more ValueRanges.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
path object Required additionalProperties: false
path.spreadsheetId string Required The ID of the spreadsheet to update.
body — Required $ref: "#/definitions/BatchUpdateValuesRequest"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Sets values in one or more ranges of a spreadsheet — google-sheets.sheets.spreadsheets.values.batchupdatebydatafilter

Sets values in one or more ranges of a spreadsheet. For more information, see Read, write, and search metadata. The caller must specify the spreadsheet ID, a valueInputOption, and one or more DataFilterValueRanges.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
path object Required additionalProperties: false
path.spreadsheetId string Required The ID of the spreadsheet to update.
body — Required $ref: "#/definitions/BatchUpdateValuesByDataFilterRequest"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Clears values from a spreadsheet — google-sheets.sheets.spreadsheets.values.clear

Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
path object Required additionalProperties: false
path.range string Required The A1 notation or R1C1 notation of the values to clear.
path.spreadsheetId string Required The ID of the spreadsheet to update.
body — Required $ref: "#/definitions/ClearValuesRequest"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "range": "example",
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Returns a range of values from a spreadsheet — google-sheets.sheets.spreadsheets.values.get

Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.

This is a read operation. Provider rate limits and data access rules still apply.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
query.dateTimeRenderOption string Optional How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. enum: ["SERIAL_NUMBER","FORMATTED_STRING"]
query.majorDimension string Optional The major dimension that results should use. For example, if the spreadsheet data in Sheet1 is: A1=1,B1=2,A2=3,B2=4, then requesting range=Sheet1!A1:B2?majorDimension=ROWS returns [[1,2],[3,4]], whereas requesting range=Sheet1!A1:B2?majorDimension=COLUMNS returns [[1,3],[2,4]]. enum: ["DIMENSION_UNSPECIFIED","ROWS","COLUMNS"]
query.valueRenderOption string Optional How values should be represented in the output. The default render option is FORMATTED_VALUE. enum: ["FORMATTED_VALUE","UNFORMATTED_VALUE","FORMULA"]
path object Required additionalProperties: false
path.range string Required The A1 notation or R1C1 notation of the range to retrieve values from.
path.spreadsheetId string Required The ID of the spreadsheet to retrieve data from.

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "range": "example",
    "spreadsheetId": "example"
  }
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Sets values in a range of a spreadsheet — google-sheets.sheets.spreadsheets.values.update

Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a valueInputOption.

This operation can change provider data. Review the input before allowing an agent to call it.

Connect and use

Parameters

Requiredness is local to the containing object. A required child is required only when its parent object or array item is provided. Alternative schemas are identified in the Constraints column; the linked full JSON Schema is authoritative.

Parameter Type Required in parent Description Constraints
query object Optional additionalProperties: false
query.$.xgafv string Optional V1 error format. enum: ["1","2"]
query.fields string Optional Selector specifying which fields to include in a partial response.
query.prettyPrint boolean Optional Returns response with indentations and line breaks. default: true
query.includeValuesInResponse boolean Optional Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values. If the range to write was larger than the range actually written, the response includes all values in the requested range (excluding trailing empty rows and columns).
query.responseDateTimeRenderOption string Optional Determines how dates, times, and durations in the response should be rendered. This is ignored if response_value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. enum: ["SERIAL_NUMBER","FORMATTED_STRING"]
query.responseValueRenderOption string Optional Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. enum: ["FORMATTED_VALUE","UNFORMATTED_VALUE","FORMULA"]
query.valueInputOption string Optional How the input data should be interpreted. enum: ["INPUT_VALUE_OPTION_UNSPECIFIED","RAW","USER_ENTERED"]
path object Required additionalProperties: false
path.range string Required The A1 notation of the values to update.
path.spreadsheetId string Required The ID of the spreadsheet to update.
body — Required $ref: "#/definitions/ValueRange"

Full JSON Schema

Full JSON Schema

Example input

{
  "path": {
    "range": "example",
    "spreadsheetId": "example"
  },
  "body": {}
}

At most 1 provider requests per invocation; timeout: 30 seconds.

Errors

Check the key's expiry, revocation, workspace and allowed operations.

Reuse the same idempotency key only for the same request.

The connection or provider limit has been reached. Check the receipt before retrying.

Test the connection

Open the integration's commands below to inspect parameters and examples. Start with a read command for an account or resource you can access. Refresh your client's tool list, use the returned tool name, and check the execution result and usage. Provider charges and permissions still apply. Never test a write against production data without reviewing it.

Official provider documentation

Type to search…

↑↓ navigate↵ selectEsc close