Automated Hotel Price Drop Alerts with Email Notifications and Database Tracking

Description

This n8n workflow automatically tracks hotel room prices, detects price drops, and sends real-time email alerts with savings calculations. It continuously monitors multiple hotels and room types to help travelers, businesses, and agents secure the best rates.

Key Features

Automatically checks hotel prices every 6 hours
Monitors multiple hotels and room categories
Detects and alerts when prices drop
Compares old vs new pricing and highlights savings
Sends beautiful HTML email alerts
Logs price history for long-term insights
Shows availability changes and urgency indicators

Price Drop Triggers

Alerts are sent when:

Price decreases by any amount
Price drops by a certain percentage (configurable)
Room becomes available again after being sold out

Email Alert Includes

| Field | Details |
| --------------------- | ------------------------------- |
| Hotel Name & Location | ✅ |
| Room Type & Plan | ✅ |
| Old Price | Shown with strikethrough |
| New Price | Highlighted for visibility |
| Savings Amount | ₹ / $ value difference |
| Savings % | Percentage change |
| Booking Link | Direct hotel booking / OTA link |
| Urgency Badge | Shows limited-time availability |

Workflow Logic

Schedule Trigger
Runs every 6 hours (configurable)
Fetch Hotel Price API
Calls hotel booking / OTA / aggregator API
Compare With Stored Price
Retrieves previous price from database/storage
Detect Price Drop & Availability Change
Save Latest Price
Updates price history record
Send Email Alert
Sends formatted HTML email with price drop details
Log Notification
Maintains complete log of events

Setup Requirements

| Step | Action |
| ---- | ------------------------------------------- |
| 1 | Schedule Trigger (cron: every 6 hours) |
| 2 | Add Hotel API / scraping source credentials |
| 3 | Set up database or Google Sheet for storage |
| 4 | Configure SMTP for emails |
| 5 | Enter agent / user email address |
| 6 | Populate hotel & room watchlist |
| 7 | Test and verify price comparison logic |

Best Use Cases

Travel agencies
Corporate travel teams
Personal trip planning
Hotel revenue analysts
Price intelligence dashboards

Extension Ideas

WhatsApp and Telegram alerts
Push notifications to mobile apps
Google Sheets dashboard
Slack alerts for teams
Price trend charts (Grafana / Google Charts)
Integration with GPT for smart recommendations