n8n Competitor Price Tracking: Apify + Postgres + Slack

Automated competitor price tracking—scraped daily, analyzed with SQL, and summarized in Slack

This 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 Slack.

What this workflow does

• Scrapes competitor URLs every morning: it reads your list of competitor product URLs and sends them to the Apify E-commerce Scraping Tool. There’s no custom scraper to maintain—Apify handles anti-bot, proxies, and per-retailer extraction.
• Normalizes pricing consistently: a normalization step reduces per-retailer differences to a single shape. Prices are parsed without assuming a locale (e.g., 1.299,99 and $1,299.99 both read correctly). Currency is stored as an ISO code, and stock tracks three states so “not reported” isn’t treated the same as “out of stock.”
• Builds a daily history in Postgres: the workflow inserts one row per product per day into Postgres (or Supabase).
• Detects unusual moves (not noise): SQL views compare today against the trailing 30-day average and the 90-day low. It reports transitions rather than ongoing states—so a competitor who cuts a price and holds it is reported once, and the workflow stays silent for the first 14 days to establish a baseline.
• Posts to Slack with recommendations and health signals: 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.

Use cases

• SaaS operators managing pricing competitiveness across multiple e-commerce retailers
• Automation engineers building an always-on competitor price tracking pipeline in n8n
• Teams using Slack for daily alerts on meaningful price changes and scraping reliability

Technical details

• n8n + Apify community node (Apify community node): on n8n Cloud, enable verified community nodes; self-hosted install @apifyn8n-nodes-apify.
• Nodes used: code, slack, postgres, sticky note, @apifyn8n-nodes-apify, and @n8n-nodes-langchainagent.