Competitor hotel rates — explained, with answers in chat

Every day the scenario collects neighbouring hotels' rates a month ahead, warns you about meaningful moves in the context of city events, and answers questions about rate history in your messenger.

  • Competitor rates 30 days ahead
  • Alerts only when the move matters
  • Takes city events into account
  • Rate-history questions answered in chat
Data table ToolWhatsAppAmadeus
Set it upScriptera

How it works

To connect Data table Tool and WhatsApp, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: WhatsApp Trigger
  2. Check: Filter Text Messages
  3. If yes: Normalize Whatsapp Input
  4. Then: Get Alert Summary
  5. Then: AI Agent: Q&A
  6. Then: Q&A
  7. Then: Config
  8. Then: Amadeus OAuth
  9. Then: Generate 30 night windows
  10. Check: Combine 30-Day Rates
  11. Then: Clean Amadeus Data
  12. Then: New Snapshot
  13. Check: Combine New Rates vs Prev Rates
  14. Then: Upsert Latest Rates
  15. Then: Compute Change
  16. Check: Significant Competitor Change
  17. If yes: Get Our Hotel Rates
  18. Then: Prefix Our Hotel Fields
  19. Check: Combine Competitor Rates vs Our Rates
  20. Then: Build VCC URLs
  21. Then: Fetch VCC Month HTML
  22. Then: Extract Event Details
  23. Then: Events Extract
  24. Check: Combine Rates & Events
  25. Then: Prepare AI Agent Input
  26. Then: AI Agent: Analyze
  27. Then: Send WhatsApp Alert
  28. Check: Combine Summary & Alert
  29. Then: Upsert Hotel Price Alerts
  30. Then: Insert History Rates
  31. Then: Get Prev Rates
  32. Then: Prev Snapshot
  33. Then: Amadeus Hotel Offers
  34. Then: Structured Output Parser
  35. Then: Get Hotel_Rates_History
  36. Then: OpenAI Chat Model2
  37. Then: Simple Memory
  38. Then: OpenAI Chat Model
  39. Starts when: Daily Market Check

You can launch this Data table Tool + WhatsApp integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios