{"product_id":"uk-grocery-ean-price-tracker-weekly-with-apify-sheets-gmail","title":"UK Grocery EAN Price Tracker (Weekly) with Apify, Sheets \u0026 Gmail","description":"\u003ch3\u003eTrack UK grocery price changes every week—automatically alerting you when EAN prices move\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs weekly to fetch UK supermarket pricing for a fixed list of grocery \u003cstrong\u003eEANs\u003c\/strong\u003e using the \u003cstrong\u003eApify UK Supermarket Price Scraper\u003c\/strong\u003e. It stores weekly history in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, compares against the most recent prior week, and sends a \u003cstrong\u003eGmail\u003c\/strong\u003e alert only when prices change beyond a configurable threshold.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every Monday at 08:00\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a deduplicated basket request\u003c\/strong\u003e from your EAN list (limited to \u003cstrong\u003e200 items\u003c\/strong\u003e), and routes invalid lists to an \u003cstrong\u003eemail problem report\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalls the Apify Actor \u003cstrong\u003eStandby `\/basket`\u003c\/strong\u003e endpoint to retrieve weekly-snapshot prices (optionally including \u003cem\u003eloyalty prices\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the HTTP response and snapshot freshness\u003c\/strong\u003e; if usable pricing data isn’t returned, it emails a plain-English problem report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlattens pricing results\u003c\/strong\u003e into one row per retailer and matched EAN, then reads the full existing price history from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares this week’s effective prices\u003c\/strong\u003e against the latest earlier week for each retailer\/EAN.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends new week rows\u003c\/strong\u003e (only when the week isn’t already recorded) and calculates price-move alerts based on your threshold.\u003c\/li\u003e\n  \u003cli\u003eSends an \u003cstrong\u003eHTML alert email via Gmail\u003c\/strong\u003e when there are significant movers or items no longer priced.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators monitoring competitor pricing for a curated product portfolio.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers collecting weekly UK grocery price history by EAN for reporting.\u003c\/li\u003e\n  \u003cli\u003eTeams tracking volatility and receiving email alerts only when meaningful price movement occurs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes\/types: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003esplit out\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eApify integration: uses an \u003cstrong\u003eApify API token\u003c\/strong\u003e added as HTTP header auth to run Actors.\u003c\/li\u003e\n  \u003cli\u003eData storage: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e weekly price history; comparison vs the most recent prior week.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217910354099,"sku":"N8N-20846","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/S5XUR7W6wtQmAbrS74r-s_owX7moA7.png?v=1791882619","url":"https:\/\/buyflowscripts.com\/products\/uk-grocery-ean-price-tracker-weekly-with-apify-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}