You can connect ChatGPT 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 OpenAI API key
You can get an API key from the OpenAI dashboard: https://platform.openai.com/account/api-keys
If you have never created an API key, read our full guide.
Step 3: Setup your API key in GPT for Sheets and Docs
In a spreadsheet:
- Go to Extensions > GPT for Sheets and Docs > Launch sidebar
- Enter your 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-api-key
Step 4: Use ChatGPT in Google Sheets
ChatGPT is now connected to Google Sheets, and you can ask it anything via the GPT functions.