Automate weekly SEO reports from Google Search Console to email
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Cron, Function (legacy). 2 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| 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
What it does
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 your email inbox every Monday morning. Ideal for: - Website owners - Bloggers - SEO consultants who want to track site performance over time without manual reporting. --- Setup steps 1. Replace YOURSITEURL in the HTTP Request node with your verified domain from Google Search Console. 2. Connect your Google OAuth2 credentials to the HTTP Request node. 3. Set up your SMTP credentials in the "Send Email" node. 4. Adjust the recipient email address and subject line if necessary. 5. (Optional) Customize the Function node to include more queries or format the report as a PDF. Estimated setup time: ~10 minutes Sticky notes are included in the workflow canvas to guide you step-by-step. --- Technologies used - Google Search Console API - SMTP Email Node - n8n Function Node - n8n HTTP Request Node - n8n Sticky Notes