Hotel Price Comparison Automation
Send a natural language hotel request via webhook to get parallel price comparisons from multiple platforms delivered as an HTML email...
What it does
You simply describe your hotel needs in natural language via a webhook, and you instantly receive an HTML email comparing prices across multiple booking platforms with the best deals highlighted. The system automatically gathers these results, manages any errors, and logs your search analytics to Google Sheets for future reference.
Step by step
- Configure an n8n webhook node to accept POST requests with a JSON body containing the user's query.
- Set up parallel HTTP request nodes for each booking platform, mapping the LLM-extracted search parameters (dates, location) into the respective API endpoints or scrape URLs.
- Create a code node using JavaScript to parse the raw HTML/JSON responses, normalize currency values, and identify the lowest price entry across all sources.
- Configure the Google Sheets integration to append a new row with the query timestamp, search terms, best price found, and source URL after each successful run.
Where the LLM does the work
- Use an LLM node to interpret natural language inputs like 'cheap beach hotel in Bali for next weekend' into structured JSON fields including destination, check-in/out dates, and budget constraints.
- Instruct the LLM to handle ambiguous queries by asking clarifying questions or making reasonable assumptions about date ranges if specific days are not mentioned.
- Have the LLM generate a concise, professional summary of the top three deals for inclusion in the email body, highlighting key amenities and price differences.
Watch out for
Booking sites frequently block automated requests due to bot detection mechanisms so you must rotate user-agent headers and add random delays between scrape attempts.
Price data formats vary wildly across platforms which can cause parsing errors in your code node so implement robust try-catch blocks with fallback logic for missing fields.
Email delivery services may flag bulk or automated emails as spam so ensure the HTML template includes proper unsubscribe links and authenticates via SPF/DKIM records.
Tools that fit
HTTP Request API Calling external scraping APIs or services
Send Email Service Delivering formatted price comparison reports
The agent brief
Everything your agent needs, including the gotchas. Copy it and go.
You are helping me build the following AI agent workflow. ## Goal Hotel Price Comparison Automation: Send a natural language hotel request via webhook to get parallel price comparisons from multiple platforms delivered as an HTML email... ## Specification - What it does: You simply describe your hotel needs in natural language via a webhook, and you instantly receive an HTML email comparing prices across multiple booking platforms with the best deals highlighted. The system automatically gathers these results, manages any errors, and logs your search analytics to Google Sheets for future reference. - Trigger: Triggered by an event (Manual · on webhook request) - Autonomy: Fully hands-off - Expected setup effort: a few focused days - Tools/services involved: - n8n: Workflow orchestration and automation logic - LLM: Natural language processing of user queries - HTTP Request: Calling external scraping APIs or services - Send Email: Delivering formatted price comparison reports - Google Sheets: Storing analytics and search history data ## Known pitfalls, handle each one explicitly in your implementation 1. Booking sites frequently block automated requests due to bot detection mechanisms so you must rotate user-agent headers and add random delays between scrape attempts. 2. Price data formats vary wildly across platforms which can cause parsing errors in your code node so implement robust try-catch blocks with fallback logic for missing fields. 3. Email delivery services may flag bulk or automated emails as spam so ensure the HTML template includes proper unsubscribe links and authenticates via SPF/DKIM records. ## Reference implementation https://n8n.io/workflows/9777 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/hotel-price-comparison-automation/ via usecasesforagents.com
Frequently asked questions
Can I use a different Automation Platform than n8n?
Yes. n8n is only the example automation platform in this recipe. The same flow works with Home Assistant. Swap the automation platform connection and keep the rest of the setup as written.
Want this running in your business?
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.
Who it's for
Also fits E-commerce Operator.
Works just as well for personal use, no business context needed.