Send Walmart and Target stock and price-drop alerts from Google Sheets to Slack using Scrapio
UnknownWhat this workflow does
This workflow has 19 nodes and runs on a schedule (every hour) (plus 1 other trigger). Along the way it connects Google Sheets, Slack and Scrapio (community).
How it runs
Trigger: On a schedule (every hour) (plus 1 other trigger).
- Read Watchlist (Google Sheets): read
- Read Stock History (Google Sheets): read
- Route by Retailer (Switch): routes items into 2 branches
- Filter: keeps only the items that match a condition
- Get Walmart Product (Scrapio): get product (walmart)
- Get Target Product (Scrapio): get product (target)
- Aggregate: combines items into one
- Merge: merges the data from its input branches
- Build Weekly Summary (Edit Fields (Set)): sets 4 fields: total, restocks, priceDrops…
- Check Stock and Price (Code): runs custom JavaScript code
…plus 7 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
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-scrapio is verified or supports 3.0 (used in Get Walmart Product, Get Target Product).
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Switch
n8n-nodes-base.switch - Scrapio
n8n-nodes-scrapio.scrapio - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Filter
n8n-nodes-base.filter - Aggregate
n8n-nodes-base.aggregate - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick Overview This workflow checks a Google Sheets watchlist of Walmart and Target products every hour via Scrapio, posts Slack alerts when items restock or drop in price, logs each check to a history sheet, and sends a weekly Slack digest summarizing the…