Copy-paste Claude formulas for Google Sheets
Paste a formula into row 2, test it on a few rows, then drag down to run the workflow across your spreadsheet.
First Claude formula
A: input cell
=GPT("Summarize the following in one clear sentence: " & A2)
Enrich a company
A: company · B: notes · C: offer
=GPT("Research this company for outreach: " & A2 & ". Notes: " & B2 & ". Offer: " & C2 & ". Return a short summary, likely industry, and one relevance signal. If unsure, say Needs manual research.")
Clean / normalize
A: messy value · B: target format
=GPT("Normalize this value to the target format. Value: " & A2 & ". Target format: " & B2 & ". Return only the cleaned value.")
Fit score 1-5
A: account · B: ICP · C: source text
=GPT("Score 1-5 for ICP fit. Account: " & A2 & ". ICP: " & B2 & ". Source: " & C2 & ". Return score, reason, confidence, and what to verify.")
Short answer
You can use Claude in Google Sheets by creating a Claude (Anthropic) API key and adding it to GPT for Sheets. After the key is connected, you select Claude as your model and call it from a spreadsheet formula such as =GPT(…), then fill that formula down to run Claude across every row.
Fastest path: Install GPT for Sheets → select Claude and paste your Anthropic API key → paste a formula from the formula section → review 10 rows → fill down the sheet.
This page is for analysts, sales and ops teams, and SEO teams setting up Claude in Sheets for the first time and who want to put it to work across a list rather than chatting with it row by row.
What you need
Before you start, make sure you have these three things:
| Requirement | What it is | Why it matters |
|---|---|---|
| Anthropic account | A free account in Anthropic’s console | This is where you generate and manage your Claude API key |
| A Claude API key | A secret string from the console | GPT for Sheets uses it to call Claude on your behalf |
| GPT for Sheets | The Google Workspace add-on | Lets you call Claude from a =GPT formula in any sheet |
A Claude API key carries its own usage costs billed by Anthropic based on the model and number of tokens you use. Steps, model names, and pricing in the Anthropic console can change, so confirm the current flow in Anthropic’s own documentation when you set up.
Step by step
- Create or sign in to your Anthropic account in the Anthropic console.
- Generate an API key from the API keys section and copy it once — treat it like a password and store it somewhere safe.
- Install GPT for Sheets from the Google Workspace Marketplace and open it from the Extensions menu.
- Select Claude (Anthropic) as your model in the add-on and paste your API key when prompted.
- Run your first formula: type
=GPT("Say hello in one sentence")into a cell to confirm the key works. - Enrich, clean, or score across rows: paste a formula from the section below into row 2, review the output, then fill it down.
Where to add the key
You add the key inside the GPT for Sheets add-on settings, not in a cell. Keeping the key in the add-on means your formulas stay clean and your secret is never written into a shared cell. If you collaborate on a sheet, each editor can manage their own provider settings.
Use cases
- Enrichment: add company or contact context across a whole list.
- Cleanup: normalize names, titles, and messy exports into one format.
- Classification: tag rows by industry, intent, or category.
- Scoring: rate fit with a reason and a confidence note.
- Drafting: generate summaries, openers, or replies per row.
Keys, models, rate limits, and cost notes
Claude is available in several model tiers; lighter models cost less per call and are good for cleanup and classification, while larger models suit nuanced research and drafting. Usage is billed by Anthropic, and high-volume fills can hit rate limits, so test on a sample before running thousands of rows. Exact model names, limits, and prices change over time — check Anthropic’s console for current details.
Troubleshooting
- Invalid key: re-copy the key from the console; stray spaces are the most common cause.
- Quota or rate-limit errors: slow the fill down, run in smaller batches, or check your Anthropic usage limits.
- Empty or truncated output: shorten the prompt, reduce the number of cells referenced, or split the work into two columns.
- Wrong model behavior: confirm Claude is the selected model in the add-on and not a different provider.
Internal links and next workflows
- GPT for Sheets product page
- GPT for Sheets pricing
- Connect Claude to Google Sheets
- Claude for Google Sheets how-to guide
- Claude for Google Sheets lead enrichment
- Upgrade GPT for Sheets
Safety, compliance, and data quality
Treat Claude output as a draft. Keep source columns visible, verify important claims before acting, and do not infer sensitive attributes. Never paste your API key into a shared cell, and use lawful data while following consent and deliverability rules for any outreach generated in the sheet. “Claude” and “Anthropic” are trademarks of their owner; this page is unaffiliated.
Frequently Asked Questions
How do I get a Claude API key?
Create an Anthropic account, open the API keys section of the console, generate a key, and copy it once. Then paste it into the GPT for Sheets add-on settings and select Claude as your model.
Do I need to pay for a Claude API key?
The key itself is generated in your Anthropic account, but Claude API usage is billed by Anthropic based on the model and tokens you use. Pricing can change, so check Anthropic’s current rates.
Where do I put the key in Google Sheets?
You add it in the GPT for Sheets add-on settings, not in a cell. That keeps your formulas clean and your key out of shared cells.
Can I switch between Claude and other models?
Yes. GPT for Sheets lets you select Claude, GPT, Gemini, and other models, so you can compare results on the same rows by changing the selected model.
Start using Claude in Google Sheets
Add your Anthropic API key to GPT for Sheets and run Claude across every row in minutes.