Skip to main content
Glama

Sheets MCP

mcp.market

The power tool for Google Sheets in Claude. A free, open-source MCP server that connects your spreadsheets to everything Claude Desktop and Claude Code can do: pull data from APIs and files into a sheet, build new sheets from your other sheets, keep them updated on a schedule, and work across several Google accounts. Formulas, formatting, charts and pivot tables included, with undo and formula-error checks on every write. It runs on your computer and talks to Google directly.

See all features and watch the demo at sheetsmcp.io →

Claude adds a profit column, totals, currency formatting and a chart while a live preview of the sheet updates in the chat

Free and open source · Runs on your computer · Spreadsheet-only Google access · Claude Desktop and Claude Code

If Sheets MCP saves you time, a ⭐ on GitHub helps other people find it.

Sheets MCP or Claude's built-in Google Sheets integration?

Claude now has its own Google Sheets integration on paid plans. Both let Claude edit your spreadsheets; they suit different jobs.

Sheets MCP

Claude's built-in integration

Best for

Work that reaches beyond one sheet: APIs, files, other sheets, schedules

Quick edits inside the sheet you have open

Price

Free, and works on the free Claude plan in Claude Desktop

Paid Claude plans

Where it works

Claude Desktop (Chat and Code tabs) and Claude Code

Claude chat, and a sidebar inside Google Sheets

Setup

One-click extension or one command. Google shows an "unverified app" screen at sign-in for now

Built in

Where your data goes

From your computer straight to Google, with access to spreadsheets only. No other servers

Through Anthropic's hosted connector

Code

Open source (MIT): read it, change it, run your own

Anthropic's product

Extras

Several Google accounts, undo, formula-error checks, live preview in the chat

Sidebar in Sheets, edit approvals, Python for data cleaning

In short: on a paid plan and only want Claude to edit the sheet in front of you? The built-in integration is the simplest. Want Claude to pull your sheets together with everything else, for free? Use Sheets MCP. You can use both.

Related MCP server: Google Sheets MCP Server

Install

Claude Desktop (easiest, no setup)

  1. Install Claude Desktop and sign in.

  2. Download Sheets MCP for Claude Desktop (a .mcpb file; see what's new).

  3. Double-click the file, then click Install in Claude Desktop.

New to Claude Desktop? Follow the step-by-step setup guide.

The extension works in both the Chat and Code tabs. For long, multi-step jobs, the Code tab is the more dependable choice: it runs everything on your computer.

Claude Code

Requires Node.js 18 or newer. Run:

claude mcp add --scope user google-sheets -- npx -y @sheetsmcp/server

Then start a new Claude Code session.

Sign in

The first time Claude uses Google Sheets, a Google sign-in page opens in your browser:

  1. Choose your Google account.

  2. Google shows "Google hasn't verified this app". Click Advanced, then Go to Sheets MCP.

  3. Click Continue to allow access to your spreadsheets.

To use more than one Google account, ask Claude to "sign in to another Google account". When you paste a sheet link, Sheets MCP uses whichever of your accounts can open it.

To open the Google sign-in in a particular browser without changing your default, add "browser": "Google Chrome" (or another app name) to ~/.sheets-mcp/settings.json.

If your company's Google Workspace blocks the sign-in, your Workspace admin can allow Sheets MCP under Admin console → Security → API controls.

Try asking

In Claude Desktop, click + and choose Get started with Google Sheets for a quick tour. When more than one Google account is connected, Claude asks which account to use before creating a spreadsheet, or when a sheet can be opened by more than one of your accounts.

  • "Summarize this sheet: "

  • "Add a Profit column that subtracts Cost from Revenue, and format it as currency"

  • "Chart spending by month in this sheet: "

  • "Freeze the header row, bold it, and auto-fit the column widths"

  • "Summarize revenue by region and product in a pivot table"

  • "Change that chart to a line chart and move it next to the table"

  • "Create a new spreadsheet called Trip Planner"

  • "Open my budget sheet" (works for sheets you've used with Sheets MCP before)

  • "Pull last week's Stripe payouts into the Cash tab" (Claude Code)

  • "Combine the East and West sales sheets into a new Q3 summary with a chart"

  • "Copy the Q4 forecast from my work account into the board sheet on my personal account"

  • "Undo that"

More example requests and everything Sheets MCP can do →

Recently worked on

Sheets MCP keeps a list of the spreadsheets you've used with it, on your computer. In Claude Desktop, start talking about your sheets ("let's work on my budget") or ask "show my recent sheets", and a searchable list opens in the chat: pin the ones you use most, open them in Google Sheets, or tick several (even from different Google accounts) and send them to Claude with what you want done. In Claude Code, type /mcp__google-sheets__recent_sheets or ask "which sheets have I used?".

Live preview

In Claude Desktop, Claude opens a live preview of your sheet in the chat while it works. You see each range it reads and each change it makes as it happens, charts included, and the preview folds away when Claude is done. Open in Sheets jumps to the same cells in Google Sheets.

Ask Claude to explain a sheet ("walk me through how this model works") and the preview becomes a walkthrough: a progress bar while Claude reads, then Claude's explanation played on the sheet one point at a time. Claude's cursor outlines the cells for each point and types a short note beside them, and the walkthrough waits for you to click Next. Type a question about the point in the walkthrough and Claude answers there, stepping through the cells it's talking about. It's drawn in the preview only, so nothing changes in the sheet and collaborators see nothing.

Claude reads a profit model, then walks through it on the sheet: it outlines the cells for each point with a note beside them, and answers a question typed in the walkthrough by stepping through two cells

After updating Sheets MCP, quit and reopen Claude Desktop so it loads the new preview.

The preview draws in the Claude desktop app. If you follow a session from your phone with Remote Control, Sheets MCP keeps working on your computer and the preview is there when you're back at it.

Watch it in action on sheetsmcp.io →

Privacy

Sheets MCP runs on your computer. Your Google sign-in is stored only on your computer (in ~/.sheets-mcp), and requests go straight from your computer to Google. There is no Sheets MCP server in between. It asks Google for access to your spreadsheets only, not the rest of your Drive. For finding sheets by name and the Recently worked on list, it keeps a list of the spreadsheets you've used with it in ~/.sheets-mcp/recent.json on your computer; delete that file to clear the list. Spreadsheet data Claude reads becomes part of your Claude conversation. See the privacy policy.

To disconnect, ask Claude to "sign out of Google Sheets", or remove Sheets MCP at myaccount.google.com/permissions.

Command line (optional)

npx @sheetsmcp/server auth                      # sign in to a Google account
npx @sheetsmcp/server accounts                  # list signed-in accounts
npx @sheetsmcp/server accounts default <email>  # choose the default account
npx @sheetsmcp/server accounts remove <email>   # sign out an account

Learn more

Available Tools

29 tools
add_chartAdd a chartA

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.

Inputs: data_range (required), spreadsheet (required), title, account, +4 more.

add_conditional_formatAdd conditional formattingB

Add a conditional formatting rule: either a condition (e.g. NUMBER_GREATER, TEXT_CONTAINS, CUSTOM_FORMULA) with a style, or a color scale.

Inputs: range (required), spreadsheet (required), account, condition, +1 more.

add_pivot_tableAdd a pivot tableA

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.

Inputs: values (required), spreadsheet (required), source_range (required), rows, +5 more.

append_rowsAppend rowsA

Append rows after the last row of data in a table (detected from the given range or tab).

Inputs: range (required), values (required), spreadsheet (required), account.

batch_updateAdvanced batch updateA
Destructive

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.

Inputs: requests (required), spreadsheet (required), account.

clear_rangeClear cellsA
Destructive

Clear values and formulas in a range (formatting is kept). Previous contents are saved for undo_last.

Inputs: range (required), spreadsheet (required), account, dry_run.

create_spreadsheetCreate a spreadsheetC

Create a new Google Sheets spreadsheet.

Inputs: title (required), account, sheet_names.

delete_chartDelete a chartA
Destructive

Delete a chart. Chart ids come from get_spreadsheet_info or add_chart. Not undoable through undo_last.

Inputs: chart_id (required), spreadsheet (required), account.

delete_rows_or_columnsDelete rows or columnsA
Destructive

Delete entire rows (e.g. "Sheet1!5:7") or columns (e.g. "Sheet1!C:D"). Not undoable.

Inputs: range (required), spreadsheet (required), account.

fill_rangeFill cellsA
Destructive

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.

Inputs: source (required), destination (required), spreadsheet (required), paste, +3 more.

find_replaceFind and replaceA
Destructive

Find and replace text across a tab or the whole spreadsheet. Not undoable - consider read_range first.

Inputs: find (required), replacement (required), spreadsheet (required), sheet, +5 more.

find_spreadsheetFind a spreadsheetA
Read-only

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.

Inputs: query.

format_rangeFormat cellsA

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.

Inputs: range (required), spreadsheet (required), bold, wrap, +13 more.

format_rangesFormat several rangesA

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.

Inputs: items (required), spreadsheet (required), account.

freezeFreeze rows or columnsA

Freeze header rows and/or columns on a tab. Use 0 to unfreeze.

Inputs: spreadsheet (required), tab, rows, account, +1 more.

get_spreadsheet_infoSpreadsheet overviewA
Read-only

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.

Inputs: spreadsheet (required), account, preview_rows.

google_accountsGoogle accountsA

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.

Inputs: action (required), email.

insert_rows_or_columnsInsert rows or columnsB

Insert blank rows or columns before a given row number or column letter.

Inputs: before (required), dimension (required), spreadsheet (required), tab, +2 more.

manage_tabManage tabsC
Destructive

Add, delete, rename, or duplicate a tab (sheet).

Inputs: action (required), spreadsheet (required), tab, rows, +3 more.

merge_cellsMerge cellsC
Destructive

Merge or unmerge cells in a range.

Inputs: range (required), spreadsheet (required), action, account, +1 more.

read_rangeRead cellsA
Read-only

Read cell contents from a range, or its formatting with mode "formats". Large ranges are truncated; use next_range to continue.

Inputs: range (required), spreadsheet (required), mode, account, +1 more.

read_rangesRead several rangesA
Read-only

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.

Inputs: ranges (required), spreadsheet (required), mode, account, +1 more.

resize_columnsResize columnsA

Set column widths in pixels, or auto-fit them to content when width is omitted.

Inputs: range (required), spreadsheet (required), width, account.

set_data_validationDropdowns and validationB

Add data validation to a range: dropdown list, dropdown from a range, checkbox, number range, custom formula - or clear it.

Inputs: type (required), range (required), spreadsheet (required), max, +4 more.

set_filterSet a filterA

Turn on a basic filter (filter buttons in the header row) for a range, or clear the tab's filter.

Inputs: range (required), spreadsheet (required), clear, account.

sort_rangeSort a rangeC

Sort rows within a range by one or more columns.

Inputs: range (required), sort_by (required), spreadsheet (required), account, +1 more.

undo_lastUndo last changeA

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.

Inputs: spreadsheet (required), account.

update_chartUpdate a chartA

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.

Inputs: chart_id (required), spreadsheet (required), title, width, +7 more.

write_rangeWrite cellsA
Destructive

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.

Inputs: range (required), values (required), spreadsheet (required), account, +2 more.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.6/5.0

    Scored across 29 tools

    Disambiguation4/5

    Most tools target a distinct resource+action (read/write/fill/clear/format/sort/chart/tab), so boundaries are clear. The close pairs read_range/read_ranges and format_range/format_ranges are distinguished only by the plural/batch wording, and batch_update is a catch-all that can overlap anything, but descriptions keep them separable.

    Naming Consistency4/5

    Strong, predictable verb_noun snake_case throughout (create_spreadsheet, read_range, add_chart, delete_rows_or_columns). Minor deviations are a few noun-only or bare-verb names like google_accounts and freeze, which don't break readability.

    Tool Count3/5

    29 tools is on the heavy side and pushes past the comfortable range, though the breadth of a full spreadsheet app (values, formatting, charts, pivots, validation) justifies most of them. A few batch variants and the batch_update escape hatch add weight without adding much.

    Completeness5/5

    Covers the full lifecycle: read/write/fill/append/clear, undo, tab management, row/column insert-delete, freeze, resize, merge, formatting, conditional formatting, sort, filter, validation, charts (add/update/delete), pivot tables, plus a raw batchUpdate for gaps. No obvious dead ends.

    Maintenance

    ActivityActive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers