How to connect Claude to Google Sheets
You can connect Claude to Google Sheets with the GPT for Sheets extension:
Step 1: Install the GPT for Sheets and Docs add-on
Install from the marketplace: https://workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
Step 2: Get your Anthropic API key
You can get an API key from the Anthropic dashboard: https://console.anthropic.com/account/keys
Step 3: Setup your API key in GPT for Sheets and Docs
In a spreadsheet:
- Go to Extensions > GPT for Sheets and Docs > Open sidebar
- Click on the top left hamburger menu > API keys
- Enter your Anthropic API key
- Click save
If you encounter an issue setting up your API key, please read our full api key setup guide here: https://gptforwork.com/help/gpt-for-sheets/setup-api-keys/set-up-anthropic-api-key
Step 4: Use Claude in Google Sheets
Select claude-3-haiku, claude-3-sonnet or claude-3-opus (not recommended as it is too slow and very expensive) from the top model switcher dropdown. Claude is now connected to Google Sheets, and you can ask it anything via the GPT functions or bulk tools.