Templates / Run a hotel WhatsApp concierge using Google Gemini and Google Sheets

Run a hotel WhatsApp concierge using Google Gemini and Google Sheets

Ready for 3.0

by iamvaar ✓ · 258 views · created 2026-06-30 · Support Chatbot, AI Chatbot

Ready 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 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).

  1. Check Message Body (If): checks a condition and branches into true / false
  2. Sync Masked Reservations (Google Sheets): append or update
  3. Read Guest Details Sheet (Google Sheets): uses Google Sheets
  4. Check If DND Enabled (If): checks a condition and branches into true / false
  5. Read Reservations Sheet (Google Sheets): uses Google Sheets
  6. Read Service Requests Sheet (Google Sheets): uses Google Sheets
  7. Filter Active Reservation (Code): runs custom JavaScript code
  8. 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
  9. Send WhatsApp Response (WhatsApp Business Cloud): send
  10. Get Hotel Aminities (Google Docs Tool): get

Services it uses

WhatsApp Business CloudGoogle SheetsGoogle Gemini Chat ModelGoogle DocsRedis Chat Memory

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)

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…

Excerpt from iamvaar's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.