Competitor price monitoring with web scraping,Google Sheets & Telegram
Ready for 3.0What this workflow does
This workflow has 15 nodes and runs on a schedule (every day at 08:00). Along the way it connects Google Sheets and Telegram.
How it runs
Trigger: On a schedule (every day at 08:00).
- Fetch Product List from Sheet (Google Sheets): uses Google Sheets
- Process Each Product in Batches of (Loop Over Items (Split in Batches)): loops over the items in batches
- Pause Between Requests (Wait): waits 20 seconds
- Load Product Page HTML (HTTP Request): calls an HTTP API
- Extract Current Price from HTML (HTML): parses or builds HTML
- Normalize Price Values (Code): runs custom JavaScript code
- Compute Price Change (Code): runs custom JavaScript code
- Clean Up Parsed Fields (Code): runs custom JavaScript code
- Is Price Changed? (If): checks a condition and branches into true / false
- Build Telegram Alert Message (Code): runs custom JavaScript code
…plus 4 more steps. See the full node list below.
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - HTML
n8n-nodes-base.html - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Telegram
n8n-nodes-base.telegram
From the author
How it works ++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…