Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Web Scraping & Research

Web Scraping & Research

Track competitor hotel rates with MrScraper, Gemini, Google Sheets and Telegram

Scrapes competitor hotel rates on Booking.com and tiket.com daily at 15:00, logs them to Google Sheets and sends one Telegram report.

What it does

## Hotel competitor rate monitor with MrScraper, Gemini and Telegram Sign up for MrScraper HERE Node docs: docs.mrscraper.com This template checks competitor hotel rates on Booking.com and tiket.com every day. It saves every rate in Google Sheets and sends one Telegram report. It also reads the top listings from a Booking.com search page for the same city. ### Who's it for Hotel, guesthouse and villa managers who want to track competitor prices without opening booking sites every day. ### How it works 1. At 15:00, Build Requests creates 1 URL per listing for the next 2 weekends (4 stay dates). 2. Booking.com pages go to MrScraper Extract Booking (Extract Structured Data, hotel category), 1 page per batch. 3. tiket.com pages go to MrScraper Fetch Markdown (Fetch Rendered HTML), 5 pages per batch. Gemini Extract Rooms reads room names and prices from the markdown. 4. Merge Rates joins both paths. All rows go to Rate_History and Current_Status. 5. Each rate is compared with history. An alert needs a price change of 5% or more that repeats in 2 scans in a row. 6. MrScraper Listing Agent reads the Booking.com search page and saves the top 5 listings to Area_Scan. 7. Gemini Write Report writes the summary and Send Telegram Report sends 1 message. If Gemini fails, the message uses a fixed format. ### How to set up 1. Self-hosted n8n: install the community node n8n-nodes-mrscraper (Settings > Community nodes). 2. Add credentials: MrScraper, Google Sheets OAuth2, Google Gemini (PaLM) API, Telegram. 3. Make a copy of the sheet template (4 tabs, 2 sample listings). Paste its ID in the 5 Google Sheets nodes. 4. Replace the 2 sample rows in the Listings tab with your competitors. 5. Send a message to your bot, open https://api.telegram.org/bot /getUpdates, and copy message.chat.id into Send Telegram Report. Details: Telegram setup note. 6. Run once manually, then activate the workflow. ### Requirements - MrScraper account. The Free plan allows 10 parallel requests. - Gemini API key. 1 run uses up to 3 Gemini requests. - Telegram bot token from @BotFather (/newbot). ### Customize - Platforms and stay dates: EXTRACTION_PATH, WEEKEND_COUNT in Build Requests - Alert threshold: ALERT_THRESHOLD_PCT in Normalize Booking Rates and Normalize Markdown Rates - Area scan city and check-in offset: AREA_CITY, DAY_OFFSET in Build Area Scan URL - Report language: the report is in Indone

The steps

  1. Gemini Write Report
  2. Schedule: Daily 15:00 (Watchlist + Area Scan)
  3. Get Listings
  4. Build Requests
  5. Loop Booking Pages
  6. Send Telegram Report
  7. MrScraper Extract Booking
  8. Normalize Booking Rates
  9. MrScraper Listing Agent
  10. Build Area Scan URL
  11. Loop Area Listings
  12. MrScraper Extract Listing
  13. Normalize Area Listing
  14. Append Area_Scan

32 steps in total.

Similar automations