How to connect Claude to Google Sheets
The GPT for Work add-on lets you run an AI agent powered by Claude right inside Google Sheets. Ask it in plain language to write and fix formulas, build charts and pivot tables, format and reorganize data, generate tables, or analyze and summarize a sheet — and it can also work row-by-row across thousands of cells for bulk tasks like translation, categorization, and enrichment. Here's how to connect it:
Step 1: Install the GPT for Sheets and Docs add-on
Install from the Google Workspace Marketplace: GPT for Sheets and Docs
Step 2: Launch GPT for Sheets and Docs
In a Google spreadsheet, go to Extensions → GPT for Sheets and Docs → Open.
Step 3: Use Claude with the Agent
In the sidebar, select Agent, open the Agent's model switcher, and choose a Claude model — the latest is Claude Opus 4.8, with Opus 4.7 and 4.6 also available. (The exact list depends on what's enabled for your space in the dashboard.) Then just describe what you want and the agent does it in your sheet.
For the bulk tools and GPT functions, you can pick faster Claude models such as Claude Sonnet 4.6 or Claude Haiku 4.5 from their own model selector.
Frequently asked questions
Do I need an Anthropic API key?
No. Claude is available through the GPT for Work add-on without your own API key — usage runs on your GPT for Work credits or subscription. You can optionally connect your own Anthropic API key, in which case you pay Anthropic directly for model usage, plus a GPT for Work platform fee — $1 per 1M tokens on pay-as-you-go, or $1 per 1,000 requests on a subscription. See GPT for Work pricing.
Which Claude models can I use?
For the agent, the latest Claude Opus models — currently Opus 4.8, 4.7, and 4.6. For the bulk tools and GPT functions, faster models such as Claude Sonnet 4.6 and Claude Haiku 4.5. The exact list depends on what's enabled for your space, and connecting your own Anthropic API key unlocks additional models.
How much does it cost?
GPT for Work is free to install with free credits to start (no card required). After that it's pay-as-you-go (credit packs from $29, valid 12 months) or a subscription (from $25 per seat); each task uses credits based on its complexity and the model you choose. See pricing.
What can I do with Claude in Google Sheets?
Ask the agent to write and fix formulas, build charts and pivot tables, format and clean data, generate tables, and analyze or summarize your sheet — or run bulk row-by-row tasks like translation, categorization, content generation, and web search.