Automate SEO Reporting with Google Search Console, GA4, and Google Sheets

How it works:

This workflow automates comprehensive SEO reporting by:

• Extracting keyword rankings and page performance from Google Search Console.
• Gathering organic reach metrics from Google Analytics.
• Analyzing internal and external article links.
• Tracking keyword position changes (gains and losses).
• Formatting and importing all data into Google Sheets reports.

Set up steps:

1. Connect Google Services: Authenticate Google Search Console, Google Analytics, and Google Sheets OAuth2 credentials.
2. Configure Source Sheet: Set up a data source Google Sheet with article URLs to analyze.
3. Set Report Sheet: Create or specify destination Google Sheets for reports.
4. Update Date Ranges: Modify date parameters in GSC and GA nodes for your reporting period.
5. Customize Filters: Adjust keyword filters and row limits based on your needs.
6. Test Individual Sections: Each reporting section (keywords, pages, articles, position changes) can be tested independently.

The workflow includes separate flows for:

• Keyword ranking (top 1000).
• Page ranking analysis.
• Organic reach reporting.
• Internal article link analysis.
• External article link analysis.
• Position gain/loss tracking.