Automate weekly SEO reports from Google Search Console to email
Needs changesWhat this workflow does
This workflow has 4 nodes and runs on a schedule (legacy Cron node). Along the way it connects Gmail. It also calls searchconsole.googleapis.com over HTTP.
How it runs
Trigger: On a schedule (legacy Cron node).
- Get SEO Data from GSC (HTTP Request): calls searchconsole.googleapis.com
- Generate SEO Report (Function): runs custom JavaScript (legacy Function node)
- Send Weekly Report by Email (Gmail): uses Gmail
Services it uses
HTTP calls to: searchconsole.googleapis.com
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Cron in Weekly Trigger (Monday 7AM): replace with Schedule Trigger.
- Function (legacy) in Generate SEO Report: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Weekly Trigger (Monday 7AM) | Schedule Trigger |
| Function (legacy) Generate SEO Report | Code node, mode 'Run Once for All Items' |
Nodes used (4)
- Cron
n8n-nodes-base.cron - HTTP Request
n8n-nodes-base.httpRequest - Function
n8n-nodes-base.function - Gmail
n8n-nodes-base.gmail
From the author
What this workflow does This n8n workflow connects to Google Search Console to fetch SEO performance data (clicks, impressions, CTR, and average position) for the last 7 days. It formats the results into a clean weekly summary and automatically sends it to…