# Log hotel booking enquiries to Google Sheets with WhatsApp and Gmail

> Quick Overview This workflow collects hotel booking enquiries via an n8n Form, validates dates and guest count, logs each enquiry to Google Sheets, alerts reception via WhatsApp Business Cloud using a template message, and sends an automatic confirmation email to guests through Gmail when details look valid. How it works 1. Receives a new booking enquiry submission from an n8n Form. 2. Normalizes the form fields, validates check-in/check-out dates and maximum guest count, generates a booking reference, and builds a one-line summary. 3. Appends the enquiry details (including status, problems, and summary) as a new row in Google Sheets. 4. Sends a WhatsApp Business Cloud template message to the reception phone number with the enquiry summary. 5. If the enquiry is marked as valid (“New”), sends a confirmation email to the guest using Gmail; otherwise it skips the auto-reply. Setup 1. Create a Google Sheet with columns matching the workflow fields (for example: reference, receivedat, statu

- **Domain**: `n8n-workflow-21224.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/21224
- Page (HTML): https://agenstry.com/agents/n8n-workflow-21224.n8n.io
- Documentation: https://n8n.io/workflows/21224
