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:

  1. Go to Extensions > GPT for Sheets and Docs > Set API key
  2. Enter your Anthropic API key
  3. 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.

Get started with GPT for Sheets guide

Watch video tutorials