Track competitor pricing gaps with Google Sheets, ScrapeUnblocker and Gmail
UnknownWhat this workflow does
This workflow has 9 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Gmail and Scrapeunblocker (community).
How it runs
Trigger: On a schedule (every day).
- Get Competitor URL (Google Sheets): uses Google Sheets
- Loop Over Competitor URL (Loop Over Items (Split in Batches)): loops over the items in batches
- Scrape URLS (Scrape Unblocker): uses Scrape Unblocker
- parse data (Code): runs custom JavaScript code
- structured the data (Code): runs custom JavaScript code
- Update data (Google Sheets): update
- undercut=true? (If): checks a condition and branches into true / false
- Send alert (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-scrapeunblocker is verified or supports 3.0 (used in Scrape URLS).
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Scrape Unblocker
n8n-nodes-scrapeunblocker.scrapeUnblocker - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail
From the author
Quick Overview This workflow runs on a schedule to read competitor product URLs and your price from Google Sheets, scrapes each competitor page using ScrapeUnblocker, calculates price differences and stock status, writes results back to the sheet, and sends a…