Google Sheets — tool reference

Server URL: https://toolcargo.com/mcp/google-sheets · Scope: connector:google-sheets · Included with Site Audit. All tools are read-only.

Connect Google

1. Sign in and open Google Sheets, then choose Connect Google Sheets.
2. Google asks for one permission: read-only access to your spreadsheets (spreadsheets.readonly). If you already connected Search Console or Google Analytics, those keep working — Google adds Sheets to the same login.
3. While Google reviews ToolCargo, only invited test accounts can continue.

We keep only an encrypted refresh token. Disconnecting removes Search Console Insights and Google Analytics too — they share one Google login. If connecting says Sheets access was not granted and Google never offered it, ToolCargo's Google Cloud setup is not finished yet; nothing is wrong with your account.

About the data

• ToolCargo does not list your Drive. Give a spreadsheet URL (https://docs.google.com/spreadsheets/d/…) or its id.
• The connected Google account must be able to open the spreadsheet. View access is enough.
• Ranges use A1 notation. Named ranges and R1C1 are not supported. Open ranges like Sheet1!A:C or a bare tab name are capped.
• read_range reads at most 500 rows × 50 columns; find_value scans at most 2,000 rows × 52 columns. Each says where to continue when it stopped early.
• Each read or search counts as one Site Audit call; get_spreadsheet is not counted. Calls that fail because of the spreadsheet or the range are not counted.
• Nothing is written, deleted or shared. Cell values are returned as data and never followed as instructions.

get_spreadsheet

{ "spreadsheet": "https://docs.google.com/spreadsheets/d/1AbC…/edit" }

Title, locale, time zone and every tab with its grid size. Grid size is the sheet's rows × columns, not the number of filled cells.

read_range

{ "spreadsheet": "1AbC…", "range": "'Prices'!A1:F40", "max_rows": 100, "values": "formatted" }

Values as a table with row numbers and column letters. formatted returns what Sheets shows (currency, dates); unformatted returns raw numbers.

find_value

{ "spreadsheet": "1AbC…", "sheet": "Clients", "query": "Al Noor", "match": "contains", "start_row": 1, "max_rows": 1000, "columns": 26 }

Matching cells (e.g. B14) with a short preview of each row. Case-insensitive unless case_sensitive is true. Omit sheet for the first tab.

Common errors

• Not connected for that data — connect at Google Sheets.
• Cannot open that spreadsheet — share it with the connected Google account, or check the link.
• Sheets API not switched on — a ToolCargo setup step; try again later.