📊 Automated hotel price drop alerts with email notifications and database tracking
⚡ 217 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
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
🔗 Nodes Used
Send Email, HTTP Request, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File