Library / Web Scraping & Research
Web Scraping & Research
Track weekly UK grocery EAN prices with Apify, Google Sheets and Gmail alerts
Once a week, prices a fixed EAN list at Tesco, Sainsbury's, Asda and Aldi via Apify, logs the history to Google Sheets, and emails you items that moved past your threshold.
What it does
## Weekly EAN price monitor Prices a fixed list of EANs at Tesco, Sainsbury's, Asda and Aldi once a week, adds the prices to a Google Sheet as history, compares them with the previous week and alerts you only about items that moved by more than your threshold. Prices come from the Actor's weekly snapshot (live is off). The index is rebuilt on Sundays, so a Monday run reads fresh data. Set up: fill in Settings, add the three credentials (Header Auth for Apify, Google Sheets, Gmail), give the sheet its header row (see the README), run once by hand to record the baseline, then activate. Cost: EANs x retailers x $0.002 per week at most (only matched lines are charged), plus your own Apify Standby compute. Example: 20 EANs at 4 retailers is at most $0.16 a week. Slack: swap either Gmail node for a Slack Send a message node. The movers text is $json.text; a problem has $json.reason and $json.action. Failures elsewhere: set an Error Workflow in the workflow settings.
The steps
- Every Monday 08:00
- Settings
- Build basket request
- Valid basket?
- Price the basket
- Check the answer
- Answer ok?
- Flatten prices
- Read history
- Compare with last week
- Week not recorded yet?
- Split rows to append
- Append this week
- Anything moved?
16 steps in total.
Similar automations
Web Scraping & ResearchSend daily Reddit keyword mention alerts from Apify to Slack and Gmail8 stepsMonitoring, Ops & IncidentsTrack weekly AI search brand visibility with Apify and Google Sheets11 stepsWeb Scraping & ResearchScrape TikTok Shop bestsellers with Apify and format daily stock alerts6 stepsMonitoring, Ops & IncidentsAudit weekly PageSpeed scores with Apify, Google Sheets, and Slack7 steps