Hotel receptionist with WhatsApp, Gemini model-switching, Redis & 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 13 nodes and runs on WhatsApp events (messages). Along the way it connects Google Gemini Chat Model, Google Sheets, WhatsApp Business Cloud and MySQL and 2 more.
How it runs
Trigger: On WhatsApp events (messages).
- Check Message (Code): runs custom JavaScript code
- Check User Number (Redis): get
- Model Decider (Code): runs custom JavaScript code
- Store User Number (Redis): set
- AI Agent: runs an AI agent, with model: Choose Model; 2 tools (Pricing, Execute a SQL query in MySQL); memory: Simple Memory
- Send message (WhatsApp Business Cloud): send
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 (10)
- AI Agent
@n8n/n8n-nodes-langchain.agent - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - Code
n8n-nodes-base.code - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - My Sql Tool
n8n-nodes-base.mySqlTool - Redis
n8n-nodes-base.redis - Model Selector
@n8n/n8n-nodes-langchain.modelSelector
From the author
Overview This project is an AI-powered hotel receptionist built using n8n, designed to handle guest queries automatically through WhatsApp. It integrates Google Gemini, Redis, MySQL, and Google Sheets via LangChain to create an intelligent conversational…