Compare hotel prices across booking platforms with Scrape.do and Google Sheets

🏨 Hotel Price Comparison Workflow with Scrape.do This template requires a self-hosted n8n instance to run. A complete n8n automation that extracts hotel prices from multiple booking platforms (Booking.com, Hotels.com, Expedia, etc.) using Scrape.do API, compares prices across platforms, and saves structured results into Google Sheets for price monitoring and decision-making. 📋 Overview This workflow provides an automated hotel price comparison solution that monitors hotel rates across different booking platforms for specific destinations and dates. Ideal for travel agencies, price comparison websites, travelers, and hospitality analysts who need real-time pricing insights without manual searching. Who is this for? - Travel agencies automating price comparisons - Price comparison website operators - Budget-conscious travelers tracking best deals - Hospitality analysts monitoring market pricing - Hotel managers tracking competitor rates - Travel bloggers researching accommodation options What problem does this workflow solve? - Eliminates manual price checking across multiple sites - Processes multiple hotels and date ranges automatically - Extracts structured pricing data (price, rating, amenities) - Identifies the cheapest option across platforms - Automates saving results into Google Sheets - Ensures consistent and repeatable price monitoring ⚙️ What this workflow does 1. Manual Trigger → Starts the workflow manually or on schedule 2. Get Search Parameters from Sheet → Reads hotel names, destinations, check-in/check-out dates from Google Sheet 3. URL Encode Parameters → Converts search parameters into URL-safe format 4. Process Hotels in Batches → Handles multiple searches sequentially to avoid rate limits 5. Fetch Hotel Data from Multiple Platforms → Calls Scrape.do API to retrieve pricing from Booking.com, Hotels.com, and Expedia 6. Extract and Structure Price Data → Parses HTML into structured hotel data (name, price, rating, amenities) 7. Compare Prices Across Platforms → Identifies best price and calculates savings 8. Append Results to Sheet → Writes comparison results into Google Sheet 📊 Output Data Points | Field | Description | Example | |-------|-------------|---------| | Hotel Name | Name of the hotel | Hilton Garden Inn Downtown | | Destination | City or location | New York, NY | | Check-in Date | Arrival date | 2025-12-15 | | Check-out Date | Departure date | 2025-12-18 | | Nights | Number of nights | 3 | | Booking.com Price | Price from Booking.com | $450 | | Hotels.com Price | Price from Hotels.com | $425 | | Expedia Price | Price from Expedia | $440 | | Best Price | Lowest price found | $425 | | Best Platform | Platform with lowest price | Hotels.com | | Savings | Difference from highest price | $25 | | Average Rating | Average customer rating | 8.5/10 | | Total Reviews | Number of reviews | 1,247 | | Free Cancellation | Cancellation policy | Yes | | Breakfast Included | Breakfast availability | No | ⚙️ Setup Prerequisites - n8n instance (self-hosted) - Google account with Sheets access - Scrape.do account with API token Google Sheet Structure This workflow uses one Google Sheet with two tabs: Input Tab: "Search Parameters" | Column | Type | Description | Example | |--------|------|-------------|---------| | Hotel Name | Text | Name of hotel (optional) | Hilton Garden Inn | | Destination | Text | City or location | New York, NY | | Check-in Date | Date | Arrival date (YYYY-MM-DD) | 2025-12-15 | | Check-out Date | Date | Departure date (YYYY-MM-DD) | 2025-12-18 | | Guests | Number | Number of guests | 2 | | Rooms | Number | Number of rooms | 1 | Output Tab: "Price Comparison" | Column | Type | Description | Example | |--------|------|-------------|---------| | Search Date | Timestamp | When search was performed | 2025-11-17 10:30:00 | | Hotel Name | Text | Name of the hotel | Hilton Garden Inn Downtown | | Destination | Text | City/location | New York, NY | | Check-in | Date | Arrival date | 2025-12-15 | | Ch