What This Workflow Does
This n8n workflow automates the process of gathering SEO performance data from Google Search Console and delivering it directly to your email inbox on a weekly basis. It eliminates the manual work of logging into Search Console, exporting data, and compiling reports.
The workflow fetches key metrics including clicks, impressions, click-through rate (CTR), and average position for your tracked pages and queries. It formats this data into an easy-to-read report that gets sent automatically to your designated email address every week.
How It Works
1. Connect to Google Search Console
The workflow authenticates with your Google Search Console account using OAuth to access your site's performance data.
2. Fetch SEO performance data
It retrieves the last 7 days of search performance metrics for your configured properties, including clicks, impressions, CTR, and average position by page and query.
3. Format the data into a report
The raw data gets transformed into a clean, readable format highlighting key trends and changes from the previous week.
4. Send via email
The formatted report gets delivered to your specified email address with a clear subject line indicating it's your weekly SEO performance update.
Who This Is For
This automation is ideal for SEO professionals, marketing teams, and website owners who need to regularly monitor their search performance but want to eliminate the manual work of report generation. It's particularly valuable for:
- SEO agencies managing multiple client accounts
- In-house marketing teams tracking website performance
- E-commerce businesses monitoring product page visibility
- Content creators tracking article performance
What You'll Need
- An n8n instance (self-hosted or cloud)
- Google Search Console access to your website
- An email service configured in n8n (Gmail, SMTP, etc.)
- Basic understanding of n8n workflows
Quick Setup Guide
- Download the JSON template file
- Import it into your n8n instance
- Configure the Google Search Console OAuth credentials
- Set your target email address
- Activate the workflow and set it to run weekly
Key Benefits
Save 1-2 hours per week by eliminating manual report generation and data compilation.
Never miss performance changes with consistent weekly reporting delivered automatically.
Spot trends faster with standardized reporting format that makes week-over-week comparisons easy.
Share insights effortlessly by forwarding automated reports to team members or clients.
Pro tip: Customize the report format to highlight the metrics most important to your business goals, like tracking specific pages or queries.