Automate SEO reporting with Google Search Console, GA4, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Google Analytics
n8n-nodes-base.googleAnalytics - OpenAI
@n8n/n8n-nodes-langchain.openAi
What it does
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.