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.