Automated Travel Agency Operations & Marketing Pipeline
The Challenge
A high-volume travel agency (*Khamba Travel and Tours*) struggled with manual workflows in posting weekly flight promos to social media, monitoring dates to send departure reminders, and driving organic audience engagement.
Technical Stack
The Solution: Serverless Marketing & Notification Hub
I architected a serverless automation pipeline that runs daily to monitor bookings, dynamically construct visual content, publish directly to social networks, and dispatch smart notifications.
Promo Sheet Sync
Fetches airfare data directly from Google Sheets, generating custom 1080x1080 social media flyers using Vercel dynamic JPEG edge rendering.
AI Content Generation
Integrates Google Gemini API to write custom copy, select unsplash backgrounds matching the vibes of a trivia/holiday theme, and write quotes.
departure reminders
Scans DB records and drafts personalized flight emails using Nodemailer SMTP, keeping client check-ins fully automated and consistent.
cron Orchestration
Designed daily schedules using GitHub Actions triggers. Uses Supabase to log posted dates and prevent duplicate content uploads.
The Impact
- Time Efficiency: Reduced manual content planning and publishing efforts by 90%, freeing team capacity.
- Audience Growth: Increased organic impressions and customer interactions with automated, high-end visual holiday greetings and trivia cards.
- Customer Support: Reached 100% notification completion for travel clients, decreasing departure check-in support issues.