Route WhatsApp customer support with Gemini, Google Sheets, and Calendar
Ready for 3.0What this workflow does
This AI workflow has 22 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Gemini Chat Model, Redis Chat Memory, Google Calendar and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Normalize Incoming Message (Edit Fields (Set)): sets 6 fields: chatId, phone, pushName…
- Guard - Ignore Bot & Empty (If): checks a condition and branches into true / false
- Config (Edit Fields (Set)): sets 8 fields: evolutionBaseUrl, instanceName, sheetId…
- AI Orchestrator (AI Agent): runs an AI agent, with model: Orchestrator Model; 4 tools (Sales Agent, Finance Agent, Support Agent, Schedule Meeting); memory: Orchestrator Memory; output parser: Structured Output
- Check If Should Log (If): checks a condition and branches into true / false
- Log Lead to Google Sheets (Google Sheets): append or update
- Send WhatsApp Reply (HTTP Request): calls an HTTP API (POST)
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 (12)
- Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Redis Chat Memory
@n8n/n8n-nodes-langchain.memoryRedisChat - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Calendar Tool
n8n-nodes-base.googleCalendarTool - AI Agent Tool
@n8n/n8n-nodes-langchain.agentTool - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick overview This workflow receives WhatsApp messages via Evolution API, uses Google Gemini multi-agent routing with Redis conversation memory to generate specialist replies, optionally schedules meetings in Google Calendar, logs qualified leads to Google…