📊 Automate weekly SEO reports from Google Search Console to email
⚡ 4,433 views · 📊 Market Research & Insights
Description
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
- Replace
YOUR_SITE_URLin the HTTP Request node with your verified domain from Google Search Console. - Connect your Google OAuth2 credentials to the HTTP Request node.
- Set up your SMTP credentials in the “Send Email” node.
- Adjust the recipient email address and subject line if necessary.
- (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
🔗 Nodes Used
Cron, Function, HTTP Request, Gmail
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File