n8n Competitor Price Tracker: OpenAI, Sheets, Slack & Notion

Track competitor prices automatically—daily—using Google Sheets, OpenAI, Slack & Notion

This n8n workflow monitors competitor product URLs from your Google Sheets, extracts price and stock status with OpenAI, and sends Slack alerts (including a “manual check” path for low confidence). When a meaningful price drop is detected, it logs the event in Notion and updates the latest prices back in your sheet.

What this workflow does

• Runs daily on a schedule.
• Loads configuration and pulls competitor rows from a Google Sheet (e.g., productName, competitorUrl, ourPrice/lastKnownPrice, and checkedAt).
• Fetches each competitor page via HTTP requests with retries; on fetch failures, it posts an error alert to Slack and continues processing.
• Converts fetched HTML to plain text and sends the content to OpenAI to extract:
  • price
  • stock status
  • confidence level
• Routes low-confidence results to a Slack “manual check” alert; otherwise compares the extracted price to the last known price and detects drops beyond your configured threshold.
• For significant drops: sends a Slack alert, creates a Notion database entry, then writes the latest checked time and new last-known price back to Google Sheets.
• Posts a daily Slack summary with counts of checked items, detected drops, fetch errors, and low-confidence extractions.

Use cases

• SaaS operators tracking competitive pricing across multiple SKUs without manual checking
• Automation engineers setting up an n8n competitor price tracker with Slack notifications and Notion logging
• Teams validating promotions by capturing price drops and recording them for review

Technical details

• Integrations: Google Sheets, OpenAI, Slack, Notion
• n8n nodes used (as implemented): if, code, slack, notion, sticky note, http request
• Key setup: configure your Sheet/document ID and tab, and ensure columns like productName, competitorUrl, ourPrice, lastKnownPrice, and checkedAt exist.