Automate SEO Analysis for Multiple Domains with Ahrefs & Google Sheets
Fetches SEO metrics and traffic data from Ahrefs for domains in a Google Sheet via SEO MCP server, automating bulk analysis and updating results directly in the sheet.
This n8n workflow automates SEO research by pulling organic traffic, keywords, and other metrics from Ahrefs for a list of domains stored in a Google Sheet. It uses a manual trigger to start, loops over domains imported from the sheet, fetches data via an SEO MCP server (leveraging Ahrefs free tools), parses the JSON responses with code nodes, and writes the enriched data back to the sheet. Designed for self-hosted n8n with community nodes, it requires Google Sheets permissions and MCP credentia
- Platform
- n8n
- Category
- Surveys & Forms
- Price
- $14.99
- Creator
- Omar Karlsson
- SEO
- Ahrefs
- Google Sheets
- Marketing
- Automation
- Domain Analysis
- Traffic Data
- Research
- Bulk Processing
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Surveys & Forms workflows
- Create Dynamic Forms with Auto-Updating Dropdowns from Google Sheets$14.99
- Optimize Form Responses with AI-Driven Dynamic Questioning$14.99
- Capture Wufoo Entries in Google Sheets$2.99
- Connect Typeform to ActiveCampaign and Trello for seamless updates$4.99
- Get notified of new Typeform responses in Airtable$2.99
- Talk to Google Sheets Data with ChatGPT AI Agent$14.99
More from Omar Karlsson
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.