n8n Competitor Pricing & News Tracker in Google Sheets

Track competitor pricing and product messaging automatically—then get a weekly brief in Gmail + Slack

This n8n Competitor Pricing & News Tracker in Google Sheets monitors competitor web pages and industry news every week. It detects real changes (like pricing updates and messaging shifts), uses Google Gemini to rate what matters, logs everything in Google Sheets, and sends a short actionable summary via Gmail and Slack.

What this workflow does

• Runs every Monday at 8 AM (customizable schedule).
• Reads competitor pages + last week’s snapshots from your Google Sheet, skipping rows marked inactive.
• Fetches each page, converts the HTML to clean text, and compares it line-by-line against the previous snapshot.
• Prevents false alarms: if a fetch fails, the last known good copy is kept—so outages don’t create “changes.”
• Logs updates in Google Sheets (Snapshots + Change Log), saving status, timestamps, and page content.
• Reduces noise with Gemini: only changed lines go to Google Gemini, which labels and explains significance for your business.
• Tracks competitor headlines for the last 7 days using Google News RSS (no API key required), then Gemini drafts a weekly brief.
• Sends the weekly brief as an HTML email via Gmail and posts a summary to Slack.

Use cases

• SaaS founders watching pricing and packaging changes across key competitors.
• Marketing teams monitoring messaging updates and positioning shifts.
• Sales leaders identifying threats/opportunities before deals are impacted.
• Automation engineers building a reliable competitor monitoring system with clear Google Sheets reporting.

Technical details

• Google Sheets tabs: Competitors, Snapshots, Change Log (with the specified header rows).
• Scheduling: runs weekly (Monday at 8 AM, configurable).
• Nodes / building blocks used: if, set, code, gmail, merge, slack.