Claude, working in your Google Sheets.
Ask for a new column, a cleaner layout or a chart, and Claude makes the change directly in your spreadsheet, the way it already does in Excel.
Add a profit column with totals, format everything as currency, and chart revenue by month.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Month | Revenue | Cost | Profit |
| 2 | Jan | 12400$12,400 | 8100$8,100 | =B2-C24300$4,300 |
| 3 | Feb | 15200$15,200 | 9000$9,000 | =B3-C36200$6,200 |
| 4 | Mar | 18900$18,900 | 9700$9,700 | =B4-C49200$9,200 |
| 5 | Total | =SUM(B2:B4)46500$46,500 | =SUM(C2:C4)26800$26,800 | =SUM(D2:D4)19700$19,700 |
Everything you'd do by hand, done by asking.
Sheets MCP gives Claude a full set of spreadsheet tools, so it can work through a real task from start to finish.
Understands your sheet
Reads tabs, headers, formulas and named ranges before changing anything.
Writes values and formulas
Entered just as you'd type them, so formulas, dates and percentages work.
Formats like you would
Number formats, colors, borders, conditional formatting and frozen headers.
Builds charts
Column, bar, line, area, pie and combo charts from any range.
Restructures
Tabs, rows and columns, sorting, filters, dropdowns and merged cells.
Anything else
Direct access to the Sheets API for pivot tables, protected ranges and more.
Careful with your data by default.
Spreadsheets hold real work. Every change is checked, and mistakes are easy to reverse.
F2: #REF!
1 formula error found
Formulas are checked
After each write, the result is read back, so errors like #REF! and #N/A are caught right away instead of weeks later.
restored Sales!A1:D5
19 steps remaining
Undo
The last write, append or clear can be rolled back, restoring the values and formulas that were there before.
would overwrite 240 cells
large writes need confirmation
Preview first
Claude can preview what a change would overwrite, and very large edits require explicit confirmation.
Runs on your computer. No servers in between.
Sheets MCP is a small program that runs locally and talks to Google directly. Your sign-in never leaves your machine.
Read exactly what's accessed and where it goes in the privacy policy.
Connected in a few minutes.
You'll need Node.js and a Google Cloud OAuth client (Desktop app). The README walks through creating one.
Build the server
npm install && npm run buildSign in with Google
Opens your browser once. Your token is saved to ~/.sheets-mcp on your computer.
npm run authConnect to Claude Code
Then start a new session and paste a link to any sheet.
claude mcp add --scope user google-sheets -- node "$PWD/dist/index.js"