Monitor competitor prices with Google Shopping and Google Sheets, alert via Slack and Gmail

Description

Who is this for?

E-commerce store owners, product managers, marketplace sellers, and pricing analysts who want to automatically track competitor pricing and get actionable alerts when their products are overpriced or underpriced relative to the market.

What this workflow does

This workflow runs daily to compare your product prices against live competitor prices from Google Shopping. It identifies pricing gaps, calculates suggested prices that protect your margins, sends instant Slack alerts for critical issues, logs everything to a historical price tracking sheet, and delivers a comprehensive daily summary via Slack and email.

How it works

Daily trigger fires on a configurable schedule (default: every 24 hours).
Reads your product catalog from a Google Sheet — auto-detects column names regardless of naming convention.
Searches Google Shopping for each product using SearchAPI to find real-time competitor prices.
Analyzes the pricing gap — compares your price to the market average and classifies each product as UNDERPRICED, SLIGHTLY_UNDER, COMPETITIVE, SLIGHTLY_OVER, or OVERPRICED.
Suggests optimal prices based on market averages while maintaining a minimum margin above your cost.
Sends instant Slack alerts when a product hits critical or warning thresholds.
Logs all results to a price_log tab in your Google Sheet for trend analysis.
Sends a daily summary via Slack message and HTML email with a full breakdown of all products.

Setup steps

Create a Google Sheet with a products tab containing columns: product_name, my_price (required), and optionally sku, my_cost.
Add a second tab called price_log with headers: date, product_name, sku, my_price, my_cost, margin_now, competitor_lowest, competitor_average, competitor_highest, competitor_count, gap_pct, signal, suggested_price, action.
Get a SearchAPI key from searchapi.io and set it as the n8n environment variable SEARCHAPI_KEY.
Connect Google Sheets OAuth2 credentials and update the sheet ID in both Sheets nodes.
Connect Slack OAuth2 credentials and configure your alert channel.
Connect Gmail OAuth2 credentials and update the recipient email address.

Requirements

n8n instance (self-hosted or cloud)
SearchAPI.io account and API key
Google Cloud project with Sheets API enabled
Slack workspace with a bot configured
Gmail account with OAuth2 credentials

How to customize

Pricing thresholds** — Adjust the 0.85, 0.95, 1.05, 1.15 multipliers in the "Analyze Pricing Gap" node to change sensitivity.
Minimum margin** — Change the 1.15 cost multiplier to set your floor margin (default: 15%).
Schedule** — Modify the trigger interval for more or less frequent checks.
Notifications** — Replace or add Slack/email with Telegram, Discord, Microsoft Teams, or webhooks.
Region** — Change the gl parameter in the search node from us to your target market country code.