# Hostel Booking WhatsApp AI Agent

**Category:** Hospitality  
**Tools:** n8n, OpenAI, Google Sheets  
**Nodes:** 9  
**Built by:** Forgent Systems

A WhatsApp assistant for hostel and co-living owners. It answers inquiries, checks room availability, and creates, updates or cancels bookings in Google Sheets.

![Workflow](preview.webp)

## How it works

1. A guest messages the WhatsApp number.
2. The AI agent checks existing bookings and room availability in the sheet.
3. It creates, changes or deletes the booking as requested.
4. The reply is sent back on WhatsApp, with conversation memory per guest.

## Use cases

- Hostel owners
- Co-living operators
- Small guesthouses and B&Bs

## Data setup

**Google Sheets** (tab: columns)

- **Hostel Data Sheet → Sheet1**: `booking_id`, `name`, `phone number`, `id_proof_number`, `check_in_date`, `check_out_date`, `people_count`, `total_days`, `room_number`, `rent_amount`, `payment_status`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - 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

- **Twilio Trigger** — `n8n-nodes-base.twilioTrigger`
- **AI Agent** — `@n8n/n8n-nodes-langchain.agent`
- **OpenAI Chat Model** — `@n8n/n8n-nodes-langchain.lmChatOpenAi`
- **Send an SMS/MMS/WhatsApp message** — `n8n-nodes-base.twilio`
- **Simple Memory** — `@n8n/n8n-nodes-langchain.memoryBufferWindow`
- **Fetch Hostel Bookings** — `n8n-nodes-base.googleSheetsTool`
- **Create Hostel Booking** — `n8n-nodes-base.googleSheetsTool`
- **Update Hostel Booking** — `n8n-nodes-base.googleSheetsTool`
- **Delete Hostel Booking** — `n8n-nodes-base.googleSheetsTool`
