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

by Oneclick AI Squad ✓ · 1,206 views · created 2025-07-21 · Market Research

What this workflow does

This workflow has 15 nodes and runs on a schedule (every 6 hours). Along the way it connects Postgres. It also calls api.amadeus.com, api.sendgrid.com and api.slack.com over HTTP.

How it runs

Trigger: On a schedule (every 6 hours).

1. Get Tracked Bookings (Postgres): run a query
2. Prepare Fare Search (Code): runs custom JavaScript code
3. Search Current Fares (HTTP Request): calls api.amadeus.com
4. Search Skyscanner Fares (HTTP Request): calls an HTTP API
5. Analyze Fare Drops (Code): runs custom JavaScript code
6. Update Fare Tracking (Postgres): run a query
7. Update Booking Status (Postgres): run a query
8. Check if Notification Needed (If): checks a condition and branches into true / false
9. Send Fare Drop Email (HTTP Request): calls api.sendgrid.com
10. Check if SMS Needed (If): checks a condition and branches into true / false

…plus 4 more steps. See the full node list below.

Services it uses

Postgres

HTTP calls to: api.amadeus.com, api.sendgrid.com, api.slack.com, api.airline-booking-system.com

Before you upgrade to n8n 3.0

Nodes used (5)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Postgresn8n-nodes-base.postgres
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Ifn8n-nodes-base.if

From the author

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.…

View the original on n8n.io → Check your own copy