Automate SEO analysis for multiple domains with Ahrefs and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Mcp (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Domains in sheet (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Get SEO Stats (Mcp Client): uses Mcp Client
- Get Traffic (Mcp Client): uses Mcp Client
- Parse JSON (Code): runs custom JavaScript code
- Parse JSON (Code): runs custom JavaScript code
- Add Domain SEO Data To Sheet (Google Sheets): uses Google Sheets
- Add Traffic Data To Sheet (Google Sheets): uses Google Sheets
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-mcp is verified or supports 3.0 (used in Get SEO Stats, Get Traffic).
Nodes used (5)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Mcp Client
n8n-nodes-mcp.mcpClient
From the author
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Fetch SEO and traffic information from ahref for a list of domains in a Google Sheet. This is great for marketing research and SEO workflow optimizations and…