Skip to content
NEWMarketplace and your team: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Every Monday 08:00
  2. Settings
  3. Build basket request
  4. Valid basket?
  5. Price the basket
  6. Check the answer
  7. Answer ok?
  8. Flatten prices
  9. Read history
  10. Compare with last week
  11. Week not recorded yet?
  12. Split rows to append
  13. Append this week
  14. Anything moved?

16 steps in total.

Similar automations