Automate Weekly SEO Reports from Google Search Console to Email

This n8n workflow automates the retrieval of key SEO performance metrics—clicks, impressions, click-through rate (CTR), and average position—from Google Search Console for the past week. It processes the data using a Function node to create a clean, readable summary and sends it directly to your email inbox via SMTP every Monday at 7 AM using a Cron trigger. Sticky notes in the canvas provide step-by-step guidance for easy setup.

Benefits include significant time savings by eliminating manual data pulls and report generation, ensuring consistent weekly insights without oversight. It's reliable, customizable (e.g., add more queries or PDF export), and requires minimal setup (~10 minutes) with Google OAuth2 and SMTP credentials.

Ideal for website owners, bloggers, digital marketers, and SEO consultants tracking performance trends. Use it to monitor site health, spot improvements or issues early, and make data-driven decisions effortlessly. Perfect for agencies handling multiple client sites.