Analyze business data from Google Sheets with an OpenAI chatbot
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 8 nodes and runs when a chat message arrives. Along the way it connects OpenAI Chat Model and Google Sheets.
How it runs
Trigger: When a chat message arrives.
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 2 tools (E-commerce Orders & Customer Analysis, Marketing Campaign Performance Analysis); memory: Simple Memory
- Edit Fields (Edit Fields (Set)): sets 1 field: response
- Chat: uses Chat
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- AI Agent
@n8n/n8n-nodes-langchain.agent - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Edit Fields (Set)
n8n-nodes-base.set - Chat
@n8n/n8n-nodes-langchain.chat - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger
From the author
Business Data Analyst Chatbot Overview This workflow is a chat-based Business Data Analyst Chatbot built in n8n. It allows users to ask business questions in plain English and receive clean, stakeholder-friendly insights based on data stored in one or more…