Automate SEO Analysis for Multiple Domains with Ahrefs and Google Sheets

Description

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 saves tons of time.

How it works
We'll import domains from the Google sheet
We use an SEO MCP server to fetch data from ahref free tooling
The fetched data is stored in the Google sheet

Set up steps
Copy Google Sheet template and add it in all Google Sheet nodes
Make sure that n8n has read & write permissions for your Google sheet.
Add your list of domains in the first column in the Google sheet
Add MCP credentials for seo-mcp