Automate Weekly SEO Reports from Google Search Console to Email

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_URL in 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