Automate SEO Analysis for Multiple Domains with Ahrefs & Google Sheets

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 credentials setup.

Key benefits include massive time savings on manual SEO audits—process dozens or hundreds of domains in minutes instead of hours. It eliminates repetitive data entry, reduces errors, and centralizes results for easy sharing and further analysis in Sheets. Ideal for marketers scaling competitor research or tracking portfolio performance.

Use cases: Perform bulk competitor analysis before content strategies, monitor domain health for acquisitions, generate lead lists with SEO viability scores, or automate weekly traffic reports. Copy the provided Google Sheet template, add domains to column A, configure credentials, and execute for instant insights.