A1 Google Sheets MCP
A1 Google Sheets MCP lets an AI app authenticate with Google and perform read/write, structural, formatting, charting, sharing, and raw API operations on Google Sheets.
Connect/authenticate: check auth status, get setup instructions, save an OAuth client, start/finish login, and log out.
Find/create/inspect spreadsheets: search spreadsheets by name (Drive scope required), create spreadsheets with tabs/locale/time zone, and retrieve spreadsheet metadata/structure.
Read and write values: read one or many A1 ranges (formatted, raw, or formulas), overwrite ranges, batch-write multiple ranges, append rows, and clear values while keeping formatting.
Manage sheets/tabs: add, duplicate, rename, delete, and copy sheets to another spreadsheet.
Format and lay out sheets: apply cell formatting, number formats, colors, fonts, alignment, wrapping, borders, frozen rows/columns, and row/column resizing, insertion, deletion, hiding, showing, grouping, or ungrouping.
Manage rules and structure: set/clear data validation and dropdowns, protect ranges, manage conditional formatting, and create/update/delete structured tables.
Build charts: add, update, and delete column, bar, line, area, stepped-area, scatter, and pie charts, including raw ChartSpec support.
Share and access: list, grant, update, and revoke spreadsheet permissions (Drive scope required).
Use raw API access: call Google Sheets API v4 paths for unsupported features such as merges, named ranges, banding, filters, slicers, find/replace, gradient conditional formats, developer metadata, or atomic batch updates.
Provides tools for interacting with Google Sheets, including searching and creating spreadsheets, reading and writing cell ranges, appending rows, managing sheets, formatting, data validation, protected ranges, conditional formats, structured tables, charts, and sharing access.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@A1 Google Sheets MCP Find the quarterly budget spreadsheet and summarize each sheet."
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Google Sheets MCP
English | Русский
A1 Google Sheets MCP lets an AI app work with Google Sheets in plain language. Find a spreadsheet, read its data, write and append rows, shape sheets and formatting, build charts and share the result.
It uses the Google Sheets API with your Google account. It separates reading from writing, keeps destructive operations explicit and makes the limits of the Sheets API clear instead of implying that every spreadsheet task is possible.
26 tools. Search and create spreadsheets, read and write ranges, manage sheets, formatting, data validation, protected ranges, conditional formats, structured tables, charts and access.
Connects from the conversation. Say "connect Google Sheets": the server walks you through the OAuth client, catches Google's redirect on
127.0.0.1with PKCE and keeps the tokens itself — no config files, no restart.Writes are deliberate. A write is never replayed after an ambiguous failure — a replayed append would duplicate rows — and destructive tools are marked so your AI client can ask first.
Sheets only. Drive is an internal dependency for spreadsheet search and sharing alone; there is no generic Drive tool, and
raw_requestcannot reach Drive.Minimal Google scopes.
spreadsheetscovers every Sheets tool; a Drive scope is needed only for spreadsheet search and sharing.
Start with a read-only question:
Find the quarterly budget spreadsheet and summarize what each of its sheets contains.
Connect the server · Explore use cases · Open technical documentation
See it work in a minute
You: Show me the structure of the sales report spreadsheet — its sheets, their sizes and frozen rows.
Assistant: Shows the sheets with their sizes, frozen headers and the objects on them. Nothing changes.
You: Prepare a “March” sheet as a copy of “February” and clear the numbers, keeping the layout.
Assistant: Shows the plan — duplicate the sheet, rename it and clear the data ranges — then asks for confirmation before changing anything.
You: Confirm.
Assistant: Duplicates the sheet and clears the values. Formatting, data validation and frozen rows stay.
Related MCP server: Google Sheets MCP Server
Contents
Quick start
You need Node.js 20+ and a Google account. Credentials are not required at install time — the server connects from the conversation.
Add the server to your AI app.
Say "connect Google Sheets": the assistant walks you through creating the OAuth client and approving access without editing config files.
Ask the read-only question above.
In the app: open Settings → MCP servers, select Add server, choose STDIO, enter the command npx -y @a1-x-tech/mcp-google-sheets@latest and environment variables GOOGLE_SHEETS_CLIENT_ID, GOOGLE_SHEETS_CLIENT_SECRET, GOOGLE_SHEETS_REFRESH_TOKEN, then select Save and Restart.
From the command line:
codex mcp add google-sheets \
-- npx -y @a1-x-tech/mcp-google-sheets@latestcodex mcp listclaude mcp add \
--transport stdio --scope user google-sheets \
-- npx -y @a1-x-tech/mcp-google-sheets@latestclaude mcp listThe current official path is Settings → Extensions. For a custom desktop extension, open Advanced settings → Extension Developer → Install Extension…, select a .mcpb file and follow the prompts.
This repository currently publishes an npm stdio package and does not contain a .mcpb bundle. For Claude Desktop builds that still support local configuration, use the following JSON stdio configuration as a fallback:
{
"mcpServers": {
"google-sheets": {
"command": "npx",
"args": ["-y", "@a1-x-tech/mcp-google-sheets@latest"]
}
}
}In those builds, save it to ~/Library/Application Support/Claude/claude_desktop_config.json on macOS or %APPDATA%\Claude\claude_desktop_config.json on Windows.
Claude Desktop MCP documentation
Add this to ~/.cursor/mcp.json on macOS/Linux or %USERPROFILE%\.cursor\mcp.json on Windows:
{
"mcpServers": {
"google-sheets": {
"type": "stdio",
"command": "npx",
"args": ["-y", "@a1-x-tech/mcp-google-sheets@latest"]
}
}
}Run MCP: Open User Configuration and add:
{
"servers": {
"google-sheets": {
"type": "stdio",
"command": "npx",
"args": ["-y", "@a1-x-tech/mcp-google-sheets@latest"]
}
}
}Check it with MCP: List Servers.
What you can ask it to do
Find and read data
Find the newest spreadsheet with “budget” in the name and show its structure.
Read
'Q3'!A1:F50and summarize the totals.Show the formulas behind the Summary sheet.
Update the numbers
Write this table into
Sheet1!A1, formulas included.Append today’s figures as a new row of the log.
Update several ranges in one batch, or clear a draft range while keeping its formatting.
Shape and present
Add a “March” sheet, freeze the header row and make it bold.
Highlight negative amounts in red with a conditional format and add borders.
Build a column chart of revenue by month on its own sheet.
Turn the data into a structured table and add a dropdown with data validation.
Protect and share
Protect the totals row so only I can edit it.
Give a colleague edit access and everyone else read-only.
Show who currently has access to the file.
How a spreadsheet changes
Values tools address cells in A1 notation (
'Sheet name'!A1:C10); structural tools (sheets, formatting, rules, tables, charts) address a numeric sheetId with 0-based indexes.get_spreadsheetsupplies the ids — sheet titles are not addresses.A write overwrites its range;
append_valuesadds rows after the last data row; anullcell is skipped, not cleared.clear_valuesempties values and formulas but keeps formatting, data validation, notes and merges. There is no undo through the API — deleting a sheet, rows or columns destroys their data.Batch tools carry several ranges or requests in one call and count once against the quota; a
batchUpdateis atomic — all of its requests apply or none do.
Some spreadsheet features have no dedicated tool: merged cells, named ranges, banding, filters, slicers, find-and-replace and gradient conditional-format rules go through raw_request, which is limited to the Sheets API origin. A new spreadsheet lands in the My Drive root — moving it into a folder is not covered, and manage_permissions cannot transfer ownership.
What can change
Operation | What happens | Confirmation boundary |
Read metadata or values | Reads structure and cells | No change |
Create a spreadsheet | Adds a file to My Drive | Changes Google Sheets |
Write, batch-write or append values | Overwrites cells or adds rows | Changes a spreadsheet |
Format, freeze, borders, dimensions, validation, rules, tables, charts | Changes presentation, structure and rules | Changes a spreadsheet |
Clear values or delete a sheet, rows or columns | Removes data with no undo through the API | Destructive |
Manage protected ranges and permissions | Changes who can open or edit the file | Changes access |
Raw API request | Can call API methods without a dedicated tool | Potentially destructive |
The AI client controls confirmation prompts. The server marks reads, writes and destructive tools so the client can distinguish an inspection from a live change.
Getting access
Google Sheets requires OAuth 2.0; an API key is not enough. There are two ways in, and the first one needs no configuration files.
Connect from the chat (recommended)
Say "connect Google Sheets" and the assistant runs the flow with you:
setup_instructionsprints the checklist: create or select a Google Cloud project, enable Google Sheets API, configure the consent screen and create a Desktop app OAuth client.Download that client's JSON ("Download JSON") and give the assistant its path —
set_clientstores it owner-only. The secret never goes through the conversation.start_loginreturns a Google consent link. Open it on this machine and approve; the code comes back to a one-shot listener on127.0.0.1(PKCE), never through the chat.finish_loginexchanges the code and saves the tokens to~/.config/mcp-google-sheets/credentials.json(mode 0600).
The tokens are re-read on every call, so the connection works immediately — no restart of the AI app. auth_status shows what is connected, logout revokes and deletes it.
Environment variables (CI, unattended installs)
Create or select a Google Cloud project and enable the Google Sheets API. Also enable the Google Drive API if you want spreadsheet search and sharing.
Configure the OAuth consent screen and create a Desktop app OAuth client.
Authorize the Google account that owns or can edit the spreadsheets. The OAuth 2.0 Playground can obtain the refresh token when Use your own OAuth credentials is enabled.
Request the minimal scope:
https://www.googleapis.com/auth/spreadsheetsIt covers every Sheets tool. Only
search_spreadsheetsandmanage_permissionsneed a Drive scope on top:https://www.googleapis.com/auth/drive, ordrive.readonlyfor search alone, ordrive.filefor files created through this app.
Testing-mode OAuth refresh tokens can expire after seven days. Publish the OAuth app, or use an Internal app in a Workspace domain, when you need long-lived access. Treat the client secret and refresh token as passwords.
Configuration
Every variable is optional — with none of them the server connects from the chat.
Variable | Required | Description |
| No* | OAuth client ID. |
| No* | OAuth client secret. |
| No* | OAuth refresh token. |
| No* | Short-lived (~1 h) alternative to the OAuth trio. |
| No | Fixed loopback port for the in-chat login; useful over SSH port forwarding. |
| No | Google Sheets API base URL override. |
| No | Per-request timeout; default |
| No | Temporary-error retries; default |
* Provide either the OAuth trio or an access token. Without credentials the server still starts and lists its tools; the first call names the variables to set.
Data, limits and background work
Requests go to Google. The local server refreshes Google OAuth tokens and calls the Sheets API — and, for spreadsheet search and sharing only, the Drive API. Its anonymous telemetry contains an installation ID, package version, AI client and platform versions, and tool names — never OAuth tokens, spreadsheet data, tool arguments or prompts. For each tool call it also sends the outcome and, on failure, an excerpt of the error text with e-mails, addresses, tokens, numbers of 4+ digits and quoted text replaced by
#; a value from your request can appear in it if the error text contains it. SetASKADS_TELEMETRY=0to opt out.Google applies per-minute quotas. The documented limits are 300 reads and 300 writes per minute per project, and 60 of each per user; a batch call counts once however many ranges or requests it carries. A spreadsheet holds at most 10,000,000 cells. On
429, the server uses backoff; reads also retry after network and5xxerrors, while writes are not replayed after an uncertain failure.There is no background polling. The server runs only when called. If your AI app supports scheduled tasks, it can check a spreadsheet periodically.
Technical documentation
MCP capability catalog — task-oriented pages for every tool.
Support
Found a bug or need a scenario? Create an issue or write in Telegram.
Available Tools
26 toolsappend_valuesAppend rowsA
Appends rows after the last row of the data table that contains the given range — pass the table's region (e.g. "Sheet1!A1:D1" or just "Sheet1") and the API finds the first free row itself; the response's updates.updatedRange shows where the rows actually landed. insert_data_option INSERT_ROWS pushes existing data below down; OVERWRITE (default behaviour) writes into the free rows after the table. Never retried after an ambiguous failure — re-appending would duplicate the rows, so check the sheet first (read_values) before re-sending.
Inputs: range (required), values (required), spreadsheet_id (required), insert_data_option, +1 more.
auth_statusGoogle connection statusARead-onlyIdempotent
Shows whether this server is connected to Google: token presence and source (env variables or a stored in-chat login), expiry, the Google account email, granted vs missing OAuth scopes, where the credentials file lives and where the OAuth client comes from. Makes no network calls and never returns the token itself. Call it first when other tools report the server is not connected.
Inputs: no named parameters.
batch_write_valuesWrite values to many rangesADestructiveIdempotent
Overwrites several A1 ranges in ONE call — one write against the per-minute quota instead of one per range, so always prefer this over looping write_values. data is a list of {range, values} pairs; all are written with the same value_input_option (USER_ENTERED parses formulas/numbers/dates, RAW stores literally). Returns totalUpdatedCells and a per-range responses[] breakdown. Like write_values, null entries skip cells rather than clearing them.
Inputs: data (required), spreadsheet_id (required), value_input_option.
clear_valuesClear valuesADestructive
Empties the VALUES of one or more A1 ranges in a single call — cell contents and formulas are gone (no undo through the API), while formatting, data validation, notes, conditional formats and merges all stay. To also remove formatting use format_cells or raw_request; to delete whole rows/columns (not just their content) use manage_dimensions action=delete.
Inputs: ranges (required), spreadsheet_id (required).
create_spreadsheetCreate a spreadsheetA
Creates a new Google Sheets spreadsheet and returns it: spreadsheetId, spreadsheetUrl, properties (title, locale, timeZone) and sheets[] with each sheet's numeric sheetId. sheet_titles creates one tab per title in order (omitted = a single default "Sheet1"). The file lands in the authorized user's My Drive root — moving it into a folder needs the Drive API, which this server does not cover. Save the returned spreadsheetId: the Sheets API has no list endpoint of its own (search_spreadsheets exists, but it needs a Drive scope on the token).
Inputs: title (required), locale, time_zone, sheet_titles.
finish_loginFinish the Google loginAIdempotent
Second step: waits up to 20 s for the browser consent to finish, saves the tokens to an owner-only file and verifies the login with a read-only identity call, returning the account email and the granted scopes. After success every tool works immediately — no client restart. If the user granted only part of the requested permissions, the login is still saved and missingScopes lists what will not work. Logging in under a different Google account replaces the previous login (its refresh token is revoked best-effort) and the response carries previousAccountEmail so the change never goes unnoticed.
Inputs: no named parameters.
format_cellsFormat cellsADestructiveIdempotent
Applies cell formatting to a range: background_color, text color/bold/italic/strikethrough/underline/font_size/font_family, horizontal/vertical alignment, wrap_strategy, and number format (number_format_type NUMBER/PERCENT/CURRENCY/DATE/TIME/DATE_TIME/SCIENTIFIC/TEXT with an optional number_format_pattern like "#,##0.00" or "dd.mm.yyyy"). Only the provided properties are touched — the update mask is computed automatically, so existing formatting outside it survives; at least one formatting field is required. The range is a grid rectangle addressed by sheet_id + 0-based indexes (get sheet_id from get_spreadsheet). Colors are "#RRGGBB" hex strings.
Inputs: range (required), spreadsheet_id (required), bold, italic, +11 more.
get_spreadsheetGet spreadsheet metadataARead-onlyIdempotent
Returns the spreadsheet's structure: properties (title, locale, timeZone), sheets[] with properties (sheetId, title, index, gridProperties incl. rowCount/columnCount and frozenRowCount/frozenColumnCount), plus each sheet's protectedRanges, conditionalFormats, tables and charts, and the spreadsheet's namedRanges. Call this FIRST whenever a structural tool needs a sheetId, protectedRangeId, tableId, chartId or a conditional-format rule index — titles are not addresses. By default no cell data is returned; include_grid_data=true (optionally limited to ranges) embeds cells but is heavy — prefer read_values for data. fields is a partial-response mask to trim the payload, e.g. "sheets.properties".
Inputs: spreadsheet_id (required), fields, ranges, include_grid_data.
logoutDisconnect from GoogleADestructive
Revokes the stored token at Google (oauth2.googleapis.com/revoke) and deletes the local credentials file. Tokens supplied via env variables are NOT touched — remove them from the MCP client config manually; envTokenStillSet in the response says whether any are still in effect.
Inputs: no named parameters.
manage_chartsManage chartsADestructive
Manages embedded charts. action=add builds a chart from chart_type (COLUMN/BAR/LINE/AREA/STEPPED_AREA/SCATTER/PIE), domain_range (x-axis labels / pie labels), series_ranges (one grid range per data series; PIE takes exactly one) and optional title/legend_position/header_count (rows of the ranges treated as headers, default 1) — place it with anchor {sheet_id,row_index,column_index} (the cell under the chart's top-left corner) or new_sheet=true for its own chart sheet; the reply carries the new chartId. Ranges should be single columns (or rows) including the header cell. For chart kinds beyond the basic set (combo, waterfall, histogram, org …) pass a raw Sheets API ChartSpec via spec instead — it overrides the simplified fields. action=update REPLACES the whole spec of an existing chart (chart_id + the same spec-building fields; there is no partial chart update). action=delete removes the chart by chart_id. Find chartIds via get_spreadsheet (sheets[].charts).
Inputs: action (required), spreadsheet_id (required), spec, title, +8 more.
manage_conditional_formatsManage conditional formattingADestructive
Manages conditional-format rules that style cells when a condition holds (boolean rules; gradient color scales need raw_request). Rules are addressed by SHEET + INDEX in that sheet's rule list — get current rules and indexes from get_spreadsheet (sheets[].conditionalFormats), and re-read after every mutation because add/delete shift later indexes. action=add inserts a rule at index (default 0 = highest priority; rules are evaluated in order and the first match wins): needs ranges, condition_type (+condition_values; CUSTOM_FORMULA with a "=..." formula is the most flexible) and at least one format field (background_color, text_color, bold, italic). action=update replaces the ENTIRE rule at sheet_id+index with the newly provided one. action=delete removes the rule at sheet_id+index.
Inputs: action (required), spreadsheet_id (required), bold, index, +7 more.
manage_dimensionsManage rows and columnsADestructive
Row/column operations on a run of rows (dimension=ROWS) or columns (dimension=COLUMNS), addressed by sheet_id + 0-based start_index (inclusive) and end_index (exclusive) — e.g. columns A-C = start 0, end 3. action=resize sets an exact pixel_size; auto_resize fits to content; insert adds empty rows/columns at start_index (inherit_from_before=true copies formatting from the row/column before instead of after); delete removes them WITH their data (irreversible; cell references below/right shift); hide/show toggle visibility without touching data; group/ungroup add or remove a collapsible outline group over the run (groups nest — repeat group on a subrange for a deeper level).
Inputs: action (required), sheet_id (required), dimension (required), end_index (required), +4 more.
manage_permissionsManage spreadsheet accessADestructive
Shares the spreadsheet (Drive permissions on the file — the OAuth token needs a Drive scope; the spreadsheets scope alone gets 403 here while every Sheets tool still works). action=list shows who has access: id, type, role, emailAddress/domain per permission; one page per call (shared-drive files cap a page at 100) — when the reply carries nextPageToken, pass it back as page_token for the rest. action=grant gives role reader/commenter/writer to type user/group (email_address required), domain (domain required, e.g. "example.com") or anyone (makes the link public — use deliberately); send_notification_email (default true for users) and email_message control the notification, allow_file_discovery lets domain/anyone grants surface in search. action=update changes an existing permission's role (permission_id + role). action=revoke removes a permission (permission_id) — the person loses access immediately. Ownership transfer is not supported by this server. Protecting individual ranges from co-editors is manage_protected_ranges, not this tool.
Inputs: action (required), spreadsheet_id (required), role, type, +8 more.
manage_protected_rangesManage protected rangesADestructive
Manages protections that stop other editors from changing cells. action=add protects a grid range (or a named range via named_range_id; a range with only sheet_id protects the whole sheet): warning_only=true merely warns before edits, otherwise only the listed editor_users/editor_groups (emails) plus the owner may edit — note the calling user is NOT added automatically. Returns the new protectedRangeId in the replies. action=update changes description/warning_only/editors of an existing protection (protected_range_id required; provided fields replace the old values). action=delete removes the protection — the cells and data stay, but anyone with edit access can change them again. Find existing protectedRangeIds via get_spreadsheet.
Inputs: action (required), spreadsheet_id (required), range, description, +5 more.
manage_sheetsManage sheetsADestructive
Manages the sheets (tabs) of a spreadsheet. action=add creates a tab (title required; optional index position and row_count/column_count — default 1000×26). action=duplicate copies a tab within the same spreadsheet (sheet_id; optional title for the copy and index). action=rename changes a tab's title (sheet_id + title; the numeric sheetId never changes, so other tools keep working). action=delete removes the tab AND all its data — irreversible through the API, and deleting the last remaining sheet fails. action=copy_to copies a tab into ANOTHER spreadsheet (sheet_id + destination_spreadsheet_id; the copy arrives named "Copy of ..." — rename it there). Get sheet_id values from get_spreadsheet; every action except add returns batchUpdate replies with the affected sheet's properties.
Inputs: action (required), spreadsheet_id (required), index, title, +4 more.
manage_tablesManage tablesADestructive
Manages structured tables (the "Convert to table" feature: named ranges with per-column types, filters and formatting). action=add creates a table over a grid range whose FIRST ROW becomes the header: name (must be unique in the spreadsheet) + range required; column_properties optionally types the columns — a list of raw TableColumnProperties objects, e.g. [{"columnIndex":0,"columnName":"Task","columnType":"TEXT"},{"columnIndex":1,"columnName":"Done","columnType":"BOOLEAN"}] (columnType TEXT/PERCENT/DROPDOWN/DOUBLE/CURRENCY/DATE/TIME/DATE_TIME/BOOLEAN; DROPDOWN adds dataValidationRule). The reply carries the new table with its tableId. action=update renames and/or re-ranges an existing table (table_id + name and/or range; expanding the range grows the table). action=delete removes the TABLE DEFINITION only — the cell data stays; clear the cells separately if needed. Find tableIds via get_spreadsheet (sheets[].tables).
Inputs: action (required), spreadsheet_id (required), name, range, +2 more.
raw_requestRaw Google Sheets API callADestructive
Escape hatch to call any Google Sheets API v4 path directly, for requests the typed tools don't cover — e.g. a batchUpdate with mergeCells, named ranges, banding, basic filters, slicers, sortRange, findReplace, gradient conditional-format rules, developer metadata, or several requests in one atomic call: path "v4/spreadsheets/:batchUpdate", method POST, body {"requests":[...]}. The path may carry a query string. The Bearer token is added automatically; the method defaults to GET (values updates use PUT). Sheets API paths only — Drive paths are not reachable here.
Inputs: path (required), body, method.
read_valuesRead valuesARead-onlyIdempotent
Reads one or more A1 ranges in a single call (one request against the quota, however many ranges) and returns valueRanges[] — each with its resolved range and a 2-D values array (outer = rows unless major_dimension=COLUMNS). Trailing empty rows/columns are omitted; a fully empty range has no values key at all. value_render_option: FORMATTED_VALUE (default, strings as displayed, honoring the cell's number format and locale), UNFORMATTED_VALUE (raw numbers/booleans), FORMULA (the formula text, e.g. "=SUM(A1:A10)" — the way to read formulas). With UNFORMATTED_VALUE, dates arrive as serial numbers unless date_time_render_option=FORMATTED_STRING.
Inputs: ranges (required), spreadsheet_id (required), major_dimension, value_render_option, +1 more.
search_spreadsheetsSearch spreadsheetsARead-onlyIdempotent
Finds Google Sheets spreadsheets the authorized user can open (own files and shared drives; trashed files are excluded): id, name, createdTime, modifiedTime, owners and webViewLink per file, newest-modified first by default. name_contains filters by name substring; omit it to list everything. Paginate with page_token from nextPageToken. This is the one read that goes through the Drive API internally, so the OAuth token needs a Drive scope (drive, drive.readonly or drive.file for app-created files) — with only the spreadsheets scope it fails with 403 while every other tool still works.
Inputs: order_by, page_size, page_token, name_contains.
set_bordersSet cell bordersADestructiveIdempotent
Draws borders around and/or inside a grid range. top/bottom/left/right are the range's outer edges; inner_horizontal/inner_vertical are the grid lines between cells inside it. Each side takes {style, color?} — styles SOLID, SOLID_MEDIUM, SOLID_THICK, DOTTED, DASHED, DOUBLE, or NONE to remove that side's border. Only the provided sides change; at least one is required. Colors are "#RRGGBB" hex (default black).
Inputs: range (required), spreadsheet_id (required), top, left, +4 more.
set_clientSave the OAuth clientAIdempotent
Saves the OAuth client credentials from the JSON file downloaded from Google Cloud Console ('Download JSON' on a Desktop-app client). Pass the file PATH — the secret must never be pasted into the chat. The client is stored once in the shared ~/.config/mcp-google-auth/client.json (owner-only) and reused by every mcp-google-* server; tokens stay per-server. After this, call start_login.
Inputs: path (required).
set_data_validationSet data validationADestructiveIdempotent
Sets — or clears — a data-validation rule on a grid range. With condition_type set, every cell in the range gets the rule: ONE_OF_LIST with condition_values plus show_custom_ui=true is the classic in-cell dropdown; ONE_OF_RANGE takes a "=Sheet1!A1:A10" formula; NUMBER_/TEXT_/DATE_ conditions restrict input; CUSTOM_FORMULA takes a formula evaluated per cell. strict=true rejects invalid input outright, strict=false only shows a warning; input_message is the help text shown on the cell. OMIT condition_type (and the other rule fields) to REMOVE validation from the range. Overwrites any previous rule on the range — one rule per cell.
Inputs: range (required), spreadsheet_id (required), strict, input_message, +3 more.
set_frozenFreeze rows and columnsADestructiveIdempotent
Freezes the first N rows and/or columns of a sheet so they stay visible while scrolling (typical: frozen_rows=1 pins the header). 0 unfreezes. At least one of frozen_rows / frozen_columns is required; the other stays as it is. You cannot freeze all rows or all columns of a sheet — at least one unfrozen row/column must remain.
Inputs: sheet_id (required), spreadsheet_id (required), frozen_rows, frozen_columns.
setup_instructionsSetup instructionsARead-onlyIdempotent
Step-by-step checklist for connecting this server to Google: creating a Google Cloud project and a Desktop-app OAuth client, publishing the consent screen (mandatory — Testing-mode refresh tokens die after 7 days), downloading the client JSON and handing its PATH to set_client. Works without any credentials; the checklist shortens to 'enable the API + log in' when an OAuth client is already configured (one client serves the whole mcp-google-* line). Never asks the user to paste secrets into the chat.
Inputs: no named parameters.
start_loginStart the Google loginAIdempotent
First step of connecting from the chat, without editing config files or restarting the client. Returns authorizeUrl — show it to the user as a clickable link and ask them to open it in the browser ON THIS MACHINE, pick the Google account and approve access. A one-shot listener on 127.0.0.1 catches Google's redirect; the code is exchanged locally and never passes through the chat. Does not open the browser itself. The attempt lives 10 minutes; when the browser shows the success page, call finish_login.
Inputs: no named parameters.
write_valuesWrite values to a rangeADestructiveIdempotent
Overwrites one A1 range with a 2-D values matrix (rows first) and returns updatedRange/updatedRows/updatedColumns/updatedCells. The matrix is anchored at the range's top-left corner; cells beyond the matrix keep their old content, and a null entry skips (does not clear) that cell — use clear_values to empty cells. value_input_option USER_ENTERED (default) parses input like typing in the UI: "=SUM(A1:A10)" becomes a live formula, "1,234" and "2026-01-15" become number/date per the spreadsheet locale; RAW stores everything as literal values. For several ranges use batch_write_values (one quota unit instead of N).
Inputs: range (required), values (required), spreadsheet_id (required), value_input_option, +1 more.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 26 tools
Most tools target clearly distinct resources or actions: auth lifecycle (start_login/finish_login/auth_status/logout), spreadsheet CRUD, value operations, and granular structural/formatting operations are well separated. Minor overlap exists where get_spreadsheet can embed grid data (vs read_values) and raw_request can do anything, and write_values vs batch_write_values could be momentarily confused, but descriptions steer the agent clearly.
Nearly all names are snake_case with a verb_noun or manage_* pattern (create_spreadsheet, read_values, manage_sheets, set_frozen), which is predictable and readable. A few noun-phrase deviations (auth_status, setup_instructions, raw_request) and the batch_ prefix are minor inconsistencies but not confusing.
26 tools is on the heavy side, but each maps to a distinct Google Sheets API capability (auth, values, sheets, dimensions, formatting, validation, protection, conditional formats, tables, charts, sharing) plus a raw escape hatch, so the surface is large but justified. No tool is clearly redundant.
Coverage is broad: authentication/setup lifecycle, spreadsheet creation/search/structure, value read/write/append/clear, tab and dimension management, formatting, borders, frozen panes, validation, protection, conditional formats, tables, charts, sharing, and a raw Sheets API passthrough. Gaps like renaming/deleting the spreadsheet file, mergeCells, named ranges, and banding are only reachable via raw_request or Drive (not covered), which is a minor but real limitation.
Maintenance
Related MCP Connectors
Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
Connect an AI assistant to your Google Sheets, Drive, Docs, PDFs, BigQuery and Gmail.
Google Sheets via Apify: write Apify datasets or JSON rows to a sheet, or read a sheet as JSON.
AI access to Quadratic spreadsheets: open files, run Python/SQL, query connected databases.
Related MCP Servers
- AlicenseNot gradedqualityFmaintenanceEnables AI assistants to interact with Google Sheets for reading, writing, and managing spreadsheets through a set of MCP tools.MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to interact with Google Sheets, performing operations like creating, reading, updating, and clearing spreadsheet data.1MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to interact with Google Sheets via natural language, supporting CRUD operations, listing, sharing, and batch updates.MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to read, write, and manage Google Sheets using the Google Sheets API v4.MIT