Claude for Google Sheets: what actually works in 2026

If you're hoping for a button that connects Claude straight to a live Google Sheet, there isn't one. Claude for Excel is real, but only inside Microsoft Excel. The Google Drive connector can pull a sheet into Claude, but as a flattened CSV snapshot: formulas stripped, no way to write anything back. The workflow that actually works in 2026 is copy-paste: hand Claude your data, get a formula back, paste it in yourself, and check the result.

Why there's no native Sheets integration

Anthropic's Google Drive connector lets Claude read your Drive, and for spreadsheets specifically it can "pull data from Google Sheets (exported as CSV)." That line matters: CSV export means values only. Any formula logic in the sheet is gone before Claude ever sees it, and the connector's own page describes only read actions, nothing about writing values or formulas back into a live sheet (claude.com).

Claude for Excel, the closest thing Anthropic has to a "live spreadsheet" product, solves this problem for a different app. It's a sidebar that opens inside an actual Excel workbook, sees it directly, and edits live, no upload, no paste. But it's built for Excel specifically; the official setup article never mentions Google Sheets or Google Workspace (support.claude.com). If your work already lives in Excel, that guide covers it: Claude for Excel: the beginner's setup guide.

An older Anthropic add-on called "Claude for Sheets," which added an =CLAUDE() formula you could call from inside a cell, used to fill this gap. Its docs page now redirects to a 404, and it no longer shows up in a Google Workspace Marketplace search. Treat it as discontinued rather than something worth installing.

The workflow that actually works

None of this makes Claude useless for Sheets work, it just means you're the one carrying data in and formulas back out.

“You're the one carrying the data across the gap, and the one who has to check it landed right.”

Google Sheets formulas aren't Excel formulas

This is the detail that trips people up most. Sheets and Excel diverge on how they spread a formula down a column and how they filter or aggregate data. Excel leans on dynamic arrays, XLOOKUP, and SUMIFS. Sheets favors ARRAYFORMULA() to apply one formula to a whole range, and QUERY() for SQL-like filtering, something like:

=ARRAYFORMULA(QUERY({Transactions!C:C, Transactions!E:E}, "SELECT Col1, SUM(Col2) WHERE Col2 < 0 GROUP BY Col1"))

If you don't say which app you're using, Claude has no way to know, and it's just as likely to hand you a perfectly good Excel formula that throws an error the moment you paste it into Sheets. Tested on Claude Opus 4.6, July 2026: asked to "sum sales by region" with no app named, it returned a SUMIFS formula. Asked the same question but naming Google Sheets, it returned a working ARRAYFORMULA(QUERY(...)) on the first try, no follow-up needed.

Where this falls short

• The Drive connector strips formulas on the way in. If you need Claude to read or edit actual formulas in a Google Sheet, not just values, none of the official paths do that. Only a custom API or MCP integration reaches that far.
• Nothing writes back automatically. Whether you paste data in or connect Drive, getting an answer into the sheet is a manual step, every time.
• Sheets-vs-Excel confusion is the most common failure mode. Always name the app in your prompt, especially for anything beyond a simple SUM or COUNT.
• Third-party Sheets add-ons exist but aren't Anthropic's. Marketplace tools that bundle Claude alongside GPT and Gemini run on their own billing and their own quality bar, not Claude's.
• Uploads and downloads have different size caps. Files you upload to a chat can run up to 500MB (support.claude.com), but a file Claude generates for you to download tops out at 30MB (support.claude.com), worth knowing before you try to hand back a huge workbook.

Common questions

Is there a Claude add-on for Google Sheets?

Not currently. Anthropic's official spreadsheet add-in, Claude for Excel, only runs inside Microsoft Excel. The Google Drive connector can read a sheet as CSV, but it doesn't add a sidebar or custom formula inside Sheets itself, and an older =CLAUDE() add-on appears to have been discontinued.

Can Claude write Google Sheets formulas?

Yes. Paste your data into claude.ai, describe what you want in plain English, and say it's for Google Sheets. Claude will lean on Sheets-specific functions like ARRAYFORMULA() and QUERY() instead of Excel patterns, and you paste the result into your cell yourself.

Can Claude edit my Google Sheet directly?

No. There's no official connection that lets Claude open and edit a live Google Sheet the way the Excel add-in edits an open workbook. Every official path, chat, upload, or the Drive connector, works from a static snapshot, so you're always the one pasting the result back in.

What happened to the old Claude for Sheets add-on?

It appears to be discontinued. Its documentation page now redirects to a 404, and it no longer turns up in a Google Workspace Marketplace search. If you find install instructions for it on a third-party site, check that the link still works before trusting it.

claude/for is an independent guide, not run by Anthropic or Google. If your spreadsheet work happens in Excel instead, the setup is genuinely different and worth its own read: Claude for Excel: the beginner's setup guide. And if you've never asked Claude for a formula at all, Claude prompts for work includes a copy-paste formula prompt to start from.