AI Travel Booking Assistant with Trip Reminders
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.

On this page
How it works
- A customer chats with the AI agent, which reads available packages from the sheet.
- The agent creates, looks up or reschedules bookings and records trip details.
- Every morning upcoming trips are checked and the days remaining are calculated.
- 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
What you need
This workflow connects to these apps.
- n8n
- OpenAI
- Google Sheets
You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.
- Google Sheets account
- OpenAI account
- Twilio account
Data setup
Create these tables with these exact column names before the first run.
| Table | Columns |
|---|---|
| Travel & Tour Agency → PackagesGoogle Sheets | Destination |
| Travel & Tour Agency → BookingsGoogle Sheets | BookingIDCustomerNamePhonePackageTravelDateAmountPaymentStatusBookingStatus |
| Travel & Tour Agency → TripsGoogle Sheets | BookingIDNamePhoneDepartureDateReminder7Reminder1 |
Setup
- Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
- Connect the credentials listed above.
- Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
- Replace placeholder emails, phone numbers, and form links with your own.
- Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.
Nodes
| Node | Type |
|---|---|
| When chat message received | chatTrigger |
| OpenAI Chat Model | lmChatOpenAi |
| Simple Memory | memoryBufferWindow |
| Get Packages Details | googleSheetsTool |
| Get Exist Booking | googleSheetsTool |
| Append Booking | googleSheetsTool |
| Reschedule Booking | googleSheetsTool |
| Tour & Travel AI Agent | agent |
| Append Trip Details | googleSheetsTool |
| Fetch Upcoming Trips (+1 & +7 Days) | googleSheets |
| Daily Reminder Cron (9AM) | scheduleTrigger |
| Calculate Days Left | code |
| Route: 1-Day vs 7-Day Reminder | switch |
| Send 7-Day Reminder (WhatsApp) | twilio |
| Send 1-Day Reminder + Tickets | twilio |
| Mark Reminder7 Sent | googleSheets |
| Mark Reminder1 Sent | googleSheets |
Frequently asked questions
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. It's a 19-node n8n workflow.
An n8n instance, on n8n Cloud or self-hosted, and credentials for Google Sheets, OpenAI, and Twilio. It uses only nodes that ship with n8n, so there's nothing else to install.
It works with 3 tables in Google Sheets. Create them with the column names listed under Data setup on this page before the first run.
Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.
Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.



