{"product_id":"chat-with-google-sheets-data-using-gpt-4o-mini-n8n","title":"Chat with Google Sheets Data using GPT-4o-mini \u0026 n8n","description":"\u003ch3\u003eChat with your live Google Sheets data—ask in plain English and get real numbers\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets you open a chat, ask questions like \u003cem\u003e“best month?”\u003c\/em\u003e or \u003cem\u003e“revenue by country”\u003c\/em\u003e, and have an AI agent read your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e in real time to compute answers from the actual rows—no guessing. With conversation memory, follow-up questions also work naturally.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhen You Ask a Question\u003c\/strong\u003e: Use n8n’s hosted chat (the \u003cem\u003eWhen User Asks Question → Chat\u003c\/em\u003e step) to type your request in plain language.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnswer With Data, Not Guesses\u003c\/strong\u003e: The AI agent uses the \u003cstrong\u003eRead the Spreadsheet\u003c\/strong\u003e tool to pull live rows from your selected Google Sheet and compute the result from real data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConversation memory\u003c\/strong\u003e: Context is kept so you can ask follow-ups like “and the month before that?”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNumbers in the chat\u003c\/strong\u003e: Responses return in the chat with the actual computed values.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup (five-minute setup)\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConnect an \u003cstrong\u003eOpenAI (or compatible)\u003c\/strong\u003e credential in \u003cstrong\u003eOpenAI Analyst Model\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eConnect your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e account in \u003cstrong\u003eRead Data from Sheets\u003c\/strong\u003e and select the spreadsheet + sheet the agent should read.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional, recommended\u003c\/strong\u003e: Add a one-line description of your columns in the \u003cstrong\u003eData-Driven Response Agent\u003c\/strong\u003e system message (e.g., “Columns: Date, Country, Revenue in USD”).\u003c\/li\u003e\n  \u003cli\u003eActivate the workflow and test via the chat.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFind trends: “What was our best month?”\u003c\/li\u003e\n  \u003cli\u003eSlice performance: “Revenue by country?”\u003c\/li\u003e\n  \u003cli\u003eData QA: “Which rows are missing an email?”\u003c\/li\u003e\n  \u003cli\u003eFast reporting for SaaS ops without building new dashboards.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes\u003c\/strong\u003e: \u003cem\u003en8nn8n-nodes-langchainagent\u003c\/em\u003e, \u003cem\u003egoogle sheets tool\u003c\/em\u003e, \u003cem\u003en8nn8n-nodes-langchainchat trigger\u003c\/em\u003e, \u003cem\u003en8nn8n-nodes-langchainlm chat open ai\u003c\/em\u003e, \u003cem\u003en8nn8n-nodes-langchainmemory buffer window\u003c\/em\u003e, plus a language-model\/chat setup and a system prompt configuration.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequirements\u003c\/strong\u003e: OpenAI (or compatible) API key + Google Sheets access.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862254215347,"sku":"N8N-18050","price":67.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/hnO8Hn49YqIEL3MIvhmxr_P3ikM7iR.png?v=1786958366","url":"https:\/\/buyflowscripts.com\/products\/chat-with-google-sheets-data-using-gpt-4o-mini-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}