Claude for Google Sheets: add-on, connector, or chat?

Claude works with Google Sheets in three genuinely different ways. Anthropic still publishes an official Claude for Sheets add-on that runs =CLAUDE() inside cells using your Anthropic API key. The Google Drive connector can pull a sheet into Claude as a flattened CSV snapshot, but cannot write back to the live sheet. And for a one-off formula, the simplest path is still copy-paste: show Claude the data, get a formula, paste it in, and check the result.

How Claude works with Google Sheets: three paths

1. Claude for Sheets add-on: an API-powered cell function

Anthropic's official Google Workspace Marketplace listing is still listed under Anthropic and documents the =CLAUDE() and =CLAUDEMESSAGES() functions. Install the add-on, enter an Anthropic Console API key, and those functions become available inside the sheet. Anthropic's older standalone documentation URL currently returns a 404, so the Marketplace listing is the primary live reference for this path.

This is not a Claude Pro feature and it is not an agent that freely edits the whole workbook. Each function sends the prompt and referenced cell values to the Anthropic API, then places the response in the formula cell. The add-on itself is free to install, but API calls are billed separately to the Console account behind the key. Be particularly careful when sharing a sheet that already contains the configured add-on: usage can still be billed to that API account.

2. Google Drive connector: read a CSV snapshot

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 sees it, and the connector does not write values or formulas back into the existing sheet (claude.com). See Claude connectors for the bigger picture on connecting a service to Claude.

Claude for Excel is still the more capable live-workbook product: its sidebar can inspect and edit an open workbook rather than returning a value from a custom function. It is built for Excel specifically (support.claude.com). If your work already lives there, see Claude for Excel: the beginner's setup guide.

3. Chat: the easiest path for a one-off formula

Paste a representative range into Claude, or upload a CSV/XLSX file, ask for a Google Sheets formula, then paste the answer back yourself. This costs no API setup and works on every Claude plan, but Claude never sees the formula calculate in your live sheet.

The simplest beginner workflow

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 may hand you an Excel-oriented answer that behaves differently when pasted into Sheets. Name Google Sheets explicitly, then verify the result against a row where you already know the answer.

Where this falls short

• The Drive connector strips formulas on the way in. It receives a CSV export, not the workbook's formula graph.
• The add-on is not included in a Claude subscription. It uses a Console API key and pay-as-you-go API billing. It writes its response into the formula cell, but does not freely edit the rest of the sheet.
• Chat and Drive do not write back automatically. Getting their answers into the sheet remains a manual step.
• 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?

Yes. Anthropic's official Claude for Sheets add-on provides =CLAUDE() and =CLAUDEMESSAGES() functions. It requires an Anthropic Console API key and its usage is billed through the API, separately from a Claude.ai subscription.

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?

Not the way the Excel add-in edits an open workbook. Claude for Sheets can calculate a response inside a formula cell from the prompt and ranges you pass it. Chat and the Drive connector cannot write back to the sheet.

Is Claude for Sheets included with Pro or Max?

No. The add-on uses the Anthropic API, so you need a Console API key and pay for API usage separately. Your Claude.ai subscription does not cover those calls.

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.