Compare Flight Prices Across Multiple Booking Platforms with Email Reports

Description

This workflow automates flight price comparison across multiple booking platforms (Kayak, Skyscanner, Expedia, Google Flights). It accepts natural language queries, extracts flight details using NLP, scrapes prices in parallel, identifies the best deals, and sends professional email reports with comprehensive price breakdowns and booking links.

📦 What You'll Get

A fully functional, production-ready n8n workflow that:

✅ Compares flight prices across 4 major platforms (Kayak, Skyscanner, Expedia, Google Flights)
✅ Accepts natural language requests ("Flight from NYC to London on March 25")
✅ Sends beautiful email reports with best deals
✅ Returns real-time JSON responses for web apps
✅ Handles errors gracefully with helpful messages
✅ Includes detailed documentation with sticky notes

🚀 Quick Setup (3 Steps)

Step 1: Import Workflow to n8n

Copy the JSON from the first artifact (workflow file)
Open n8n → Go to Workflows
Click "Import from File" → Paste JSON → Click Import
✅ Workflow imported successfully!

Step 2: Setup Python Scraper

On your server (where n8n SSH nodes will connect):

Navigate to your scripts directory
cd /home/oneclick-server2/

Create the scraper file
nano flight_scraper.py

Copy the entire Python script from the second artifact
Save with Ctrl+X, then Y, then Enter

Make it executable
chmod +x flight_scraper.py

Install required packages
pip3 install selenium

Install Chrome and ChromeDriver
sudo apt update
sudo apt install -y chromium-browser chromium-chromedriver

Test the scraper
python3 flight_scraper.py JFK LHR 2025-03-25 2025-03-30 round-trip 1 economy kayak

Expected Output:
Delta|$450|7h 30m|0|10:00 AM|6:30 PM|https://kayak.com/...
British Airways|$485|7h 45m|0|11:30 AM|8:15 PM|https://kayak.com/...
...

Step 3: Configure n8n Credentials

A. Setup SMTP (for sending emails):

In n8n: Credentials → Add Credential → SMTP
Fill in details:
Host: smtp.gmail.com
Port: 587
User: [email protected]
Password: [Your App Password]

For Gmail Users:
Enable 2FA: https://myaccount.google.com/security
Create App Password: https://myaccount.google.com/apppasswords
Use the 16-character password in n8n

B. Setup SSH (already configured if you used existing credentials):

In workflow, SSH nodes use: ilPh8oO4GfSlc0Qy
Verify credential exists and points to correct server
Update path if needed: /home/oneclick-server2/

C. Activate Workflow:

Click the workflow toggle → Active ✅
Webhook is now live!

🎯 How to Use

Method 1: Direct Webhook Call

curl -X POST https://your-n8n-domain.com/webhook/flight-price-compare \
-H "Content-Type: application/json" \
-d '{
"message": "Flight from Mumbai to Dubai on 15th March, round-trip returning 20th March",
"email": "[email protected]",
"name": "John Doe"
}'

Response:
{
"success": true,
"message": "Flight comparison sent to [email protected]",
"route": "BOM → DXB",
"bestPrice": 450,
"airline": "Emirates",
"totalResults": 18
}

Method 2: Natural Language Queries

The workflow understands various formats:

✅ All these work:
"Flight from New York to London on 25th March, one-way"
"NYC to LHR March 25 round-trip return March 30"
"I need a flight from Mumbai to Dubai departing 15th March"
"JFK LHR 2025-03-25 2025-03-30 round-trip"

Supported cities (auto-converts to airport codes):
New York → JFK
London → LHR
Mumbai → BOM
Dubai → DXB
Singapore → SIN
And 20+ more cities

Method 3: Structured JSON

{
"from": "JFK",
"to": "LHR",
"departure_date": "2025-03-25",
"return_date": "2025-03-30",
"trip_type": "round-trip",
"passengers": 1,
"class": "economy",
"email": "[email protected]",
"name": "John"
}

📧 Email Report Example

Users receive an email like this:

FLIGHT PRICE COMPARISON


Route: JFK → LHR
Departure: 25 Mar 2025
Return: 30 Mar 2025
Trip Type: round-trip
Passengers: 1

🏆 BEST DEAL
British Airways
Price: $450
Duration: 7h 30m
Stops: Non-stop
Platform: Kayak

💰 Save $85 vs highest price!

📊 ALL RESULTS (Top 10)
British Airways - $450 (Non-stop) - Kayak
Delta - $475 (Non-stop) - Google Flights
American Airlines - $485 (Non-stop) - Expedia
Virgin Atlantic - $495 (Non-stop) - Skyscanner
United - $520 (1 stop) - Kayak
...

Average Price: $495
Total Results: 23

Prices subject to availability.
Happy travels! ✈️

🔧 Customization Options

Change Scraping Platforms

Add more platforms:

Duplicate an SSH scraping node
Change platform parameter: kayak → new-platform
Add scraping logic in flight_scraper.py
Connect to "Aggregate & Analyze Prices" node

Remove platforms:

Delete unwanted SSH node
Workflow continues with remaining platforms

Modify Email Format

Edit the "Format Email Report" node:

// Change to HTML format
const html = `
<!DOCTYPE html>
<html>
<body>
Flight Deals
Best price: ${bestDeal.currency}${bestDeal.price}
</body>
</html>
`;

return [{
json: {
subject: "...",
html: html, // Instead of text
...data
}
}];

Then update "Send Email Report" node:
Change emailFormat to html
Use {{$json.html}} instead of {{$json.text}}

Add More Cities/Airports

Edit "Parse & Validate Flight Request" node:

const airportCodes = {
...existing codes...,
'berlin': 'BER',
'rome': 'FCO',
'barcelona': 'BCN',
// Add your cities here
};

Change Timeout Settings

In each SSH node, add:

"timeout": 30000 // 30 seconds

🐛 Troubleshooting

Issue: "No flights found"

Possible causes:
Scraper script not working
Website structure changed
Dates in past
Invalid airport codes

Solutions:
Test scraper manually
cd /home/oneclick-server2/
python3 flight_scraper.py JFK LHR 2025-03-25 "" one-way 1 economy kayak

Check if output shows flights
If no output, check Chrome/ChromeDriver installation

Issue: "Connection refused" (SSH)

Solutions:
Verify SSH credentials in n8n
Check server is accessible: ssh user@your-server
Verify path exists: /home/oneclick-server2/
Check Python installed: which python3

Issue: "Email not sending"

Solutions:
Verify SMTP credentials
Check email in spam folder
For Gmail: Confirm App Password is used (not regular password)
Test SMTP connection:
telnet smtp.gmail.com 587
Issue: "Webhook not responding"

Solutions:
Ensure workflow is Active (toggle on)
Check webhook path: /webhook/flight-price-compare
Test with curl command (see "How to Use" section)
Check n8n logs: Settings → Log Streaming

Issue: "Scraper timing out"

Solutions:
In flight_scraper.py, increase wait times
time.sleep(10) # Instead of time.sleep(5)

Or increase WebDriverWait timeout
WebDriverWait(driver, 30) # Instead of 20

📊 Understanding the Workflow

Node-by-Node Explanation

1. Webhook - Receive Flight Request
Entry point for all requests
Accepts POST requests
Path: /webhook/flight-price-compare

2. Parse & Validate Flight Request
Extracts flight details from natural language
Converts city names to airport codes
Validates required fields
Returns helpful errors if data missing

3. Check If Request Valid
Routes to scraping if valid
Routes to error response if invalid

4-7. Scrape [Platform] (4 nodes)
Run in parallel for speed
Each calls Python script with platform parameter
Continue on failure (don't break workflow)
Return pipe-delimited flight data

8. Aggregate & Analyze Prices
Collects all scraper results
Parses flight data
Finds best overall deal
Finds best non-stop flight
Calculates statistics
Sorts by price

9. Format Email Report
Creates readable text report
Includes route details
Highlights best deal
Lists top 10 results
Shows statistics

10. Send Email Report
Sends formatted email to user
Uses SMTP credentials

11. Webhook Response (Success)
Returns JSON response immediately
Includes best price summary
Confirms email sent

12. Webhook Response (Error)
Returns helpful error message
Guides user on what's missing

🎨 Workflow Features

✅ Included Features

Natural Language Processing**: Understands flexible input formats
Multi-Platform Comparison**: 4 major booking sites
Parallel Scraping**: All platforms scraped simultaneously
Error Handling**: Graceful failures, helpful messages
Email Reports**: Professional format with all details
Real-Time Responses**: Instant webhook feedback
Sticky Notes**: Detailed documentation in workflow
Airport Code Mapping**: Auto-converts 20+ cities

🚧 Not Included (Easy to Add)

Price Alerts**: Monitor price drops (add Google Sheets)
Analytics Dashboard**: Track searches (add Google Sheets)
SMS Notifications**: Send via Twilio
Slack Integration**: Post to channels
Database Logging**: Store searches in PostgreSQL
Multi-Currency**: Show prices in the user's currency

💡 Pro Tips

Tip 1: Speed Up Scraping

Use faster scraping service (like ScraperAPI):

// Replace SSH nodes with HTTP Request nodes
{
"url": "http://api.scraperapi.com",
"qs": {
"api_key": "YOUR_KEY",
"url": "https://kayak.com/flights/..."
}
}

Tip 2: Cache Results

Add caching to avoid duplicate scraping:

// In Parse node, check cache first
const cacheKey = ${origin}-${dest}-${departureDate};
const cached = await $cache.get(cacheKey);

if (cached && Date.now() - cached.time < 3600000) {
return cached.data; // Use 1-hour cache
}

Tip 3: Add More Platforms

Easy to add Momondo, CheapOair, etc.:

Add function in flight_scraper.py
Add SSH node in workflow
Connect to aggregator

Tip 4: Improve Date Parsing

Handle more formats:

// Add to Parse node
const formats = [
'DD/MM/YYYY',
'MM-DD-YYYY',
'YYYY.MM.DD',
// Add your formats
];