Templates / Send weekly SEO and competitor intelligence reports with SEMrush, GA4, OpenAI, Gmail and Slack

Send weekly SEO and competitor intelligence reports with SEMrush, GA4, OpenAI, Gmail and Slack

Needs changes

by Redowan Ahmed Farhan ✓ · 24 views · created 2026-07-28 · 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 12 nodes and runs on a schedule (every week at 07:00) (plus 1 other trigger). Along the way it connects OpenAI Chat Model, Gmail and Slack. It also calls api.semrush.com and analyticsdata.googleapis.com over HTTP.

How it runs

Trigger: On a schedule (every week at 07:00) (plus 1 other trigger).

Fetch SEMrush Rankings (HTTP Request): calls api.semrush.com
Fetch GA4 Traffic (HTTP Request): calls analyticsdata.googleapis.com (POST)
Scrape Competitor Pages (HTTP Request): calls an HTTP API
Notify Ops (Slack): uses Slack
Combine Intelligence (Merge): merges the data from its input branches
Compute Movers & Anomalies (Code): runs custom JavaScript code
Summarize Movers (AI Agent) (AI Agent): runs an AI agent, with model: OpenAI Chat Model
Email Report (Gmail): uses Gmail
Post to Slack (Slack): uses Slack

Services it uses

OpenAI Chat Model Gmail Slack

HTTP calls to: api.semrush.com, analyticsdata.googleapis.com

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 Summarize Movers (AI Agent) (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.0	Replace with
AI Agent v1 (old agent modes) Summarize Movers (AI Agent) (v1.7)	Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (9)

Schedule Triggern8n-nodes-base.scheduleTrigger
HTTP Requestn8n-nodes-base.httpRequest
Mergen8n-nodes-base.merge
Coden8n-nodes-base.code
AI Agent@n8n/n8n-nodes-langchain.agent
OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
Gmailn8n-nodes-base.gmail
Slackn8n-nodes-base.slack
Error Triggern8n-nodes-base.errorTrigger

From the author

Quick overview This workflow runs every Monday at 7am to pull SEO rankings from SEMrush, traffic metrics from Google Analytics 4, and HTML from a competitor page, then uses an OpenAI chat model to write a short weekly intelligence summary and delivers it via…
Excerpt from Redowan Ahmed Farhan's description on n8n.io.

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

Send weekly SEO and competitor intelligence reports with SEMrush, GA4, OpenAI, Gmail and Slack

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (9)

From the author

Get the weekly “what broke” email