Pull data from any API
In Claude Code, Claude can call an API, run a script or use another connector, then write the results straight into your sheet.
Free and open source · For Claude Desktop and Claude Code
The power tool for Google Sheets in Claude.
Connect your spreadsheets to everything Claude Desktop and Claude Code can do: APIs, files on your computer, your other sheets and scheduled tasks. Free, local and open source.
Free. You'll need Claude Desktop or Claude Code, and a Google account. Version 1.4.0 · What's new
downloads
Claude makes every change on the right through Sheets MCP.
Walk me through how the profit options work
Claude
I'll read the model, then walk you through it on the sheet.
- Claude reads firstA progress bar moves as it reads, and the points appear as Claude writes them.
- Then shows you, point by pointEach point outlines its cells with a short note. Click Next (or press →) when you're ready.
- Ask about any pointType a question in the walkthrough. Claude answers there, stepping through the cells it means.
Works for reviews and meeting prep too: “check this model for problems” points at each one. Walkthroughs play in the live preview in Claude Desktop.
Use cases
Connect your sheets to everything Claude can do.
Claude's sidebar in Google Sheets is great for working inside one sheet. Sheets MCP lets Claude bring in data from APIs, files and your other spreadsheets, and keep your sheets up to date without you.
Build new sheets from your other sheets
Claude reads as many spreadsheets as you point it at, combines them, and builds a new one with the summary and charts.
Keep sheets up to date on a schedule
Ask once and a scheduled task in Claude Desktop refreshes your sheet every morning, without you watching. It runs on your computer, so it needs to be on.
Bring in files from your computer
CSV exports, Excel files and PDFs on your computer go straight into a sheet. Nothing to upload first.
Work across your Google accounts
Read from your work account and write to your personal one in the same request. Sign in to as many accounts as you like.
Teach it your way once
In Claude Code, keep your sheets and conventions in a project's CLAUDE.md or a skill, and repeat jobs like a month-end close come out the same every time.
Recently worked on
Every sheet you've worked on, one click away.
Sheets MCP keeps a list of the spreadsheets you've used with it, on your computer. Search it, pin the ones you use most, and tick a few to hand to Claude together, even across Google accounts.
How to open it
- Claude DesktopStart talking about your sheets (“let's work on my budget”) and the list opens in the chat. Or ask “show my recent sheets.”
- Claude CodeType
/mcp__google-sheets__recent_sheets, or ask “which sheets have I used?”
The list has every sheet you've opened with Sheets MCP. Paste a sheet's link once and it's there from then on.
Let's work on a couple of my sheets
Claude
Here are the sheets you've worked on. Pick the ones you want.
Compare
Sheets MCP or Claude's built-in 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 install. Google shows an “unverified app” screen once at sign-in | Built in |
| Where your data goes | From your computer straight to Google, with access to spreadsheets only | Through Anthropic's hosted connector |
| Google accounts | Several, in the same conversation | The one you connect |
| Code | Open source (MIT) | Anthropic's product |
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. Full comparison →
-
Get the Claude desktop app
Download Claude for Mac or Windows and sign in with your Claude account. Already have it? Skip to step 2.
Download Claude Desktop -
Install Sheets MCP
Download the file below, then double-click it in your Downloads folder. Claude Desktop opens and asks to install it. Click Install (or Update if you have an older version; it can take a minute). It works in both the Chat and Code tabs.
Download Sheets MCP 1.4.0Nothing happened when you opened the file? Quit and reopen Claude Desktop, then open it again. Or in Claude Desktop, open Settings → Extensions → Advanced settings → Install Extension… and choose
sheets-mcp-1.4.0.mcpbfrom your Downloads folder. -
Ask Claude, then sign in with Google once
In a new Claude chat, paste a link to one of your Google Sheets and ask for something. A Google sign-in page opens in your browser. Choose your account and allow access.
Google shows a warning first, because Sheets MCP is an independent app that hasn't gone through Google's review process. Here's what to click:
Google hasn't verified this appAdvanced1Back to safetyGo to Sheets MCP (unsafe)2That's the only time you'll see it. Your sign-in stays on your computer, and Sheets MCP talks to Google directly from then on.
You're set. Try asking:
- “Summarize this sheet: paste link”
- “Add a Profit column that subtracts Cost from Revenue”
- “Make the money columns currency and bold the header”
- “Chart sales by month”
- “Create a new budget spreadsheet”
- “Undo that”
Everyday edits
Everything you'd do by hand, done by asking.
Claude can work through a whole task in your sheet, from reading what's there to the finishing touches.
Reads your sheet first
Looks at your tabs, headers and formulas before changing anything, so it understands what's there.
Fills in data and formulas
Adds rows, columns, totals and calculations, just as if you'd typed them yourself.
Makes it look right
Currency and dates, bold headers, colors, borders, highlighting and frozen header rows.
Builds charts
Column, bar, line and pie charts from your data, placed right next to it, and changes or removes them when you ask.
Organizes
Sorts and filters, adds dropdown menus, and adds, renames or removes tabs, rows and columns.
Shows you the work, live
A live view of your sheet right in the chat: watch each cell Claude reads and changes as it happens, charts included.
Summarizes with pivot tables
“Total revenue by region and product” becomes a pivot table on its own tab, with grand totals.
Remembers your sheets
Ask for a sheet by name, or pick from your Recently worked on list. No need to dig up the link again.
Works with all your accounts
Personal and work Google accounts, and sheets people have shared with you.
Safety
Careful with your data by default.
Your spreadsheets hold real work. Every change is checked, and mistakes are easy to reverse.
Cell F2 shows #REF!
The formula points to a cell that was deleted. Fixing it now.
The formula points to a cell that was deleted. Fixing it now.
Catches broken formulas
After every change, the result is checked, so errors are caught right away instead of weeks later.
Undone.
Sales A1:D5 is back to how it was.
Sales A1:D5 is back to how it was.
Easy undo
Just say “undo that” to put values and formulas back the way they were.
This will replace 240 cells on the Sales tab.
Go ahead?
Go ahead?
Asks before big changes
Claude can show you what a change would replace, and very large edits need your OK.
Privacy
Runs on your computer. Your data stays yours.
Sheets MCP is a small add-on for the Claude app. It talks to Google directly from your computer. There's no Sheets MCP server in the middle, and we never see your spreadsheets.
ClaudeDesktop app
Sheets MCPOn your computer
Google SheetsYour account
What Sheets MCP asks Google for, and why
- Your Google SheetsTo read and edit the spreadsheets you ask Claude to work on, and to create new ones when you ask.
- Your email addressTo tell your Google accounts apart when you sign in to more than one. It's stored only on your computer.
Nothing else: no other Drive files, no Gmail, no contacts. Sheets MCP's use of information received from Google APIs adheres to the Google API Services User Data Policy, including the Limited Use requirements.
Read exactly what's accessed and where it goes in the privacy policy.
FAQ
Questions, answered.
Is it free?
Yes. Sheets MCP is free and open source (MIT). In Claude Desktop it works on the free Claude plan; Claude Code itself needs a paid Claude plan or API access.
Why does Google say the app isn't verified?
Google shows that warning for any app that hasn't gone through its review process. Sheets MCP only asks for access to your spreadsheets, plus your email address so it can tell your Google accounts apart. It can't see your other Drive files, your email or anything else.
Can you see my spreadsheets?
No. Sheets MCP runs on your computer and talks to Google directly. Your Google sign-in is stored only on your computer. What Claude reads becomes part of your Claude conversation, just like anything else you share with Claude.
My work account says “Access blocked.” What do I do?
Some companies only allow apps their IT team has approved. Ask your Google Workspace admin to allow Sheets MCP under Admin console → Security → API controls. Your personal Google account will work either way.
Can I use more than one Google account?
Yes. Ask Claude to “sign in to another Google account.” When you paste a sheet link, Sheets MCP automatically uses whichever of your accounts can open it.
How do I see what Claude is doing in my sheet?
In Claude Desktop, Claude opens a live view of your sheet in the chat while it works. Each range it reads and each change it makes appears as it happens, and the view folds away when Claude is done. Click Open in Sheets to jump to the same cells in Google Sheets. If you've just updated Sheets MCP, quit and reopen Claude Desktop once so the new view loads.
Do I have to paste a link every time?
Only the first time. Sheets MCP remembers the spreadsheets you've used with it, in a list on your computer. Ask for a sheet by name, like “open my budget sheet,” or open the list: in Claude Desktop it appears when you start talking about your sheets, and in Claude Code you type /mcp__google-sheets__recent_sheets. It can't search the rest of your Google Drive, so for a sheet you haven't used with it yet, paste the link once.
Does it work on my phone or on claude.ai?
Not directly. Sheets MCP runs on your computer, so it works in the Claude desktop app on Mac and Windows (Chat and Code tabs) and in Claude Code. On claude.ai and the Claude mobile app, use Claude's built-in Google Sheets integration (paid plans).
One exception: if you follow a Claude Code session from your phone with Remote Control, Sheets MCP keeps working, because it's still running on your computer. The live sheet view won't appear on the phone (Remote Control relays the conversation, not the desktop's interactive panels), but it's there in the desktop app when you're back at your computer.
How is this different from Claude's built-in Google Sheets integration?
Claude's built-in Google Sheets integration (paid plans) is the simplest way to edit the sheet in front of you. Sheets MCP is for work that reaches beyond one sheet: pulling in APIs and files, combining spreadsheets, scheduled refreshes and several Google accounts. It's free, runs on your computer and is open source. See the side-by-side comparison.
Claude stopped responding partway through a task.
Send another message and Claude will pick up where it left off. For long jobs with many changes, try the Code tab in Claude Desktop: it runs everything on your computer and uses the same extension, so there's nothing else to install.
I don't see the Install option in Claude Desktop.
Make sure Claude Desktop is up to date. On Team and Enterprise plans, an admin may need to allow desktop extensions for your organization.
How do I remove it?
In Claude Desktop, open Settings → Extensions and remove Sheets MCP. To also revoke Google access, visit myaccount.google.com/permissions and remove Sheets MCP.
Use Claude Code in a terminal or IDE?
Install Node.js 18 or newer, then run this once in your terminal. (In Claude Desktop's Code tab, the extension above already covers you.) The Google sign-in opens the first time Claude uses it.
claude mcp add --scope user google-sheets -- npx -y @sheetsmcp/server
