Track competitor prices, promos, and stock with MrScraper, Gemini, and Slack

Description

Quick overview This workflow tracks competitor product prices, promos, and stock using MrScraper, logs results to Google Sheets, generates short insights with Google Gemini, and posts Slack alerts only when significant changes occur, running daily on a schedule or on demand via a webhook. How it works Runs daily on a schedule or starts via a POST webhook request and normalizes the input to choose a tracking mode (sheets watchlist, a listing page, or a SERP query). In watchlist mode, reads SKUs from Google Sheets (Watchlist) and the prior run data (History), then scrapes each competitor product page with MrScraper. Compares the scraped competitor price, promo, and stock status to your price and the most recent History entry, appends the new result to the History sheet, and flags meaningful changes. When a change triggers an alert, Google Gemini writes a short recommendation and the workflow posts a detailed Slack alert for that SKU. In listing/SERP mode, uses MrScraper to collect multiple offers (from a category page or from Google results followed by product page scraping), compares each offer to your price, and appends results to the Market History sheet. If any market offers cross the alert rules, Google Gemini summarizes the market position and the workflow posts a single Slack “Market Price Check” summary; webhook runs also return the final results as JSON. Setup Create credentials for MrScraper, Google Sheets OAuth2, Google Gemini (PaLM) API, and Slack (access token). Create a Google Sheet with tabs named Watchlist, History, and Market History, and add Watchlist columns for sku, product_name, my_price, currency, competitor_url, and threshold_pct. Paste your Google Sheet ID and Slack channel ID into the workflow’s Setup values. If using the webhook mode, copy the production webhook URL from n8n and send POST requests to /webhook/competitor-tracker with a valid body (source: sheets, listing, or serp plus the required fields). An n8n automation workflow template by Muhammad Firaz Al Aqib.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• slack
• code
• google-gemini

Capabilities

• 4 nodes

Information