Track Flight Fares with Amadeus & Skyscanner - Alerts, Refunds & Trends

Description

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
Import the workflow into n8n
Configure API credentials for Amadeus and Skyscanner
Run the workflow
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:** - booking_id, passenger_name, email, phone, flight_number, departure_date, origin, destination, airline, booking_class, original_fare, booking_date, confirmation_code, tracking_enabled, last_checked, current_lowest_fare, trend.
Update Fare Tracking Columns:** - booking_id, check_date, lowest_fare, fare_source, savings_amount, savings_percentage, fare_trend, priority_level, action_recommended, refund_eligible, available_fares_json, updated_at.
Update Booking Status: Columns** - last_checked, current_lowest_fare, booking_id.

DB Setup:

Create tables 'bookings' and 'fare_tracking' with above columns, set 'booking_id' as primary key, and ensure proper indexing for performance.
Run queries after configuring DB connection in n8n with appropriate credentials.

Parameters to Configure
amadeus_api_key**: Amadeus API key
skyscanner_api_key**: Skyscanner API key
email_recipients**: List of email addresses for alerts
sms_recipients**: List of phone numbers for SMS alerts
slack_channel**: Slack channel for team notifications
refund_threshold**: Minimum fare drop for refund eligibility