Sheets MCP
NPM · @SHEETSMCP/SERVER
Google Sheets for agent workflows in Claude Code and Claude Desktop: APIs, files, schedules, undo.
Available components
Last scanned (1 hour ago)
Scores higher than 93% of npm servers
Category Data and Analytics
How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score → Why this is hard to score →
Supply Chain Security98
- No malware found by supply-chain analysis.Pass
- No known CVEs affecting this package version or its production dependencies.Pass
- No install/post-install scripts declared.Pass
- 41 of 116 dependencies flagged as unhealthy (1 deprecated). View diagnostics → Partial
Provenance & Transparency97
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- Cryptographically verified build provenance (signed, bound to atc07/sheets-mcp). View diagnostics → Pass
- Clear OSI-approved license (MIT).Pass
- Actively maintained (last published 13 days ago).Pass
- Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail
Schema Quality & AI Usability72
- 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).Pass
- AI-judged instruction clarity (good).Pass
- Context-footprint check failed: tool/resource definitions use about 5287 tokens (~170/item across 31 items; 29 tools + 2 resources), over budget; trim descriptions and params. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management73
- Stability observed for 22 of 30 days with no destabilising changes; credit accrues until the full window elapses.Partial
Tool Coverage89
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 68% of tool parameters carry a description.Partial
Tool Safety100
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- All 3 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation.Pass
- An AI judge read all 31 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 4 Nov 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 67 to 70. That category is still filling its 30-day observation window: 20 days of observed history at the previous scan, 21 at this one. The score rises as the window fills, whether or not the server changes.
- 2 Nov 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 60 to 63. That category is still filling its 30-day observation window: 18 days of observed history at the previous scan, 19 at this one. The score rises as the window fills, whether or not the server changes.
- 31 Oct 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 53 to 57. That category is still filling its 30-day observation window: 16 days of observed history at the previous scan, 17 at this one. The score rises as the window fills, whether or not the server changes.
- 29 Oct 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 47 to 50. That category is still filling its 30-day observation window: 14 days of observed history at the previous scan, 15 at this one. The score rises as the window fills, whether or not the server changes.
- 27 Oct 26 +16
- Malware scan: unverified → pass ▲ security
- 26 Oct 26 −15
- Malware scan: pass → unverified ▼ security
- Package version: 1.3.9 → 1.4.0 functional
- 24 Oct 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 30 to 33. That category is still filling its 30-day observation window: 9 days of observed history at the previous scan, 10 at this one. The score rises as the window fills, whether or not the server changes.
- 23 Oct 26 +4
- Stability: unverified → 0.30 ▲ functional
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 5 Nov 2026 · Analysed npm/@sheetsmcp/server@1.4.0
Provenance Verified
A signed build attestation was found and verified, binding this exact artifact to the source repository it claims to come from.
| Result | Verified |
|---|---|
| Ecosystem | npm |
| Reason | Verified |
| Discovered via | Registry attestation endpoint |
| Source repo | atc07/sheets-mcp |
| Certificate issuer | https://token.actions.githubusercontent.com |
| Certificate SAN | https://github.com/atc07/sheets-mcp/.github/workflows/publish.yml@refs/tags/v1.4.0 |
| Rekor log index | 3392169978 |
| Predicate type | SLSA build provenance https://slsa.dev/provenance/v1 |
| Subject digest | sha512:735631bfa9779a48ca88eaa7f702a0bc2d399ae007ff6e7138cadb8f84f1282851b7400b542382f4ec541efe7efcc4d85ef6402d3e08b4b84b9174965 |
Background: How many MCP packages publish verified provenance →
Dependencies 116 packages
| Packages resolved | 116 |
|---|---|
| Deprecated | 1 |
| Stale | 40 |
| Tree resolution | Complete |
Background: SBOMs and build attestations, explained →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
add_chart Add a chart ~190
Create a chart from a data range. The first column is the X axis/labels; each following column is a series. Use a header row for series names.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| anchor_cell | string | – | Where to place the chart's top-left, e.g. "Sales!F2" (default: right of the data) |
| chart_type | string | – | – |
| data_range | string | yes | e.g. "Sales!A1:C13" |
| has_header | boolean | – | – |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| stacked | boolean | – | – |
| title | string | – | – |
No output schema declared.
No examples provided.
add_conditional_format Add conditional formatting ~163
Add a conditional formatting rule: either a condition (e.g. NUMBER_GREATER, TEXT_CONTAINS, CUSTOM_FORMULA) with a style, or a color scale.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| color_scale | object | – | – |
| condition | object | – | – |
| range | string | yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
add_pivot_table Add a pivot table ~274
Summarize a table with a pivot table: group by one or more columns, and total, count or average others. It goes on a new tab unless anchor_cell is given. The source range needs a header row; refer to columns by header name or letter.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| anchor_cell | string | – | Top-left cell for the pivot table, e.g. "Summary!A1". The area below and right of it must be empty. Default: a new tab |
| columns | array | – | Columns to group by across the top |
| new_tab_name | string | – | Name for the new tab when anchor_cell isn't given |
| rows | array | – | Columns to group by down the side, e.g. ["Region"] |
| show_totals | boolean | – | – |
| source_range | string | yes | The table to summarize, header row included, e.g. "Orders!A1:F500" or a tab name |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| values | array | yes | – |
No output schema declared.
No examples provided.
append_rows Append rows ~142
Append rows after the last row of data in a table (detected from the given range or tab).
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| range | string | yes | Tab name or table range, e.g. "Sales" or "Sales!A:F" |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| values | array | yes | 2D array of rows. Strings starting with = are formulas. |
No output schema declared.
No examples provided.
batch_update Advanced batch update ~152
Send raw Google Sheets API batchUpdate requests for anything the other tools don't cover (e.g. named ranges, protected ranges, pivot tables, row heights, hiding rows, updating charts). Requests use sheetId numbers from get_spreadsheet_info.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| requests | array | yes | Array of Request objects, see developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
clear_range Clear cells ~140
Clear values and formulas in a range (formatting is kept). Previous contents are saved for undo_last.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| dry_run | boolean | – | – |
| range | string | yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
create_spreadsheet Create a spreadsheet ~81
Create a new Google Sheets spreadsheet.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| sheet_names | array | – | Tab names (default: one tab) |
| title | string | yes | – |
No output schema declared.
No examples provided.
delete_chart Delete a chart ~108
Delete a chart. Chart ids come from get_spreadsheet_info or add_chart. Not undoable through undo_last.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| chart_id | integer | yes | – |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
delete_rows_or_columns Delete rows or columns ~138
Delete entire rows (e.g. "Sheet1!5:7") or columns (e.g. "Sheet1!C:D"). Not undoable.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| range | string | yes | Whole-row range like "Tab!5:7" or whole-column range like "Tab!C:D" |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
fill_range Fill cells ~336
Fill cells from a source block, like dragging the fill handle or pasting onto a bigger selection: the source's formulas (relative references shift), values and formatting repeat across the destination. Use it after writing one row or column of formulas to extend them across a table, instead of sending every column. With continue_series, patterns continue instead (1, 2, 3 → 4, 5, 6; Jan → Feb; dates). The destination's previous contents are saved for undo_last. Returns any formula errors found after filling.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| allow_large | boolean | – | Required for fills over 10000 cells |
| continue_series | boolean | – | Extend the pattern in the source (like the fill handle) instead of repeating it |
| destination | string | yes | The cells to fill, e.g. "Model!P25:AE97" (it may include the source). For continue_series it must sit right after, or right before, the source in the same rows or columns |
| paste | string | – | all = formulas, values and formatting; formulas = formulas and values without formatting; values = results as plain values; formats = formatting only |
| source | string | yes | The cells to fill from, e.g. "Model!O25:O97" |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
find_replace Find and replace ~162
Find and replace text across a tab or the whole spreadsheet. Not undoable - consider read_range first.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| find | string | yes | – |
| include_formulas | boolean | – | – |
| match_case | boolean | – | – |
| match_entire_cell | boolean | – | – |
| replacement | string | yes | – |
| sheet | string | – | Limit to this tab (default: all tabs) |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| use_regex | boolean | – | – |
No output schema declared.
No examples provided.
find_spreadsheet Find a spreadsheet ~103
Find a spreadsheet by name among the ones the user has opened or created with Sheets MCP before (the list is kept on their computer). Use it when the user names a sheet instead of pasting a link, e.g. "my budget sheet". It can't search the rest of their Google Drive: if nothing matches, ask for the link. Leave query empty to list the most recent.
| Name | Type | Req | Description |
|---|---|---|---|
| query | string | – | All or part of the spreadsheet's name |
No output schema declared.
No examples provided.
format_range Format cells ~287
Apply formatting to a range: font styles, colors, number formats, alignment, wrapping, borders. Only provided options are changed. To style several ranges differently in one go, use format_ranges.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| background_color | string | – | Hex, e.g. #f1f3f4 |
| bold | boolean | – | – |
| borders | object | – | – |
| clear_formatting | boolean | – | Reset all formatting first |
| font_family | string | – | – |
| font_size | number | – | – |
| horizontal_alignment | string | – | – |
| italic | boolean | – | – |
| number_format | object | – | – |
| range | string | yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| strikethrough | boolean | – | – |
| text_color | string | – | Hex, e.g. #1a73e8 |
| underline | boolean | – | – |
| vertical_alignment | string | – | – |
| wrap | string | – | – |
No output schema declared.
No examples provided.
format_ranges Format several ranges ~147
Apply different formatting to several ranges in one call (same options as format_range, one entry per range): headers, input cells, number formats, borders and so on for a whole tab at once. Ranges may repeat; later entries win where they overlap.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| items | array | yes | One entry per range, each with the formatting to apply there |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
freeze Freeze rows or columns ~113
Freeze header rows and/or columns on a tab. Use 0 to unfreeze.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| columns | integer | – | – |
| rows | integer | – | – |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| tab | string | – | – |
No output schema declared.
No examples provided.
get_spreadsheet_info Spreadsheet overview ~133
Get a spreadsheet's title, tabs (sizes, frozen rows/cols), charts (ids, types, data ranges), named ranges, and the first few rows of each tab. Call this first to understand a sheet's layout.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| preview_rows | integer | – | – |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
google_accounts Google accounts ~102
Manage the Google accounts Sheets MCP can use. list: show signed-in accounts and the default. add: sign in to a Google account (opens a browser sign-in; also use this when a sign-in has expired). remove: sign an account out and revoke access. set_default: choose the account used for new spreadsheets.
| Name | Type | Req | Description |
|---|---|---|---|
| action | string | yes | – |
| string | – | For remove/set_default: the account's email or a unique part of it |
No output schema declared.
No examples provided.
insert_rows_or_columns Insert rows or columns ~149
Insert blank rows or columns before a given row number or column letter.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| before | string | yes | Row number (e.g. "5") or column letter (e.g. "C") to insert before |
| count | integer | – | – |
| dimension | string | yes | – |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| tab | string | – | Tab name (default: first tab) |
No output schema declared.
No examples provided.
manage_tab Manage tabs ~155
Add, delete, rename, or duplicate a tab (sheet).
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| action | string | yes | – |
| columns | integer | – | Column count for add |
| new_name | string | – | New name (rename/duplicate) |
| rows | integer | – | Row count for add |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| tab | string | – | Existing tab (for delete/rename/duplicate), or new tab name for add |
No output schema declared.
No examples provided.
merge_cells Merge cells ~135
Merge or unmerge cells in a range.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| action | string | – | – |
| merge_type | string | – | – |
| range | string | yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
read_range Read cells ~217
Read cell contents from a range, or its formatting with mode "formats". Large ranges are truncated; use next_range to continue.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| max_cells | integer | – | – |
| mode | string | – | values = as displayed; formulas = show formulas instead of results; raw = unformatted numbers; formats = cell formatting (fill, font, alignment, number format, borders) as a style table plus a per-ro… |
| range | string | yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
read_ranges Read several ranges ~159
Read several ranges in one call, across any tabs. Faster than calling read_range repeatedly. Each range is truncated to its share of max_cells; use its next_range with read_range to continue.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| max_cells | integer | – | Total across all ranges |
| mode | string | – | values = as displayed; formulas = show formulas instead of results; raw = unformatted numbers |
| ranges | array | yes | – |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
resize_columns Resize columns ~116
Set column widths in pixels, or auto-fit them to content when width is omitted.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| range | string | yes | Column range like "Sheet1!A:D" |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| width | integer | – | – |
No output schema declared.
No examples provided.
set_data_validation Dropdowns and validation ~211
Add data validation to a range: dropdown list, dropdown from a range, checkbox, number range, custom formula - or clear it.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| max | number | – | – |
| min | number | – | – |
| options | array | – | dropdown: list items; dropdown_from_range: ["=Lists!A2:A20"]; custom_formula: ["=ISNUMBER(A2)"] |
| range | string | yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| strict | boolean | – | Reject invalid input (vs. show a warning) |
| type | string | yes | – |
No output schema declared.
No examples provided.
set_filter Set a filter ~124
Turn on a basic filter (filter buttons in the header row) for a range, or clear the tab's filter.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| clear | boolean | – | – |
| range | string | yes | Data range including header, or tab name when clearing |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
sort_range Sort a range ~147
Sort rows within a range by one or more columns.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| has_header | boolean | – | Keep the first row of the range in place |
| range | string | yes | A1 range, e.g. "Sheet1!A1:D20", "'My Tab'!B:B", or a tab name |
| sort_by | array | yes | – |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
undo_last Undo last change ~117
Undo the most recent write_range, append_rows, or clear_range made through this server (restores values/formulas only, not formatting or structure). History is kept in memory until the server restarts.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
No output schema declared.
No examples provided.
update_chart Update a chart ~226
Change an existing chart: its title, type, data range, stacking, position or size. Only the options you give are changed. Chart ids come from get_spreadsheet_info or add_chart.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| anchor_cell | string | – | Move the chart's top-left corner here, e.g. "Sales!F2" |
| chart_id | integer | yes | – |
| chart_type | string | – | – |
| data_range | string | – | New data, laid out as for add_chart: first column labels, then one column per series |
| has_header | boolean | – | Used with data_range |
| height | integer | – | Pixels |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| stacked | boolean | – | – |
| title | string | – | – |
| width | integer | – | Pixels |
No output schema declared.
No examples provided.
write_range Write cells ~197
Write values and/or formulas starting at the top-left cell of the range. Input is parsed like typing into the UI (formulas, dates, percentages work). Previous contents are saved for undo_last. Returns any formula errors found after writing.
| Name | Type | Req | Description |
|---|---|---|---|
| account | string | – | Google account to use: an email or unique part of one (e.g. "acme.com"). Default: the account that can open the spreadsheet, else the default account. |
| allow_large | boolean | – | Required for writes over 10000 cells |
| dry_run | boolean | – | Only show what would be overwritten |
| range | string | yes | Top-left cell or full range, e.g. "Sheet1!B2" |
| spreadsheet | string | yes | Google Sheets link or spreadsheet ID. The name of a spreadsheet used with Sheets MCP before also works |
| values | array | yes | 2D array of rows. Strings starting with = are formulas. |
No output schema declared.
No examples provided.
How do I install the Sheets MCP server?
Sheets MCP runs locally as an npm package, launched with npx -y @sheetsmcp/server. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
npm · @sheetsmcp/server
claude mcp add atc07-sheets-mcp -- npx -y @sheetsmcp/server
What is the Sheets MCP server?
Sheets MCP is listed in the public MCP registry as io.github.atc07/sheets-mcp. Google Sheets for agent workflows in Claude Code and Claude Desktop: APIs, files, schedules, undo. This page covers its npm package (@sheetsmcp/server).
Is the Sheets MCP server safe to use?
Sheets MCP scores 89 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 5 November 2026. It declares no install or post-install scripts. Its build provenance is signed and verified. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the Sheets MCP server expose?
Sheets MCP exposes 29 tools: google_accounts, find_spreadsheet, create_spreadsheet, get_spreadsheet_info, read_range, and 24 more. Their descriptions and schemas cost roughly 4,724 tokens of context every time the server is loaded.
Is the Sheets MCP server still maintained?
Sheets MCP is still listed as active in the MCP registry. We last reached this channel on 5 November 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.
What licence is the Sheets MCP server under?
Sheets MCP declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.