Travel itinerary reminders with Google Calendar, Excel, and SMS/Email alerts
Needs changesWhat this workflow does
This workflow has 15 nodes and runs on a schedule (legacy Cron node). Along the way it connects Microsoft Excel 365 and Google Calendar.
How it runs
Trigger: On a schedule (legacy Cron node).
- Read Travel Itinerary (Microsoft Excel 365): uses Microsoft Excel 365
- Filter Today's Trips (Code): runs custom JavaScript code
- Has Trips Today? (If): checks a condition and branches into true / false
- Sync to Google Calendar (Google Calendar): uses Google Calendar
- Read Traveler Contacts (Microsoft Excel 365): uses Microsoft Excel 365
- Create Traveler Reminders (Code): runs custom JavaScript code
- Wait: waits 15 seconds
- Split Into Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Email or SMS? (If): checks a condition and branches into true / false
- Prepare Email Reminders (Code): runs custom JavaScript code
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Daily Travel Check: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Daily Travel Check | Schedule Trigger |
Nodes used (7)
- Cron
n8n-nodes-base.cron - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Calendar
n8n-nodes-base.googleCalendar - Wait
n8n-nodes-base.wait
From the author
This automated n8n workflow checks daily travel itineraries, syncs upcoming trips to Google Calendar, and sends reminder notifications to travelers via email or SMS. Perfect for travel agencies, tour operators, and organizations managing group trips to keep…