Robert Breen This workflow corresponds to n8n.io template #7639 — we link there as the canonical source.
This workflow follows the Agent → Chat Trigger recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "d69576f3-5b9b-4e34-b99e-3b5d413d53aa",
"name": "Analyze Data",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
-1248,
1536
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 365710158,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit#gid=365710158",
"cachedResultName": "Data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit?usp=drivesdk",
"cachedResultName": "Sample Marketing Data - n8n"
}
},
"typeVersion": 4.7
},
{
"id": "1624d041-e483-40c0-b9be-f4db59d2e47e",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2064,
624
],
"parameters": {
"color": 7,
"width": 1152,
"height": 1168,
"content": "## Talk to Your Data with Google Sheets & OpenAI GPT-5 Mini\nThis n8n workflow template creates an intelligent data analysis chatbot that can answer questions about data stored in Google Sheets using OpenAI's GPT-5 Mini model. The system automatically analyzes your spreadsheet data and provides insights through natural language conversations.\n"
},
"typeVersion": 1
},
{
"id": "d706097e-d35b-453e-b03b-46e3d748e766",
"name": "Talk to Your Data",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-1328,
896
],
"parameters": {
"options": {
"systemMessage": "Google Sheets Ask-YOUR_OPENAI_KEY_HERE \n\n\nYou are Ask-YOUR_OPENAI_KEY_HERE. Answer questions using Google Sheets ONLY via the tool below. Be precise and conservative. \n\nThere is only one dataset. dont ask what dataset it is. \n\nUse the data tool to answer the question."
},
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "215688ba-02ff-4b66-ad67-f3dc309c4925",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2016,
784
],
"parameters": {
"color": 7,
"width": 480,
"height": 432,
"content": "### 3. Ask Questions of Your Data\n\nYou can ask natural language questions to analyze your marketing data, such as:\n- **Total spend** across all campaigns.\n- **Spend for Paid Search only**.\n- **Month-over-month changes** in ad spend.\n- **Top-performing campaigns** by conversion rate.\n- **Cost per lead** for each channel."
},
"typeVersion": 1
},
{
"id": "4c5f0e5d-91ea-4fcd-951d-15511c54de91",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2624,
624
],
"parameters": {
"width": 528,
"height": 1168,
"content": "## \ud83c\udfa5 Watch This Tutorial\n\n@[youtube](qsrVPdo6svc)\n\n\n### 1. Set Up OpenAI Connection\n\n#### Get Your API Key\n1. Visit the [OpenAI API Keys](https://platform.openai.com/api-keys) page.\n2. Go to [OpenAI Billing](https://platform.openai.com/settings/organization/billing/overview).\n3. Add funds to your billing account.\n4. Copy your API key into your **OpenAI credentials** in n8n (or your chosen platform).\n\n---\n### 2. Prepare Your Google Sheet\n\n#### Connect Your Data in Google Sheets\n- Data must follow this format: [Sample Marketing Data](https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit?gid=365710158#gid=365710158)\n- **First row** contains column names.\n- Data should be in **rows 2\u2013100**.\n- Log in using **OAuth**, then select your workbook and sheet.\n\n---\n### 3. Ask Questions of Your Data\n\nYou can ask natural language questions to analyze your marketing data, such as:\n- **Total spend** across all campaigns.\n- **Spend for Paid Search only**.\n- **Month-over-month changes** in ad spend.\n- **Top-performing campaigns** by conversion rate.\n- **Cost per lead** for each channel.\n\n---\n## \ud83d\udcec Need Help or Want to Customize This?\n\ud83d\udce7 [rbreen@ynteractive.com](mailto:rbreen@ynteractive.com) \n\ud83d\udd17 [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/)\n\n"
},
"typeVersion": 1
},
{
"id": "432f51ad-7cb7-4a24-8870-d38e8b79d375",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2016,
1264
],
"parameters": {
"color": 3,
"width": 480,
"height": 432,
"content": "### 1. Set Up OpenAI Connection\n\n#### Get API Key:\n1. Go to [OpenAI Platform](https://platform.openai.com/api-keys)\n1. Go to [OpenAI Billing](https://platform.openai.com/settings/organization/billing/overview)\n2. Add funds to your billing account & copy your api key into the openAI credentials\n"
},
"typeVersion": 1
},
{
"id": "2f2f8df6-78ee-47fe-a31c-af163264fc6b",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1472,
1264
],
"parameters": {
"color": 3,
"width": 512,
"height": 432,
"content": "### 2. Prepare Your Google Sheet\n\n#### Connect your Data in Google Sheets\n- Data must be in a format similar to this: [Sample Marketing Data](https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit?gid=365710158#gid=365710158)\n- First row contains column names\n- Data in rows 2-100\n- Log in with OAuth2 and choose your workbook and sheet\n- Optional: Try connecting to Airtable, Notion or your Database"
},
"typeVersion": 1
},
{
"id": "bc1c87fb-7541-49c0-9b36-11ecc10635fb",
"name": "Chat with Your Data",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-1840,
1056
],
"parameters": {
"options": {}
},
"typeVersion": 1.3
},
{
"id": "309f9320-246e-4fce-9ace-578e56ba8dfc",
"name": "Memory",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
-1296,
1088
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "a98560f8-4f56-49ac-8b5b-c78e92aa064f",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1472,
784
],
"parameters": {
"color": 7,
"width": 512,
"height": 432,
"content": ""
},
"typeVersion": 1
},
{
"id": "97112199-f351-46b4-aaa7-f18a7847703d",
"name": "OpenAI Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-1808,
1520
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-nano",
"cachedResultName": "gpt-4.1-nano"
},
"options": {}
},
"typeVersion": 1.2
}
],
"connections": {
"Memory": {
"ai_memory": [
[
{
"node": "Talk to Your Data",
"type": "ai_memory",
"index": 0
}
]
]
},
"Analyze Data": {
"ai_tool": [
[
{
"node": "Talk to Your Data",
"type": "ai_tool",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Talk to Your Data",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Chat with Your Data": {
"main": [
[
{
"node": "Talk to Your Data",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This n8n workflow template creates an intelligent data analysis chatbot that can answer questions about data stored in Google Sheets using OpenAI's GPT-5 Mini model. The system automatically analyzes your spreadsheet data and provides insights through natural language…
Source: https://n8n.io/workflows/7639/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Think Tool. Uses stickyNote, agent, googleCalendarTool, memoryBufferWindow. Chat trigger; 28 nodes.
Overview Meet Maria, a sophisticated AI Booking Agent designed for Veterinary Clinics (but easily adaptable to any service business). This workflow transforms a simple chat interface into a full-scale
This workflow creates a fully interactive AI-powered Sales CRM Chatbot inside n8n, capable of understanding user queries, searching Google Sheets for CRM data, and responding intelligently based on re
Generate high-quality, SEO-optimized content briefs automatically using AI, real-time keyword research, SERP intelligence, and historical content context. This workflow standardizes user inputs, fetch
This n8n workflow creates an intelligent AI agent that automates browser interactions through Airtop's browser automation platform. The agent can control real browser sessions, navigate websites, inte