Manage CRM leads by chat with Google Gemini and Google Sheets
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 Google Gemini Chat Model and Google Sheets.
How it runs
Trigger: When a chat message arrives.
- CRM Assistant Agent (AI Agent): runs an AI agent, with model: Agent Model; 3 tools (Add Lead, Calculator, List Leads); memory: Conversation Memory
- Tag Intent (Basic LLM Chain): sends a prompt to an LLM, with model: Intent Model
- Log Interaction (Google Sheets): append
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 - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick Overview This workflow provides a chat-based CRM assistant powered by Google Gemini that can append new leads to a Google Sheets “Leads” tab, answer pipeline questions by reading the sheet, and log each conversation message and intent to a “Chat Log”…