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 > Set API key
- 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/set-up-anthropic-key
Step 4: Use Claude in Google Sheets
Select Claude instant or Claude 2 from the Default settings menu in the sidebar. Claude is now connected to Google Sheets, and you can ask it anything via the GPT functions.