Travel itinerary reminders with Google Calendar, Excel, and SMS/Email alerts

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 travelers informed about their schedules and bookings.

What This Workflow Does

Automatically checks travel itineraries every day Identifies today's trips and upcoming departures Syncs trip information to Google Calendar Sends personalized reminders to assigned travelers Tracks reminder delivery status and logs activities Handles both email and SMS notification preferences Provides pre-travel checklists and booking confirmations Manages multi-day trip schedules and activities

Main Components

Daily Travel Check - Triggers daily to check travel itineraries Read Travel Itinerary - Retrieves today's trips and bookings from database/Excel Filter Today's Trips - Identifies trips departing today and upcoming activities Has Trips Today? - Checks if there are any trips scheduled Read Traveler Contacts - Gets traveler contact information for assigned trips Sync to Google Calendar - Creates/updates trip events in Google Calendar Create Traveler Reminders - Generates personalized reminder messages with travel details Split Into Batches - Processes reminders in manageable batches Email or SMS? - Routes based on traveler communication preferences Prepare Email Reminders - Creates detailed email reminder content with checklists Prepare SMS Reminders - Creates SMS reminder content optimized for text Read Reminder Log - Checks previous reminder history Update Reminder Log - Records sent reminders with timestamps Save Reminder Log - Saves updated log data for audit trail

Essential Prerequisites

Travel itinerary database/Excel file with trip assignments Traveler contact database with email and phone numbers Google Calendar API access and credentials SMTP server for email notifications SMS service provider (Twilio, Nexmo, etc.) for text reminders Reminder log file for tracking sent notifications Booking confirmation system (flight, hotel, transport)

Required Data Files