Templates / Monitor competitor prices and send OpenAI analysis alerts via Slack and Gmail

Monitor competitor prices and send OpenAI analysis alerts via Slack and Gmail

Needs changes

by Yurie Ino ✓ · 124 views · created 2025-12-16 · Market Research, AI Summarization

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 24 nodes and runs on a schedule (cron 0 */6 * * *). Along the way it connects Google Sheets, OpenAI Chat Model, Slack and Gmail.

How it runs

Trigger: On a schedule (cron 0 */6 * * *).

  1. Initialize Monitoring Session (Edit Fields (Set)): sets 3 fields: monitoringId, checkTimestamp, competitors
  2. Fetch Current Prices (HTTP Request): calls an HTTP API
  3. Fetch Previous Prices (Google Sheets): get many
  4. Normalize Current Prices (Code): runs custom JavaScript code
  5. Normalize Previous Prices (Code): runs custom JavaScript code
  6. Compare Price Datasets (Compare Datasets): uses Compare Datasets
  7. Process Removed Products (Code): runs custom JavaScript code
  8. Process Unchanged (Code): runs custom JavaScript code
  9. Process Changed Prices (Code): runs custom JavaScript code
  10. Process New Products (Code): runs custom JavaScript code

…plus 12 more steps. See the full node list below.

Services it uses

Google SheetsOpenAI Chat ModelSlackGmail

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • AI Agent v1 (old agent modes) in AI Price Analyst (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).

Removed in 3.0Replace with
AI Agent v1 (old agent modes)
AI Price Analyst (v1.7)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (13)

From the author

Competitor Price Monitoring with AI-Powered Alerts What this workflow does This workflow automatically monitors competitor product prices on a scheduled basis, detects meaningful price changes, and delivers actionable alerts enriched with AI-powered…

Excerpt from Yurie Ino's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.