atc07/sheets-mcp

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 →**
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.
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:
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**.