Weekly Competitor Intelligence with n8n, Sheets, Gmail & Gemini

Stay ahead of competitor changes—automatically

This n8n workflow monitors competitor websites and news every week, detects meaningful updates, and turns them into a clear competitor intelligence brief. Changes are logged in Google Sheets, and the final report is emailed via Gmail and summarized in Slack—so you don’t waste hours chasing updates.

What this workflow does

• Runs weekly (default Monday at 8 AM) using a schedule trigger (you can switch to daily).
• Reads your competitor page list from Google Sheets and skips any rows marked as inactive.
• Fetches each competitor page over HTTP, converts the HTML into clean readable text, and compares it line-by-line against last week’s snapshot to identify added and removed content.
• Preserves stability during outages: if a page can’t be fetched, the last good snapshot is kept so outages aren’t misreported as changes.
• Uses Google Gemini to judge significance: for changed pages, it sends only the added/removed lines for Gemini to rate impact, label change type, and explain why it matters to your business—reducing noise.
• Logs everything in Google Sheets: latest snapshots are saved to the Snapshots tab, and real updates are recorded in the Change Log tab.
• Pulls competitor headlines from Google News RSS for the last 7 days (no API key required).
• Merges results into one research pack and asks Gemini to generate a weekly brief with top moves, threats, opportunities, and recommended actions—then delivers it as an HTML email via Gmail and a short update to Slack.

Use cases

• Weekly competitive monitoring for SaaS operators tracking pricing, product, and messaging shifts.
• Automation engineers maintaining a reliable competitor intelligence pipeline in n8n.
• Teams who need shareable updates sent via email and Slack without manual research.

Technical details

• n8n workflow logic: if, set, code
• Data delivery & collaboration: Gmail, Slack
• Research assembly: merge

Ideal for anyone building an SEO-driven competitor intelligence automation with n8n, Google Sheets, Gmail, and Gemini.