Sales CRM chatbot with GPT-4o-mini, Google Sheets lookup & memory
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 10 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 Sales CRM Router (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 2 tools (outreachSheet, opportunitySheet); memory: Conversation Memory Buffer
- Validate AI Output Payload (If): checks a condition and branches into true / false
- Write Chat Memory to Google Sheets (Google Sheets): append
- Log Invalid Chat Records to Google Sheets (Google Sheets): append
- Send Chat 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 (8)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - AI Agent
@n8n/n8n-nodes-langchain.agent - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Chat
@n8n/n8n-nodes-langchain.chat
From the author
📘 Description: 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 real records. It integrates GPT-4o-mini with…