--- title: "Google Sheets" description: "Read spreadsheet metadata and A1 ranges, fetch multiple ranges, create spreadsheets, update or append values, clear ranges and apply batch spreadsheet changes. Commands use Google’s official Sheets v4 API and preserve ce" --- > Documentation Index > Fetch the complete documentation index at: https://help.tooluse.net/llms.txt > Use this file to discover all available pages before exploring further. # Google Sheets

Read spreadsheet metadata and A1 ranges, fetch multiple ranges, create spreadsheets, update or append values, clear ranges and apply batch spreadsheet changes. Commands use Google’s official Sheets v4 API and preserve cell types and rendering options. Only the selected command and explicit ranges are sent; no spreadsheet or next-page scan runs automatically. Read-only selections request spreadsheet read access; selected writes require renewed write authorization.

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

Open the integration's connection form to check the available credential source. The source has not been resolved for this documentation export. The instructions below apply when using your own provider account.

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

Run Applies one or more updates to the spreadsheet with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Creates a spreadsheet, returning the newly created spreadsheet. with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Returns the spreadsheet at the given ID with Google Sheets. This is a read command; it does not grant access beyond the connected account's permissions.

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

Run Returns the spreadsheet at the given ID with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Returns the developer metadata with the specified ID with Google Sheets. This is a read command; it does not grant access beyond the connected account's permissions.

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

Run Copies a single sheet from a spreadsheet to another spreadsheet with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Appends values to a spreadsheet with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Clears one or more ranges of values from a spreadsheet with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Clears one or more ranges of values from a spreadsheet with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Returns one or more ranges of values from a spreadsheet with Google Sheets. This is a read command; it does not grant access beyond the connected account's permissions.

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

Run Returns one or more ranges of values that match the specified data filters with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Sets values in one or more ranges of a spreadsheet with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Sets values in one or more ranges of a spreadsheet with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Clears values from a spreadsheet with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Run Returns a range of values from a spreadsheet with Google Sheets. This is a read command; it does not grant access beyond the connected account's permissions.

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

Run Sets values in a range of a spreadsheet with Google Sheets. This command can change provider data. Review the target and input before invoking it.

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

Source: https://help.tooluse.net/integrations/google-sheets/index.mdx