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.
What this workflow does
This AI workflow has 31 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Google Analytics and OpenAI. It also calls googleapis.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Export Data from Document (Google Sheets): uses Google Sheets
- Export Data from Document (Google Sheets): uses Google Sheets
- Format Data (Code): runs custom JavaScript code
- Format Data (Code): runs custom JavaScript code
- Import Data to Sheet (Google Sheets): append
- Import Data to Sheet (Google Sheets): append
- Export Links from Google Document (Google Sheets): uses Google Sheets
- Analyze External Links (HTTP Request): calls an HTTP API
- Format Data for Table (Code): runs custom JavaScript code
- Proper Data Formatting (OpenAI): uses OpenAI
…plus 20 more steps. See the full node list below.
Services it uses
HTTP calls to: googleapis.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
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
From the author
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. -…