# n8n Talk to Your Google Sheet: 4 Steps and One Check > A visual guide to n8n’s chat-with-your-sheet template: add your OpenAI credential, point it at your sheet, ask questions and check every total by hand. Source: https://learn.ynteractive.com/content/visual/n8n-talk-to-your-google-sheet-4-steps-and-a-check · Updated 2026-10-11 · Free from Stepthrough (https://learn.ynteractive.com) [Step-by-step guide](https://learn.ynteractive.com/content/visual#format-steps-carousel) · 7 slides · [n8n](https://learn.ynteractive.com/content/tool/n8n) By [Robert Breen](https://learn.ynteractive.com/content/about) · Published October 11, 2026 · From the free lesson [n8n: Talk to Your Google Sheets with ChatGPT, from Zero (Free Credits or API Key, Google, Sheet, Chat)](https://learn.ynteractive.com/content/n8n-talk-to-google-sheets-chatgpt-ai-agent) A visual guide to n8n’s chat-with-your-sheet template: add your OpenAI credential, point it at your sheet, ask questions and check every total by hand. Swipe or scroll sideways for all 7 slides. The whole guide is written out below. ## The guide in text A client roster in Google Sheets, n8n’s template #7639 and an OpenAI key. A made-up advisory firm, Ashford. 4 steps. ## Step by step 1. ### Give the chat model your OpenAI credential A template cannot bring its own key. Open OpenAI Chat Model, pick your credential, and set the model By ID. The template uses gpt-4.1-nano, the cheapest. 2. ### Point Analyze Data at your sheet Pick the Google credential for the account that owns the spreadsheet, then the document and the tab. Row 1 holds the column names; the data starts in row 2. 3. ### Check n8n can read your rows Click Execute step. The Output panel should fill with one entry per client. If you can see your data there, the agent can see it too. 4. ### Ask, then check the maths Ask Which clients are At Risk? Then ask for a total and add the numbers yourself: 2,500 + 1,800 + 1,900 is 6,200. In the lesson’s first test the agent said 5,200. ## What is in the template - Chat trigger: takes your question. - Agent: decides what to do. - OpenAI Chat Model: does the thinking. Memory: remembers the chat. - Analyze Data: a Google Sheets tool that only reads, so it cannot change your sheet. Businesses and people in the examples are made up (Ashford Advisory Group is a made-up business). The steps, screens and wording come from the free lesson and the Stepthrough glossary and prompt library. ## Do it yourself, free **n8n: Talk to Your Google Sheets with ChatGPT, from Zero (Free Credits or API Key, Google, Sheet, Chat)**. Start from nothing: copy n8n template 7639, use n8n's free credits (or your own OpenAI API key), connect Google, make your own sheet, then ask it questions in plain English. You do every step yourself in a practice copy of n8n, it checks your work as you go, and “Do it for me” finishes any step you get stuck on. Free, and nothing touches your real accounts. [Start the free lesson](https://learn.ynteractive.com/modules/n8n-talk-to-sheets) [Or read the full step-by-step guide](https://learn.ynteractive.com/content/n8n-talk-to-google-sheets-chatgpt-ai-agent) ## Related terms Plain-English definitions, each with an example from a free lesson. [AI Agent node](https://learn.ynteractive.com/content/glossary/ai-agent-node) · [Credential](https://learn.ynteractive.com/content/glossary/credential) · [Google Sheets (as an automation database)](https://learn.ynteractive.com/content/glossary/google-sheets) · [Header row](https://learn.ynteractive.com/content/glossary/header-row) · [AI math errors](https://learn.ynteractive.com/content/glossary/ai-math-errors) · [Chat with your data](https://learn.ynteractive.com/content/glossary/chat-with-your-data) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Related prompts - [Sheet question and total checker prompt](https://learn.ynteractive.com/content/prompts/spreadsheet-question-checker-prompt): Ask an AI agent about a spreadsheet and make it show its rows, so you can add the numbers yourself before you repeat a total to… [All free prompt templates](https://learn.ynteractive.com/content/prompts) ## From the blog - [How to Check AI Output Before You Use It: 7 Checks](https://learn.ynteractive.com/content/blog/check-ai-output-before-you-use-it): Seven checks for AI output at work, each from a free lesson: totals, promises, rules, extras, numbers, green checks and the final read before you send. ## More visual guides - [n8n Webhook: Test URL vs Production URL, Explained](https://learn.ynteractive.com/content/visual/n8n-test-url-vs-production-url-webhook): A visual guide to the two n8n webhook addresses: the Test URL that listens only while you test, and the Production URL that works once you publish. - [Email each tech their jobs at 7am with n8n](https://learn.ynteractive.com/content/visual/job-alerts-n8n): Every morning someone at Rapid Flow Plumbing copies the day's jobs into emails, one tech at a time. Hand it to n8n. - [5 Steps to an AI Agent That Categorizes Business Expenses](https://learn.ynteractive.com/content/visual/5-steps-ai-expense-categorizer): A visual guide: an n8n agent sorts expenses into a fixed list of categories, flags unclear ones as Needs Review and saves them to Google Sheets. [All visual guides](https://learn.ynteractive.com/content/visual) · [All free tutorials](https://learn.ynteractive.com/content)