Skip to main content

Monitor hotel competitor rates and answer WhatsApp Q&A using OpenAI GPT-4.1

Workflow preview

Workflow preview
100%
Monitor hotel competitor rates and answer WhatsApp Q&A using OpenAI GPT-4.1 preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

How It Works Top Branch Workflow A 1. The Market Intelligence: Patrols the Market: Runs hourly to scrape competitor rates for future days. Gathers Intel: If prices spike, it instantly checks event ...

Best for

  • Market Research automation workflows
  • AI RAG automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.set, n8n-nodes-base.code, n8n-nodes-base.httprequest, n8n-nodes-base.if, n8n-nodes-base.datatable, n8n-nodes-base.merge, @n8n/n8n-nodes-langchain.outputparserstructured, n8n-nodes-base.datatabletool

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Lee Lin.

Original n8n.io source

1.1 Workflow description

Title
Monitor hotel competitor rates and answer WhatsApp Q&A using OpenAI GPT-4.1
Workflow name
Monitor hotel competitor rates and answer WhatsApp Q&A using OpenAI GPT-4.1

How It Works

Top Branch Workflow A

1. The Market Intelligence:

  • Patrols the Market: Runs hourly to scrape competitor rates for future days.
  • Gathers Intel: If prices spike, it instantly checks event announcements to see if a major event is driving demand.
  • Crunches Numbers: Calculates the exact price gap and filters out noise.

2. The Revenue Manager:

  • Sets Strategy: The AI Agent reviews the price gaps, competitor moves, and event signals.
  • Reports: Writes a strategic Executive Summary and sends it to your WhatsApp.

Bottom Branch Workflow B

3. The Consultant:

  • Recall: When you ask a question via WhatsApp, the bot retrieves the saved analysis, historical rates, and event schedule.
  • Answer: It acts as an on-demand analyst, conducting further analysis to give an informed answer to questions

Setup Steps

1. Config: Add your hotel + competitor hotels (IDs/names) in the Config node.

2. Monitor Window: Set how far ahead you want to monitor (e.g., daysAhead = 30) in the Config node.

3. Sensitivity: Set how sensitive alerts should be (e.g., alert only if competitor moves > 10%) in the Significant Competitor Change node.

4. Connect Credentials:

  • Amadeus (to fetch hotel prices)
  • WhatsApp (to send alerts)
  • Postgres/SQL (to store price snapshots, history, summary)
  • OpenAI (for the AI Agents)

5. Event Source: Update the Fetch VCC nodes to scrape your local convention center or event site.

6. Run a test:

Trigger Workflow A manually and confirm you receive a WhatsApp alert.

Reply to that WhatsApp message to test Workflow B (Q&A).

Use Cases & Benefits

For Revenue Managers: Automate the "rate shop" routine and catch competitor moves without opening a spreadsheet.

For Sales & Marketing Teams: Go beyond raw data. Pairing "what changed" with "why changed" instantly.

For Hotel Leadership: Perfect for GMs and division leaders who need instant, decision-ready alerts via WhatsApp.

⚔ Zero-Touch Efficiency: Eliminates hours of manual searching by automating rate checks 3x daily. 🧠 Contextual Intelligence: Tracks price AND explains why it moved by cross-referencing local events. šŸ¤– Actionable Strategy: AI doesn't just report numbers; it recommends specific pricing tactics. šŸ“‰ Long-Term Vision: Builds a permanent database of rate history, enabling the AI to answer complex trend questions over time.

šŸ“¬ Want to Customize This?

[email protected]

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Config

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 2 - Generate 30 night windows

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 3 - Amadeus OAuth

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 4 - Amadeus Hotel Offers

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 5 - Prev Snapshot

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 6 - New Snapshot

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 7 - Compute Change

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 8 - Significant Competitor Change

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.3

Block 9 - Get Our Hotel Rates

Type / Role
n8n-nodes-base.dataTable - dataTable
Config choices
Version 1

Block 10 - Prefix Our Hotel Fields

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 11 - Build VCC URLs

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 12 - Fetch VCC Month HTML

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 13 - Events Extract

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 14 - Combine 30-Day Rates

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3.2

Block 15 - Get Prev Rates

Type / Role
n8n-nodes-base.dataTable - dataTable
Config choices
Version 1

Block 16 - Upsert Latest Rates

Type / Role
n8n-nodes-base.dataTable - dataTable
Config choices
Version 1

Block 17 - Insert History Rates

Type / Role
n8n-nodes-base.dataTable - dataTable
Config choices
Version 1

Block 18 - Combine New Rates vs Prev Rates

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3.2

Block 19 - Combine Competitor Rates vs Our Rates

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3.2

Block 20 - Structured Output Parser

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Block 21 - Normalize Whatsapp Input

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 22 - Prepare AI Agent Input

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 23 - Get Hotel_Rates_History

Type / Role
n8n-nodes-base.dataTableTool - dataTableTool
Config choices
Version 1

Block 24 - WhatsApp Trigger

Type / Role
n8n-nodes-base.whatsAppTrigger - whatsAppTrigger
Config choices
Version 1

Showing the first 24 of 48 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Monitor hotel competitor rates and answer WhatsApp Q&A using OpenAI GPT-4.1
Complexity advanced
Nodes 48
Categories Market Research, AI RAG
Author Lee Lin
Published 29 Dec 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/12246/12246.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Monitor hotel competitor rates and answer WhatsApp Q&A using OpenAI GPT-4.1 do?

How It Works Top Branch Workflow A 1. The Market Intelligence: Patrols the Market: Runs hourly to scrape competitor rates for future days. Gathers Intel: If prices spike, it instantly checks event ...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, AI RAG use case.