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
- Gemini Write Report
- Schedule: Daily 15:00 (Watchlist + Area Scan)
- Get Listings
- Build Requests
- Loop Booking Pages
- Send Telegram Report
- MrScraper Extract Booking
- Normalize Booking Rates
- MrScraper Listing Agent
- Build Area Scan URL
- Loop Area Listings
- MrScraper Extract Listing
- Normalize Area Listing
- Append Area_Scan
32 steps in total.
Similar automations
Web Scraping & ResearchTrack competitor prices, promos, and stock with MrScraper, Gemini, and Slack43 stepsRAG & Knowledge BasesAnalyze Hotel Review Sentiment with Hugging Face RAG10 stepsMonitoring, Ops & IncidentsHourly Bitcoin and Ethereum Rates to Sheets and Telegram7 stepsEmail AutomationSend Hotel Reward Emails to High Spenders with Gemini8 steps