Multi-Platform Hotel Price Comparison & Email Reporter - n8n Workflow

Travel agencies or concierge services needing rapid, comparative price data.
Data analysts looking for advanced examples of data aggregation within an n8n workflow.
Automation specialists seeking complex n8n templates combining NLP, API calls, and email formatting.
Users of n8n who want to automate manual price checking tasks.

Manually checking hotel prices across three or more major booking platforms—Booking.com, Agoda, and Expedia—is time-consuming and inefficient. This solution eliminates that manual labor by providing a robust, automated comparison engine built entirely within n8n.

This specific n8n workflow acts as an intelligent backend assistant. It starts with an n8n trigger (a webhook) that accepts natural language queries (e.g., 'Marriott Hotel in Dubai from 20th December to 23rd December'). The core strength of this n8n automation lies in its custom scripting, which extracts necessary parameters (hotel, dates, city) and then executes parallel HTTP requests to external scraping services. Finally, it aggregates the data, finds the best deal, and generates a beautiful, actionable HTML report, delivered directly via email. It also logs every successful query to Google Sheets for analytics, ensuring comprehensive tracking of every use of this powerful n8n node structure.

The process begins when an external system sends a POST request to the Webhook - Receive Request n8n trigger.

1. Request Parsing and Validation: The request data flows into a Parse & Validate Request n8n node (a Code node). This node uses custom JavaScript to perform sophisticated natural language processing (NLP), extracting the hotel name, city, check-in/out dates, and the user's email. If essential information is missing, the n8n workflow responds immediately with a request for more detail.


2. Conditional Routing: The Check If Ready If n8n node ensures that the flow only proceeds to the costly scraping steps if all parameters are successfully extracted (status is 'ready').


3. Parallel Scraping: If ready, the n8n workflow executes three parallel HTTP Request n8n node instances (Scrape Booking.com, Scrape Agoda, Scrape Expedia). These nodes send the standardized parameters (hotel name, city, ISO dates) to dedicated, external scraping APIs. The use of continueOnFail: true ensures the n8n workflow gathers as much data as possible, even if one platform fails.


4. Aggregation and Comparison: The Aggregate & Compare Code n8n node collects the responses from all three scraping nodes. It calculates the best price, average price, and potential savings, structuring the results for reporting.


5. Email Report Generation: The Format Email Report Code n8n node dynamically generates a high-quality, responsive HTML email template detailing the comparison table and highlighting the 'Best Deal Found' using the processed data.


6. Reporting and Logging: The flow splits: one path uses the Send Email Report n8n node to deliver the comparison report to the user’s email via SMTP. The second path captures key metrics in the Log Analytics n8n node and appends them to a designated Google Sheets document using the Google Sheets n8n node, creating a permanent audit trail.


7. Final Response: The n8n workflow concludes by sending a success message back to the initiating webhook caller via the Webhook Response (Success) n8n node.

To deploy this powerful n8n workflow template, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON data and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Setup Credentials:

1. Configure Webhook Trigger: The Webhook - Receive Request n8n trigger is configured with the path hotel-price-check. Activate the n8n workflow to generate the unique testing URL, which you will use to connect your frontend application or chatbot.


2. External Scraper APIs: Note that the HTTP Request n8n node instances (Booking, Agoda, Expedia) target placeholder URLs (https://api.example.com/scrape/...). You must replace these URLs with endpoints pointing to your actual scraping infrastructure or commercial API provider. This is a critical step for the n8n workflow to function correctly.

Webhook - Receive Request (n8n trigger): The entry point of this n8n workflow, configured to listen for POST requests at the /hotel-price-check path, making it ideal for integration with chatbots or external services.
Parse & Validate Request (Code n8n node): Highly customized node containing NLP logic to extract hotel name, city, and date ranges from complex user text. It validates required fields before proceeding to the expensive scraping actions.
Scrape Booking.com, Agoda, Expedia (HTTP Request n8n node): Three parallel nodes responsible for calling external scraping services using the extracted parameters. They are set to continueOnFail: true to maximize results even if one endpoint is down.
Aggregate & Compare (Code n8n node): This crucial n8n node aggregates the results from the parallel HTTP requests, calculates the average and best price, and prepares the structured data payload for the report.
Format Email Report (Code n8n node): Generates a professional, branded HTML email template, ensuring the price comparison data is visually appealing for the end user.
Send Email Report (Email Send n8n node): Sends the generated HTML report to the user's extracted email address using configured SMTP credentials.

• Save to Google Sheets (Google Sheets n8n node): Automatically logs the search query, best deal, and user details, providing valuable analytics data for tracking the performance of the n8n workflow.