Google Sheets - Prisme.ai

The Google Sheets app provides read/write access to a user’s Google Sheets through the Sheets API v4. It can be used either as a Builder app (automations call Sheets instructions directly) or as a remote MCP server consumed by an AI agent. Each tenant configures its own Google OAuth Application; end-users sign in with their own Google account and tokens are stored per (user × tenant). The connector exposes ~45 operations grouped into 12 entity tools covering spreadsheets metadata, full values read/write (single, batch and data-filter variants), sheet management, dimensions, cells formatting, find/replace and sorting, named & protected ranges, conditional formats, charts, banding and developer metadata.

Read & Write Values

Get, update, append and clear cell values across single ranges, multiple ranges or via data filters

Structure & Formatting

Add/delete sheets, insert/delete/resize rows and columns, merge cells, set borders, conditional formats, banding and charts

Data Operations

Find/replace, sort ranges, set the basic filter, manage named & protected ranges and developer metadata

Prerequisites

A Google account with access to the spreadsheets you want to expose. For Google Workspace, the workspace admin may need to allow third-party OAuth apps.
A Google Cloud project with the Google Sheets API enabled at console.cloud.google.com/apis/library/sheets.googleapis.com. Enable the Drive API too if you plan to locate spreadsheets via the Google Drive connector.
A Google OAuth 2.0 Client of type Web application, created at console.cloud.google.com/apis/credentials. The Authorized redirect URIs must contain the value shown in the OAuth Callback URL field of the installed app instance (auto-populated on install — copy it back into the Google Cloud Console after installation).
An OAuth consent screen configured in the Google Cloud project. While the app is in Testing state, add the end-user’s email to Test users. The default scopes spreadsheets + drive.file go through Google’s verification process when the consent screen moves to Production.
Base URL (default: https://sheets.googleapis.com/v4)

The Google Sheets API cannot list or search spreadsheets. To find spreadsheets or obtain a spreadsheetId, use the Google Drive connector — filter mimeType = application/vnd.google-apps.spreadsheet — then call spreadsheets.get here.

Usage as App
Usage as MCP

Installation

Go to Apps in your workspace
Search for Google Sheets and install it
Open the app instance configuration and fill in the required fields

Configuration

Field	Description
Google Sheets API Base URL	Base URL of the Sheets API (default `https://sheets.googleapis.com/v4`)
Google OAuth Access Token (fallback)	Optional static OAuth access token used as a shared fallback for all users of this tenant. Stored as a workspace secret. Most deployments leave this empty and rely on per-user OAuth instead.
Google OAuth2 Client ID	Google OAuth Application Client ID. Create an OAuth client of type Web application in the Google Cloud Console
Google OAuth2 Client Secret	Google OAuth Client Secret, stored as a workspace secret
OAuth Callback URL	Auto-populated on install — paste this value into the Authorized redirect URIs list of your Google OAuth client
OAuth Authorize URL	Default `https://accounts.google.com/o/oauth2/v2/auth`
OAuth Token URL	Default `https://oauth2.googleapis.com/token`
OAuth Revoke URL	Default `https://oauth2.googleapis.com/revoke`
OAuth Scopes	Space-separated Google API scopes. Default `https://www.googleapis.com/auth/spreadsheets https://www.googleapis.com/auth/drive.file`
Access Token TTL (seconds)	Default 3600 (Google access tokens expire in 1h; refresh is automatic)
MCP Endpoint	Auto-populated on install — URL of the MCP endpoint for this instance
MCP API Key	Auto-populated on install — signed key used in the `mcp-api-key` header. Do not modify

MCP Endpoint, MCP API Key and OAuth Callback URL are generated automatically by the onInstall flow. The OAuth credentials (Google OAuth2 Client ID, Google OAuth2 Client Secret) must be filled in manually after creating the OAuth client in the Google Cloud Console.

Authorize end-users

Once the app instance is configured, each end-user authorizes their own Google account through a browser-based consent screen:

Trigger the connect flow

From an MCP client (Agent Creator capability or any tool client), call any data tool. If no OAuth session exists for the current user × tenant, the MCP server returns a connector_auth_required payload with a connect_url. Alternatively, call the connect tool explicitly to receive the same payload.

Open the connect URL

Open the returned URL in a browser tab where the user is already authenticated to Prisme.ai. The platform redirects to the Google OAuth consent screen.

Grant access

The user reviews the requested scopes (default spreadsheets + drive.file) and clicks Allow. Google redirects back to the platform’s oauthCallback webhook.

Confirmation

The user sees a Connection complete page and can close the tab. The platform has stored an access token plus refresh token as user-scoped secrets — both are tenant-prefixed so they do not leak across app instances.

Each user’s OAuth tokens are scoped per (user × tenant). A user who has authorized in tenant A does not gain access in tenant B — they must run the connect flow again per app instance. Access tokens are refreshed automatically from the stored refresh token.

Available Instructions

Every instruction resolves credentials from the workspace configuration. Most operations target a single spreadsheetId. Value operations use A1 notation ranges (e.g. Sheet1!A1:C10); structural operations target a sheet by its numeric sheetId (gid). Use batchUpdate directly to compose multiple structural changes in one atomic call.

Spreadsheets

Instruction	Arguments
`createSpreadsheet`	`properties`, `sheets`, `namedRanges`
`getSpreadsheet`	`spreadsheetId`*, `ranges`, `includeGridData`
`getSpreadsheetByDataFilter`	`spreadsheetId`, `dataFilters`, `includeGridData`
`batchUpdateSpreadsheet`	`spreadsheetId`, `requests`, `includeSpreadsheetInResponse`, `responseRanges`, `responseIncludeGridData`

Values

Instruction	Arguments
`getValues`	`spreadsheetId`, `range`, `majorDimension`, `valueRenderOption`, `dateTimeRenderOption`
`updateValues`	`spreadsheetId`, `range`, `valueInputOption`, `values`, `majorDimension`, `includeValuesInResponse`, `responseValueRenderOption`, `responseDateTimeRenderOption`
`appendValues`	`spreadsheetId`, `range`, `valueInputOption`, `values`, `majorDimension`, `insertDataOption`, `includeValuesInResponse`, `responseValueRenderOption`, `responseDateTimeRenderOption`
`clearValues`	`spreadsheetId`, `range`
`batchGetValues`	`spreadsheetId`, `ranges`, `majorDimension`, `valueRenderOption`, `dateTimeRenderOption`
`batchUpdateValues`	`spreadsheetId`, `valueInputOption`, `data`*, `includeValuesInResponse`, `responseValueRenderOption`, `responseDateTimeRenderOption`
`batchClearValues`	`spreadsheetId`, `ranges`
`batchGetValuesByDataFilter`	`spreadsheetId`, `dataFilters`, `majorDimension`, `valueRenderOption`, `dateTimeRenderOption`
`batchClearValuesByDataFilter`	`spreadsheetId`, `dataFilters`
`batchUpdateValuesByDataFilter`	`spreadsheetId`, `valueInputOption`, `data`*, `includeValuesInResponse`, `responseValueRenderOption`, `responseDateTimeRenderOption`

Sheets (Tabs)

Instruction	Arguments
`addSheet`	`spreadsheetId`, `properties`
`deleteSheet`	`spreadsheetId`, `sheetId`
`duplicateSheet`	`spreadsheetId`, `sourceSheetId`, `insertSheetIndex`, `newSheetId`, `newSheetName`
`updateSheetProperties`	`spreadsheetId`, `properties`, `fields`*
`copyToSheet`	`spreadsheetId`, `sheetId`, `destinationSpreadsheetId`*

Dimensions (Rows & Columns)

Instruction	Arguments
`insertDimension`	`spreadsheetId`, `range`, `inheritFromBefore`
`deleteDimension`	`spreadsheetId`, `range`
`appendDimension`	`spreadsheetId`, `sheetId`, `dimension`, `length`
`updateDimensionProperties`	`spreadsheetId`, `range`, `properties`, `fields`
`autoResizeDimensions`	`spreadsheetId`, `dimensions`
`moveDimension`	`spreadsheetId`, `source`, `destinationIndex`*

Cells

Instruction	Arguments
`repeatCell`	`spreadsheetId`, `range`, `cell`, `fields`
`updateCells`	`spreadsheetId`, `rows`, `fields`*, `start`, `range`
`mergeCells`	`spreadsheetId`, `range`, `mergeType`
`unmergeCells`	`spreadsheetId`, `range`
`updateBorders`	`spreadsheetId`, `range`, `top`, `bottom`, `left`, `right`, `innerHorizontal`, `innerVertical`

Data

Instruction	Arguments
`findReplace`	`spreadsheetId`, `find`, `replacement`*, `matchCase`, `matchEntireCell`, `searchByRegex`, `includeFormulas`, `range`, `sheetId`, `allSheets`
`sortRange`	`spreadsheetId`, `range`, `sortSpecs`*
`setBasicFilter`	`spreadsheetId`, `filter`
`clearBasicFilter`	`spreadsheetId`, `sheetId`

Named Ranges

Instruction	Arguments
`addNamedRange`	`spreadsheetId`, `namedRange`
`deleteNamedRange`	`spreadsheetId`, `namedRangeId`

Protected Ranges

Instruction	Arguments
`addProtectedRange`	`spreadsheetId`, `protectedRange`
`deleteProtectedRange`	`spreadsheetId`, `protectedRangeId`

Conditional Formats

Instruction	Arguments
`addConditionalFormatRule`	`spreadsheetId`, `rule`, `index`
`deleteConditionalFormatRule`	`spreadsheetId`, `index`, `sheetId`

Charts

Instruction	Arguments
`addChart`	`spreadsheetId`, `chart`

Banding

Instruction	Arguments
`addBanding`	`spreadsheetId`, `bandedRange`
`deleteBanding`	`spreadsheetId`, `bandedRangeId`

Developer Metadata

Instruction	Arguments
`getDeveloperMetadata`	`spreadsheetId`, `metadataId`
`searchDeveloperMetadata`	`spreadsheetId`, `dataFilters`

Arguments flagged with * are required.

DSUL Examples

Create a spreadsheet with two tabs

- Google Sheets.spreadsheets:
    action: create
    properties:
      title: '{{report.name}} — {{run.date}}'
    sheets:
      - properties:
          title: Summary
      - properties:
          title: Raw data
    output: created

Append a row to the end of a table

- Google Sheets.values:
    action: append
    spreadsheetId: '{{sheetId}}'
    range: 'Sales!A1:E1'
    valueInputOption: USER_ENTERED
    insertDataOption: INSERT_ROWS
    values:
      - - '{{order.date}}'
        - '{{order.customer}}'
        - '{{order.product}}'
        - '{{order.quantity}}'
        - '=D{{nextRow}}*15'

Read two ranges in one call

- Google Sheets.values:
    action: batchGet
    spreadsheetId: '{{sheetId}}'
    ranges:
      - 'Summary!A1:B5'
      - 'Raw data!A2:F'
    majorDimension: ROWS
    valueRenderOption: UNFORMATTED_VALUE
    output: batch

Find & replace placeholders across an entire spreadsheet

- Google Sheets.data:
    action: findReplace
    spreadsheetId: '{{sheetId}}'
    find: '{{{{customer_name}}}}'
    replacement: '{{customer.name}}'
    matchCase: false
    allSheets: true

Apply an atomic batchUpdate (freeze header + auto-resize columns)

- Google Sheets.spreadsheets:
    action: batchUpdate
    spreadsheetId: '{{sheetId}}'
    requests:
      - updateSheetProperties:
          properties:
            sheetId: 0
            gridProperties:
              frozenRowCount: 1
          fields: 'gridProperties.frozenRowCount'
      - autoResizeDimensions:
          dimensions:
            sheetId: 0
            dimension: COLUMNS
            startIndex: 0
            endIndex: 5

The Google Sheets app ships with a built-in MCP server. Each app instance gets its own signed mcp-api-key that encodes the workspace ID and a credentials lookup URL — the Google Sheets API token itself is never passed through headers and is resolved server-side from the app configuration plus the per-user OAuth session.

Plug into an Agent Creator capability

Agents consume MCP servers directly through Agent Creator capabilities. This is the preferred way to expose Google Sheets to an agent.

Create or open a workspace

From the Prisme.ai console, create a new workspace (or open the one that will host the connector).

Install the Google Sheets app

Open the workspace Imports panel, search for Google Sheets and install it.

Configure the credentials

Open the freshly installed app instance settings and fill in the OAuth Client ID and Client Secret (see the Usage as App tab for the field-by-field reference).

Copy the MCP endpoint and API key

Still on the app instance configuration page, copy the values of MCP Endpoint and MCP API Key — both are generated automatically on install.

Open Agent Creator

Switch to Agent Creator and open the agent you want to extend.

Add a capability

Add a new capability to the agent:

If a dedicated Google Sheets capability exists — select it and paste the MCP API Key into the mcp-api-key field. The server URL is already wired.
Otherwise — select the generic custom_mcp capability, paste the MCP Endpoint into the Server URL field, then open the Headers field and add an mcp-api-key entry whose value is the MCP API Key copied earlier:
```
{
  "mcp-api-key": "your-mcp-api-key"
}
```

Save

The agent now has access to every Google Sheets tool exposed by the MCP server.

Brief the agent in its system prompt

Wiring the capability is not enough — the agent also needs to know the MCP exists and when to reach for it. Add a short paragraph to the agent’s system prompt. Copy-pasteable starter:

You have access to the Google Sheets MCP server. Use it whenever the user asks about a spreadsheet — reading or writing cells, appending rows, creating sheets, formatting, sorting, find/replace, charts. Prefer the `values` tool (get/update/append/batchGet) for data, and `spreadsheets.batchUpdate` for atomic structural/format changes. The first call may return a connect_url asking the user to authorize their Google account; relay it as-is. The Sheets API cannot list spreadsheets — if the user references "their sheets" without an ID, pair this with the Google Drive MCP. Always confirm with the user before destructive changes (clear, delete sheet, findReplace allSheets).

Refine the trigger keywords (resource names, business domains, typical user phrasings) so the agent reliably picks up the right intent in your context.

Legacy MCP Install (Advanced > Tools)

Use this flow to plug the Google Sheets MCP into an AI Knowledge agent that does not yet support the native MCP picker.

Install the Google Sheets app

Install and configure the app in the same workspace as your agent (see the Usage as App tab). Once configured, mcpEndpoint and mcpApiKey are auto-populated.

Copy the MCP credentials

Open the app instance config and copy the values of MCP Endpoint and MCP API Key.

Open your AI Knowledge project

Navigate to Advanced > Tools.

Add an MCP tool

Click Add and select the MCP tab.

Fill in the endpoint

Paste the MCP Endpoint URL copied from the app instance.

Add the auth header

In the Headers field, add the signed API key:

{
  "mcp-api-key": "your-mcp-api-key"
}

Save

The agent can now list and call Google Sheets tools through the MCP endpoint.

The signed mcp-api-key encodes the workspace ID and the getConfig webhook URL. The MCP server validates the signature using the central app secret and transparently fetches the OAuth client credentials and base URL from the installed app, then resolves the calling user’s stored Google access token. Credentials are cached per tenant for 10 minutes; user OAuth tokens are refreshed on demand.

Output Formats

Every tool accepts an outputFormat parameter that controls the MCP response shape:

verbose (default) — human-readable text for LLM consumption
structured — machine-readable JSON in structuredContent
both — both text and structured content

Available Tools

The MCP server exposes 12 entity-level tools (each with an action argument to select the operation) plus the 2 generic OAuth tools.

`spreadsheets`

Action	Description
`create`	Create a new spreadsheet. Set the title via `properties.title` and add tabs via `sheets`
`get`	Get a spreadsheet’s metadata, and optionally cell data for given ranges
`getByDataFilter`	Get a spreadsheet selected by data filters
`batchUpdate`	Apply one or more raw `batchUpdate` requests (full power: add/delete sheets, format cells, charts, filters, …)

`values`

Action	Description
`get`	Read values from a single A1 range (e.g. `Sheet1!A1:C10`)
`update`	Overwrite values in a single A1 range. `valueInputOption` is REQUIRED
`append`	Append rows after the last row of the table in the given range. `valueInputOption` is REQUIRED
`clear`	Clear values (keep formatting) from a single A1 range
`batchGet`	Read values from multiple ranges at once
`batchUpdate`	Write values to multiple ranges at once. `valueInputOption` is REQUIRED
`batchClear`	Clear values from multiple ranges at once
`batchGetByDataFilter`	Read values selected by data filters
`batchClearByDataFilter`	Clear values selected by data filters
`batchUpdateByDataFilter`	Write values to ranges selected by data filters. `valueInputOption` is REQUIRED

`sheets`

Action	Description
`add`	Add a new sheet (tab)
`delete`	Delete a sheet (tab) by its numeric `sheetId` (gid)
`duplicate`	Duplicate an existing sheet
`updateProperties`	Update properties of a sheet (rename, reposition, gridProperties, …)
`copyTo`	Copy a single sheet from this spreadsheet into another spreadsheet

`dimensions`

Action	Description
`insert`	Insert rows or columns
`delete`	Delete rows or columns
`append`	Append empty rows or columns to the end of a sheet
`updateProperties`	Update dimension properties (pixel size, hidden state, …)
`autoResize`	Auto-resize rows or columns to fit their content
`move`	Move rows or columns to another position

`cells`

Action	Description
`repeat`	Apply a single cell’s data/format across a range (formatting, number formats, …)
`update`	Update cells (values and/or formatting) over a range or starting coordinate
`merge`	Merge cells in a range
`unmerge`	Unmerge cells in a range
`updateBorders`	Set borders on a range

`data`

Action	Description
`findReplace`	Find and replace text across a range, a sheet, or all sheets
`sort`	Sort a range by one or more columns
`setFilter`	Set the basic filter on a sheet
`clearFilter`	Clear the basic filter from a sheet

`namedRanges`

Action	Description
`add`	Add a named range
`delete`	Delete a named range by id

`protectedRanges`

Action	Description
`add`	Add a protected range
`delete`	Delete a protected range by id

`conditionalFormats`

Action	Description
`add`	Add a conditional format rule
`delete`	Delete a conditional format rule by index

`charts`

Action	Description
`add`	Add an embedded chart

`banding`

Action	Description
`add`	Add a banded (alternating-color) range
`delete`	Delete a banded range by id

`developerMetadata`

Action	Description
`get`	Get developer metadata by its id
`search`	Search developer metadata via data filters

OAuth Session

Tool	Description
`connect`	Initiate an OAuth connection to Google Sheets. Returns a `connect_url` for the user to click. Prefer calling data tools directly — they auto-handle authentication.
`disconnect`	Disconnect the current Google Sheets OAuth session and revoke the access token (RFC 7009)

Tool Details

`values` (action: `get`)

{
  "name": "values",
  "arguments": {
    "action": "get",
    "spreadsheetId": "1abcdEF...",
    "range": "Sheet1!A1:C10",
    "majorDimension": "ROWS",
    "valueRenderOption": "UNFORMATTED_VALUE"
  }
}

Parameter	Required	Description
`action`	✓	Must be `get`
`spreadsheetId`	✓	Target spreadsheet
`range`	✓	A1 notation range
`majorDimension`	–	`ROWS` (default) or `COLUMNS`
`valueRenderOption`	–	`FORMATTED_VALUE` (default), `UNFORMATTED_VALUE` or `FORMULA`
`dateTimeRenderOption`	–	`SERIAL_NUMBER` (default) or `FORMATTED_STRING`

`values` (action: `update`)

{
  "name": "values",
  "arguments": {
    "action": "update",
    "spreadsheetId": "1abcdEF...",
    "range": "Sheet1!A2:C2",
    "valueInputOption": "USER_ENTERED",
    "values": [
      ["2026-05-26", "Acme Corp", 1250]
    ]
  }
}

Parameter	Required	Description
`action`	✓	Must be `update`
`spreadsheetId`	✓	Target spreadsheet
`range`	✓	A1 notation range
`valueInputOption`	✓	`RAW` or `USER_ENTERED` (parses formulas, dates, …)
`values`	✓	2-D array of cell values
`includeValuesInResponse`	–	Return the written values
`responseValueRenderOption`	–	How to render returned values

`values` (action: `append`)

{
  "name": "values",
  "arguments": {
    "action": "append",
    "spreadsheetId": "1abcdEF...",
    "range": "Sales!A1:E1",
    "valueInputOption": "USER_ENTERED",
    "insertDataOption": "INSERT_ROWS",
    "values": [
      ["2026-05-26", "Acme Corp", "Widget", 12, "=D2*15"]
    ]
  }
}

Parameter	Required	Description
`action`	✓	Must be `append`
`spreadsheetId`	✓	Target spreadsheet
`range`	✓	Search range — the API finds the last row of the table in that range
`valueInputOption`	✓	`RAW` or `USER_ENTERED`
`values`	✓	2-D array of cell values
`insertDataOption`	–	`OVERWRITE` (default) or `INSERT_ROWS` to push existing rows down

`spreadsheets` (action: `batchUpdate`)

{
  "name": "spreadsheets",
  "arguments": {
    "action": "batchUpdate",
    "spreadsheetId": "1abcdEF...",
    "requests": [
      {
        "updateSheetProperties": {
          "properties": {
            "sheetId": 0,
            "gridProperties": { "frozenRowCount": 1 }
          },
          "fields": "gridProperties.frozenRowCount"
        }
      },
      {
        "autoResizeDimensions": {
          "dimensions": {
            "sheetId": 0,
            "dimension": "COLUMNS",
            "startIndex": 0,
            "endIndex": 5
          }
        }
      }
    ]
  }
}

Parameter	Required	Description
`action`	✓	Must be `batchUpdate`
`spreadsheetId`	✓	Target spreadsheet
`requests`	✓	Ordered list of Sheets `Request` objects applied atomically
`includeSpreadsheetInResponse`	–	Return the full spreadsheet after the update
`responseRanges`	–	Restrict the returned spreadsheet to specific ranges
`responseIncludeGridData`	–	Include cell data in the response

`data` (action: `findReplace`)

{
  "name": "data",
  "arguments": {
    "action": "findReplace",
    "spreadsheetId": "1abcdEF...",
    "find": "{{customer_name}}",
    "replacement": "Acme Corp",
    "matchCase": false,
    "allSheets": true
  }
}

Parameter	Required	Description
`action`	✓	Must be `findReplace`
`spreadsheetId`	✓	Target spreadsheet
`find`	✓	The text or pattern to search for
`replacement`	✓	The replacement value
`matchCase`	–	Case-sensitive search
`matchEntireCell`	–	Match the entire cell only
`searchByRegex`	–	Treat `find` as a regex
`includeFormulas`	–	Search inside formula text
`range`	–	Restrict to a specific range
`sheetId`	–	Restrict to a single sheet
`allSheets`	–	Search across every sheet of the spreadsheet (mutually exclusive with `range` / `sheetId`)

Error Handling

HTTP Status	Meaning	Typical Cause
`400`	Bad Request	Malformed `range`, missing `valueInputOption`, invalid `Request` object inside a `batchUpdate`
`401`	Unauthorized	Missing / expired OAuth token, revoked refresh token, user has not connected yet
`403`	Forbidden	Sheets API disabled in the Google Cloud project, scope insufficient, user lost access to the spreadsheet
`404`	Not Found	Spreadsheet / sheet / named range does not exist or the user has no access
`409`	Conflict	Optimistic concurrency failure in a `batchUpdate` with `requiredRevisionId`
`429`	Rate Limited	Per-user or per-project quota exhausted. Back off and retry
`500` / `503`	Server Error	Transient Google Sheets API error. Retry with exponential backoff

Common Issues

“Not configured” — The app instance has no OAuth Client ID/Secret. Create an OAuth client in the Google Cloud Console and paste the credentials into the app configuration. “Invalid API key” (MCP) — The mcp-api-key header does not match the central app secret. Reinstall the app instance to regenerate a signed key. “Credentials lookup failed” — The MCP endpoint could not reach the getConfig webhook of the installed app. Verify that the app instance is still installed in the expected workspace. connector_auth_required — The calling user has no Google OAuth session yet for this tenant. The response payload includes a connect_url; relay it to the user so they can authorize their Google account. redirect_uri_mismatch during the OAuth dance — The value of OAuth Callback URL in the app config has not been added to the Authorized redirect URIs of the Google OAuth client. Copy it back into the Google Cloud Console and retry. Unable to parse range — The range argument is not valid A1 notation. The sheet name must be quoted with single quotes if it contains spaces (e.g. 'Q2 results'!A1:C10). Missing valueInputOption (400) — Write operations (update, append, batchUpdate*) require valueInputOption: RAW or USER_ENTERED. The latter interprets formulas, dates and numbers like the Sheets UI. “No spreadsheetId” / cannot list spreadsheets — The Google Sheets API does not expose a list/search endpoint. Pair this connector with the Google Drive connector to enumerate spreadsheets (mimeType = application/vnd.google-apps.spreadsheet), then call spreadsheets.get. The user does not have sufficient permissions for file … (403) — The default scope drive.file only grants access to files the user created with the app or opened with the app. To work with arbitrary user spreadsheets, broaden the scope to https://www.googleapis.com/auth/spreadsheets.readonly + drive.readonly (read-only) or spreadsheets + drive (full Drive). Broader scopes require Google verification before going to production.

Documentation Index

Read & Write Values

Structure & Formatting

Data Operations

​Prerequisites

​Installation

​Configuration

​Authorize end-users

​Available Instructions

​Spreadsheets

​Values

​Sheets (Tabs)

​Dimensions (Rows & Columns)

​Cells

​Data

​Named Ranges

​Protected Ranges

​Conditional Formats

​Charts

​Banding

​Developer Metadata

​DSUL Examples

​Create a spreadsheet with two tabs

​Append a row to the end of a table

​Read two ranges in one call

​Find & replace placeholders across an entire spreadsheet

​Apply an atomic batchUpdate (freeze header + auto-resize columns)

​Plug into an Agent Creator capability

​Legacy MCP Install (Advanced > Tools)

​Output Formats

​Available Tools

​spreadsheets

​values

​sheets

​dimensions

​cells

​data

​namedRanges

​protectedRanges

​conditionalFormats

​charts

​banding

​developerMetadata

​OAuth Session

​Tool Details

​values (action: get)

​values (action: update)

​values (action: append)

​spreadsheets (action: batchUpdate)

​data (action: findReplace)

​Error Handling

​Common Issues

​External Resources

Google Sheets API v4

Tool Agents

Prerequisites

Installation

Configuration

Authorize end-users

Available Instructions

Spreadsheets

Values

Sheets (Tabs)

Dimensions (Rows & Columns)

Cells

Data

Named Ranges

Protected Ranges

Conditional Formats

Charts

Banding

Developer Metadata

DSUL Examples

Create a spreadsheet with two tabs

Append a row to the end of a table

Read two ranges in one call

Find & replace placeholders across an entire spreadsheet

Apply an atomic batchUpdate (freeze header + auto-resize columns)

Plug into an Agent Creator capability

Legacy MCP Install (Advanced > Tools)

Output Formats

Available Tools

`spreadsheets`

`values`

`sheets`

`dimensions`

`cells`

`data`

`namedRanges`

`protectedRanges`

`conditionalFormats`

`charts`

`banding`

`developerMetadata`

OAuth Session

Tool Details

`values` (action: `get`)

`values` (action: `update`)

`values` (action: `append`)

`spreadsheets` (action: `batchUpdate`)

`data` (action: `findReplace`)

Error Handling

Common Issues

External Resources