Competitor price monitoring with web scraping,Google Sheets & Telegram

How it works

++Download the google sheet here++ and replace this with the googles sheet node: [Google sheet](https://www.dropbox.com/scl/fi/zaif45nt9uzgz8mrhht9n/competitorpricedropautomation.xlsx?rlkey=4vj3wz6gqp16dc2hh9hw5o49z&st=i23h513p&dl=1) , upload to google sheets and replace in the google sheets node.

- Scheduled trigger: Runs once a day at 8 AM (server time).

- Fetch product list: Reads your “master” sheet (producturl + last known price) from Google Sheets.

- Loop with delay: Iterates over each row (product) one at a time, inserting a short pause (20 s) between HTTP requests to avoid blocking.

- Scrape current price: Loads each producturl, extracts the current price via a simple CSS selector.

- Compare & normalize: Compares the newly scraped price against the “lastprice” from your sheet, calculates percentage change, and tags items where pricechanged == true.

On price change: - Send alert: Formats a Telegram message (“Price Drop” or “Price Hike”) and pushes it to your configured chat.