++Download the google sheet here++ and replace this with the googles sheet node: Google sheet , 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 (product_url + 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 product_url, extracts the current price via a simple CSS selector.
Compare & normalize: Compares the newly scraped price against the “last_price” from your sheet, calculates percentage change, and tags items where price_changed == true.
On price change:
Send alert: Formats a Telegram message (“Price Drop” or “Price Hike”) and pushes it to your configured chat.
Log history: Appends a new row to a separate “price_tracking” tab with timestamp, old price, new price, and % change.
Update master sheet: After a 1 min pause, writes the updated current_price back to your “master” sheet so future runs use it as the new baseline.
Verify the schedule in the Schedule Trigger node is set to 08:00 (or adjust to your preferred run time).
In the Loop Over Items node, confirm “Batch Size” is 1 (to process one URL at a time).
Adjust the Delay to avoid Request Blocking node if your site requires a longer pause (default is 20 s).
In the Parse Data From The HTML Page node, double-check the CSS selector matches how prices appear on your target site.
Once credentials are in place and your sheet tabs match the expected column names, the flow should be ready to activate. Total setup time is under 15 minutes—detailed notes are embedded as sticky comments throughout the workflow to help you tweak selectors, change timeouts, or adjust sheet names without digging into code.