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

by Lee Lin · 779 views · created 2025-12-29 · Market Research, AI RAG

What this workflow does

This AI workflow has 39 nodes and runs on a schedule (cron 0 0 9 * * *) (plus 1 other trigger). Along the way it connects Data table, WhatsApp Business Cloud and OpenAI Chat Model. It also calls test.api.amadeus.com over HTTP.

How it runs

Trigger: On a schedule (cron 0 0 9 * * *) (plus 1 other trigger).

1. Config (Edit Fields (Set)): sets 7 fields: currency, adults, roomQuantity…
2. Filter Text Messages (If): checks a condition and branches into true / false
3. Amadeus OAuth (HTTP Request): calls test.api.amadeus.com (POST)
4. Normalize Whatsapp Input (Edit Fields (Set)): sets 1 field: chatInput
5. Generate 30 night windows (Code): runs custom JavaScript code
6. Get Alert Summary (Data table): get
7. Combine 30-Day Rates (Merge): merges the data from its input branches
8. Amadeus Hotel Offers (HTTP Request): calls test.api.amadeus.com
9. AI Agent: runs an AI agent, with model: OpenAI Chat Model; 1 tool (Get Hotel_Rates_History); memory: Simple Memory
10. Clean Amadeus Data (Code): runs custom JavaScript code

…plus 22 more steps. See the full node list below.

Services it uses

Data tableWhatsApp Business CloudOpenAI Chat Model

HTTP calls to: test.api.amadeus.com

Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).

Before you upgrade to n8n 3.0

Nodes used (15)

• Edit Fields (Set)n8n-nodes-base.set
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Ifn8n-nodes-base.if
• Data tablen8n-nodes-base.dataTable
• Mergen8n-nodes-base.merge
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Data Table Tooln8n-nodes-base.dataTableTool
• WhatsApp Triggern8n-nodes-base.whatsAppTrigger
• WhatsApp Business Cloudn8n-nodes-base.whatsApp
• AI Agent@n8n/n8n-nodes-langchain.agent
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Simple Memory@n8n/n8n-nodes-langchain.memoryBufferWindow
• Schedule Triggern8n-nodes-base.scheduleTrigger
• HTMLn8n-nodes-base.html

From the author

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. -…

View the original on n8n.io → Check your own copy