# AI Travel Booking Assistant with Trip Reminders

**Category:** Travel  
**Tools:** n8n, OpenAI, Google Sheets  
**Nodes:** 19  
**Built by:** Forgent Systems

A chat-based travel agent that shows packages, takes and reschedules bookings, and stores everything in Google Sheets. Travellers then get WhatsApp reminders 7 days and 1 day before departure.

![Workflow](preview.webp)

## How it works

1. A customer chats with the AI agent, which reads available packages from the sheet.
2. The agent creates, looks up or reschedules bookings and records trip details.
3. Every morning upcoming trips are checked and the days remaining are calculated.
4. 7-day and 1-day WhatsApp reminders are sent and flagged so they never repeat.

## Use cases

- Tour operators and travel agencies
- Holiday package sellers
- Event and pilgrimage travel organizers

## Data setup

**Google Sheets** (tab: columns)

- **Travel & Tour Agency → Packages**: `Destination`
- **Travel & Tour Agency → Bookings**: `BookingID`, `CustomerName`, `Phone`, `Package`, `TravelDate`, `Amount`, `PaymentStatus`, `BookingStatus`
- **Travel & Tour Agency → Trips**: `BookingID`, `Name`, `Phone`, `DepartureDate`, `Reminder7`, `Reminder1`

## 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

- **When chat message received** — `@n8n/n8n-nodes-langchain.chatTrigger`
- **OpenAI Chat Model** — `@n8n/n8n-nodes-langchain.lmChatOpenAi`
- **Simple Memory** — `@n8n/n8n-nodes-langchain.memoryBufferWindow`
- **Get Packages Details** — `n8n-nodes-base.googleSheetsTool`
- **Get Exist Booking** — `n8n-nodes-base.googleSheetsTool`
- **Append Booking** — `n8n-nodes-base.googleSheetsTool`
- **Reschedule Booking** — `n8n-nodes-base.googleSheetsTool`
- **Tour & Travel AI Agent** — `@n8n/n8n-nodes-langchain.agent`
- **Append Trip Details** — `n8n-nodes-base.googleSheetsTool`
- **Fetch Upcoming Trips (+1 & +7 Days)** — `n8n-nodes-base.googleSheets`
- **Daily Reminder Cron (9AM)** — `n8n-nodes-base.scheduleTrigger`
- **Calculate Days Left** — `n8n-nodes-base.code`
- **Route: 1-Day vs 7-Day Reminder** — `n8n-nodes-base.switch`
- **Send 7-Day Reminder (WhatsApp)** — `n8n-nodes-base.twilio`
- **Send 1-Day Reminder + Tickets** — `n8n-nodes-base.twilio`
- **Mark Reminder7 Sent** — `n8n-nodes-base.googleSheets`
- **Mark Reminder1 Sent** — `n8n-nodes-base.googleSheets`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Sticky Note1** — `n8n-nodes-base.stickyNote`
