Run a hotel WhatsApp concierge using Google Gemini and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 19 nodes and runs on WhatsApp events (messages) (plus 1 other trigger). Along the way it connects WhatsApp Business Cloud, Google Sheets, Google Gemini Chat Model and Google Docs and 1 more.
How it runs
Trigger: On WhatsApp events (messages) (plus 1 other trigger).
- Check Message Body (If): checks a condition and branches into true / false
- Sync Masked Reservations (Google Sheets): append or update
- Read Guest Details Sheet (Google Sheets): uses Google Sheets
- Check If DND Enabled (If): checks a condition and branches into true / false
- Read Reservations Sheet (Google Sheets): uses Google Sheets
- Read Service Requests Sheet (Google Sheets): uses Google Sheets
- Filter Active Reservation (Code): runs custom JavaScript code
- Hotel Concierge Agent (AI Agent): runs an AI agent, with model: Gemini AI Model; 5 tools (Create User Tool, Update DND Status Tool, Upsert Reservation Tool, Create Service Request Tool…); memory: Load Chat Memory
- Send WhatsApp Response (WhatsApp Business Cloud): send
- Get Hotel Aminities (Google Docs Tool): get
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 (11)
- WhatsApp Trigger
n8n-nodes-base.whatsAppTrigger - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Code
n8n-nodes-base.code - Google Docs Tool
n8n-nodes-base.googleDocsTool - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Redis Chat Memory
@n8n/n8n-nodes-langchain.memoryRedisChat
From the author
Quick overview Youtube Video: https://youtu.be/q2vPN9eub1o?si=lSo4c0kQMNQdAad This workflow acts as a WhatsApp hotel concierge that looks up guest profiles, reservations, and open service requests in Google Sheets, consults a Google Docs amenities guide, and…