{"product_id":"n8n-competitor-price-tracking-apify-postgres-slack","title":"n8n Competitor Price Tracking: Apify + Postgres + Slack","description":"\u003ch3\u003eAutomated competitor price tracking—scraped daily, analyzed with SQL, and summarized in Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every morning to scrape competitor product pages with Apify, stores daily price snapshots in Postgres\/Supabase, detects unusual price moves with SQL views, and posts clear, actionable repricing commentary (plus scraping health warnings) to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes competitor URLs every morning\u003c\/strong\u003e: it reads your list of competitor product URLs and sends them to the \u003cstrong\u003eApify E-commerce Scraping Tool\u003c\/strong\u003e. There’s no custom scraper to maintain—Apify handles anti-bot, proxies, and per-retailer extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes pricing consistently\u003c\/strong\u003e: a normalization step reduces per-retailer differences to a single shape. Prices are parsed without assuming a locale (e.g., \u003cem\u003e1.299,99\u003c\/em\u003e and \u003cem\u003e$1,299.99\u003c\/em\u003e both read correctly). Currency is stored as an \u003cstrong\u003eISO code\u003c\/strong\u003e, and stock tracks three states so “not reported” isn’t treated the same as “out of stock.”\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a daily history in Postgres\u003c\/strong\u003e: the workflow inserts \u003cstrong\u003eone row per product per day\u003c\/strong\u003e into Postgres (or Supabase).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects unusual moves (not noise)\u003c\/strong\u003e: SQL views compare today against the trailing \u003cstrong\u003e30-day average\u003c\/strong\u003e and the \u003cstrong\u003e90-day low\u003c\/strong\u003e. It reports \u003cstrong\u003etransitions\u003c\/strong\u003e rather than ongoing states—so a competitor who cuts a price and holds it is reported once, and the workflow stays silent for the \u003cstrong\u003efirst 14 days\u003c\/strong\u003e to establish a baseline.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts to Slack with recommendations and health signals\u003c\/strong\u003e: an AI agent turns detected moves into repricing guidance and posts it to Slack. A second branch reports when URLs return nothing, preventing broken pages from appearing as “quiet” markets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators managing pricing competitiveness across multiple e-commerce retailers\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an always-on competitor price tracking pipeline in n8n\u003c\/li\u003e\n  \u003cli\u003eTeams using Slack for daily alerts on meaningful price changes and scraping reliability\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n + Apify community node\u003c\/strong\u003e (Apify community node): on n8n Cloud, enable verified community nodes; self-hosted install \u003ccode\u003e@apifyn8n-nodes-apify\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used\u003c\/strong\u003e: \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e, \u003ccode\u003epostgres\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003e@apifyn8n-nodes-apify\u003c\/code\u003e, and \u003ccode\u003e@n8n-nodes-langchainagent\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46066359828659,"sku":"N8N-19750","price":46.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/lDcJsIzPRsoNrO7Eqf0b_Rmwe0NWZ.png?v=1789895025","url":"https:\/\/buyflowscripts.com\/products\/n8n-competitor-price-tracking-apify-postgres-slack","provider":"N8N Commerce","version":"1.0","type":"link"}