# Hotel Reservation WhatsApp Agent

**Category:** Hospitality  
**Tools:** OpenAI, Google Sheets, Google Calendar  
**Nodes:** 17  
**Built by:** Forgent Systems

Guests book, reschedule or cancel hotel rooms and ask questions on WhatsApp. The agent checks room availability, updates Google Sheets and Google Calendar, and confirms instantly.

![Workflow](preview.webp)

## How it works

1. A guest messages the hotel on WhatsApp.
2. The AI agent checks available rooms and FAQs.
3. It creates, reschedules or cancels the reservation in the sheet and the calendar.
4. The room status is updated and a confirmation is sent.

## Use cases

- Hotels and boutique stays
- Homestays and villas
- Resorts

## Data setup

**Google Sheets** (tab: columns)

- **Reservation Management(Hospitality) → FAQ**: _(columns as used in the nodes)_
- **Reservation Management(Hospitality) → Reservations**: `BookingID`, `CheckInDate`, `CheckInTime`, `CheckOutDate`, `TotalAmount`, `Status`, `RescheduleAt`, `CheckOutStatus`, `EventID`, `RoomID`, `RoomNumber`, `RoomType`, `GuestName`, `GuestEmail`, `GuestPhone`, `Adults`, `Children`, `CreatedAt`
- **Reservation Management(Hospitality) → Rooms**: `RoomID`, `Status`, `Capacity`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Gmail account
   - Google Calendar account
   - Google Sheets account
   - OpenAI account
   - Twilio account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Simple Memory** — `@n8n/n8n-nodes-langchain.memoryBufferWindow`
- **Get FAQ** — `n8n-nodes-base.googleSheetsTool`
- **Reschedule Reservation** — `n8n-nodes-base.googleSheetsTool`
- **Cancel Reservation** — `n8n-nodes-base.googleSheetsTool`
- **Update Room Status** — `n8n-nodes-base.googleSheetsTool`
- **Reservation Management** — `@n8n/n8n-nodes-langchain.agent`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Twilio Trigger** — `n8n-nodes-base.twilioTrigger`
- **Send an SMS/MMS/WhatsApp message** — `n8n-nodes-base.twilio`
- **Reschedule Event** — `n8n-nodes-base.googleCalendarTool`
- **Cancel Event** — `n8n-nodes-base.googleCalendarTool`
- **Reservation Confirm Message** — `n8n-nodes-base.gmailTool`
- **Get Reservation Details** — `n8n-nodes-base.googleSheetsTool`
- **Append Reservation Details** — `n8n-nodes-base.googleSheetsTool`
- **Get Available Rooms Details** — `n8n-nodes-base.googleSheetsTool`
- **Create Event** — `n8n-nodes-base.googleCalendarTool`
- **OpenAI Chat Model** — `@n8n/n8n-nodes-langchain.lmChatOpenAi`
