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
