Live Flight Fare Tracker with Aviation Stack API – Gmail & Telegram Alerts

This n8n workflow continuously monitors flight fares by querying the Aviation Stack API (with support for Amadeus and Skyscanner) every 6 hours via a schedule trigger. It fetches current fares for tracked routes stored in an internal database, compares them to original booking prices, and detects drops based on absolute and percentage savings. Updated fares are logged in a fare_tracking table for historical analysis, enabling trend insights and refund eligibility checks.

Key benefits include instant notifications for price fluctuations post-booking, improving cost recovery opportunities. Users receive prioritized alerts: email for medium/high drops, SMS (via Twilio) for savings >$100 or >15%, and Slack for internal rebooking suggestions. All activities are logged in fare_alert_logs for auditing.

Ideal use cases: Travel agencies tracking client bookings, frequent flyers monitoring routes, or businesses optimizing corporate travel expenses. Easily extendable for airline-specific rules or multi-route monitoring, saving hours of manual checking and maximizing savings.