Automated Hotel Price Drop Alerts with Email Notifications and Database Tracking

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