How to connect ChatGPT to Google Sheets
The GPT for Work add-on lets you run an AI agent powered by ChatGPT right inside Google Sheets. Ask it in plain language to write and fix formulas, build charts and pivot tables, format and reorganize data, generate tables, or analyze and summarize a sheet. It also works row by row across thousands of cells for bulk tasks like translation, categorization, and enrichment. Here's how to connect it:
Step 1: Install the GPT for Sheets and Docs add-on
Install from the Google Workspace Marketplace: GPT for Sheets and Docs
Step 2: Launch GPT for Sheets and Docs
In a Google spreadsheet, go to Extensions → GPT for Sheets and Docs → Open. The add-on opens in a sidebar with three tabs: Agent, Bulk tools, and GPT functions.
Step 3: Pick a ChatGPT model in the Agent
Select the Agent tab, then open the model switcher below the prompt box and choose a ChatGPT model. Model selection for the agent lives inside the Agent tab, not in a switcher at the top of the sidebar, and the list you see depends on what is enabled for your space in the dashboard.
The agent runs on the latest GPT-5 series models. The bulk tools and GPT functions have their own model switcher and accept a wider ChatGPT line-up, including the smaller fast models and a dedicated web search model. For the current list, see AI providers and models.
Then describe what you want and the agent does it in your sheet.
Frequently asked questions
Do I need an OpenAI API key?
No. ChatGPT is available through the GPT for Work add-on without your own API key, and usage runs on your GPT for Work credits or subscription. Connecting your own OpenAI API key is optional and unlocks additional models.
Which ChatGPT models can I use?
The agent runs on the latest GPT-5 series models. The bulk tools and GPT functions accept a wider line-up, including smaller fast models and a dedicated web search model. The live list is on AI providers and models, and what you can select also depends on what is enabled for your space.
How much does it cost?
GPT for Work is free to install with free credits to start, and no card is required. After that it is pay-as-you-go (credit packs from $29, valid 12 months) or a subscription (from $25 per month). Each task uses credits based on its complexity and the model you choose. See pricing.
What can I do with ChatGPT in Google Sheets?
Ask the agent to write and fix formulas, build charts and pivot tables, format and clean data, generate tables, and analyze or summarize your sheet. You can also run bulk row-by-row tasks like translation, categorization, content generation, and web search.
Why use this instead of the official ChatGPT add-in?
OpenAI's own add-in is a side-panel assistant for the workbook in front of you, and it only ever runs OpenAI models. GPT for Work is built for the job a chat panel cannot do. It runs one prompt down a whole column at up to 1,000 rows per minute and up to 200,000 rows in a single run, writing each result straight into your sheet, and it exposes AI as a spreadsheet function with =GPT(). You also get ChatGPT and Claude in the same add-on across both Google Sheets and Excel, so you can pick the model per task without switching tools or paying for a second AI subscription.