There are two ways to connect ChatGPT to Google Sheets: install an add-on such as GPT for Work, which puts AI functions inside the sheet, or build a small n8n workflow that gives an OpenAI model your Google sign-in so it can read and write rows. If you want to ask your sheet questions in plain English, start with the free lesson n8n: Talk to Your Google Sheets with ChatGPT.
Which one fits depends on the job. If you want AI to fill or tidy cells while you work, use an add-on. If you want a chat that answers from the sheet, or rows that update on their own when something happens, use n8n. Uploading a one-off export to ChatGPT also works, but nothing stays connected.
Which route should I pick?
| You want to... | Use | What it does |
|---|---|---|
| Write formulas or fill a column with AI | An add-on like GPT for Work, or Gemini in Sheets | Runs AI on cells inside the sheet |
| Ask questions about a sheet in a chat | n8n AI agent | The agent reads the rows and answers |
| Add or update rows with AI text | n8n workflow | Reads, writes and matches rows on a key |
| Keep a sheet full of live data from other apps | Coefficient | Imports data and refreshes it on a schedule |
Google's own Gemini in Sheets is the closest thing to a built-in option if your company uses Google Workspace with Gemini. It is Google's model rather than ChatGPT.
How do I set up the add-on route?
- In Google Sheets, open Extensions, then Add-ons, then Get add-ons.
- Search for the add-on (GPT for Work lists itself as "GPT for Sheets and Docs"), click Install and allow the permissions with your Google account.
- Open it from the Extensions menu. Each add-on has its own panel and functions, so follow its help page for the exact names.
- Try it on a copy of the sheet first, on a few rows, and check the results before you fill a whole column.
How do I set up the n8n route?
- Get a workflow. Copy n8n's chat-with-sheets template into a new n8n workflow, or build an AI Agent with a Google Sheets tool.
- Give it a model. In the OpenAI Chat Model node, pick n8n's free Gateway credits if your account has them, or your own OpenAI API key. The API is billed separately from a ChatGPT subscription.
- Connect Google. In the Google Sheets node, create a credential and click Sign in with Google.
- Pick the document and the tab from the lists, then click Execute step to check that your rows appear.
- Open chat at the bottom of the canvas and ask a question.
The blog post on connecting Google Sheets and Gmail to n8n covers the sign-in step in more detail.
What does this look like in a real lesson?
In n8n: Talk to Your Google Sheets with ChatGPT you start with nothing. You copy n8n template 7639, paste it onto the canvas, choose Gateway credits and the gpt-5-mini model, sign in with Google, make your own copy of a sample marketing sheet and pick its Data tab. Then you open the chat and ask, "What was the total spend for Paid Search?", and follow up with "Now the same for Email only." The lesson ends with a check: click Analyze Data in the Logs panel to see what the agent read, then filter the sheet yourself, because models can slip on sums. The agent only reads, so it never changes your sheet.
If you want AI to write into the sheet, n8n: Read, Add and Update Google Sheets Rows adds a new request with Append or Update Row, matching on Email so a second run never duplicates the person, then has an AI step write a one-sentence description for each row and writes it back. The n8n chat with Google Sheets post explains the agent template on its own.
For the "live data" job, the Coefficient lesson imports a pipeline of 12 made-up deals into a report sheet and sets a daily refresh, so nobody copies it by hand on Mondays.
What mistakes should I avoid?
- Testing on the real sheet. Make a copy first. A write step can overwrite or duplicate rows.
- Using plain Append when a row may come twice. Match on a unique column such as Email.
- Trusting AI sums. Check one total with a filter or a SUM in the sheet.
- Pasting an API key into a chat. Keys go in the tool's credential box only, and you treat them like passwords.
- Signing in with the wrong Google account. The credential only lists sheets that account can open.
Key takeaways
- An add-on puts AI functions inside the sheet. n8n lets a model read and write rows.
- Gemini in Sheets is Google's built-in option, not ChatGPT.
- n8n's free Gateway credits let you start without an OpenAI key.
- Match on a unique column so reruns do not duplicate rows.
- Always check one AI total against the sheet itself.
Frequently asked questions
- Can ChatGPT edit my Google Sheet directly from chatgpt.com?
Not as a live link that keeps updating. You can upload an export to a chat, but to read and write a real sheet on its own you need an add-on or an automation tool like n8n.
- Do I need an OpenAI API key?
Not always. Some add-ons include AI credits, and n8n Cloud may give new accounts free Gateway credits. When those run out, you add your own API key with prepaid credit.
- Is it safe to give n8n access to my Google account?
Google shows what n8n asks to do before you click Continue. Use a work account your company allows, and connect only the sheets the workflow needs.