Track flight fares with Amadeus & Skyscanner - alerts, refunds & trends

This automated n8n workflow tracks booked flight fares post-purchase using Amadeus and Skyscanner APIs to detect drops for refund or credit opportunities. It streamlines fare monitoring, updates booking statuses, and notifies users via SMS or email. Fundamental Aspects - Fare Check Trigger - Initiates the workflow - Get Tracked Bookings - Retrieves existing booking data - Prepare Fare Query - Prepares query parameters - Search Current Fares - Queries Skyscanner for current fares - Analyze Fare Drops - Identifies significant fare reductions - Update Fare Tracking - Updates fare tracking records - Update Booking Status - Updates status based on fare changes - Check if Notification Needed - Determines if alerts are required - Send Fare Drop Email - Notifies users via email - Notify Slack Team - Alerts the team via Slack - Check Refund Eligible - Assesses refund eligibility - Initiate Refund Process - Starts refund procedure if eligible - Check if SMS Needed - Decides if SMS alert is necessary - Send SMS Alert - Sends SMS notification Setup Instructions 1. Import the workflow into n8n 2. Configure API credentials for Amadeus and Skyscanner 3. Run the workflow 4. Verify notifications and refund processes Features - Fare Monitoring - Tracks and compares fares using Amadeus and Skyscanner - Alert System - Sends email and SMS notifications for fare drops - Refund Management - Checks and initiates refund processes - Trend Analysis - Analyzes fare trends for strategic decisions DB Queries - Get Tracked Bookings Columns: - bookingid, passengername, email, phone, flightnumber, departuredate, origin, destination, airline, bookingclass, originalfare, bookingdate, confirmationcode, trackingenabled, lastchecked, currentlowestfare, trend. - Update Fare Tracking Columns: - bookingid, checkdate, lowestfare, faresource, savingsamount, savingspercentage, faretrend, prioritylevel, actionrecommended, refundeligible, availablefaresjson, updatedat. - Update Booking Status: Columns - lastchecked, currentlowestfare, bookingid. DB Setup: - Create tables 'bookings' and 'faretracking' with above columns, set 'bookingid' as primary key, and ensure proper indexing for performance. - Run queries after configuring DB connection in n8n with appropriate credentials. Parameters to Configure - amadeusapikey: Amadeus API key - skyscannerapikey: Skyscanner API key - emailrecipients: List of email addresses for alerts - smsrecipients: List of phone numbers for SMS alerts - slackchannel: Slack channel for team notifications - refundthreshold: Minimum fare drop for refund eligibility