Back to Templates

Automate SEO Analysis for Multiple Domains with Ahrefs and Google Sheets

Created by

Created by: Michael Muenzer || michaelmuenzer

Michael Muenzer

Last update

Last update 4 hours ago

Categories

Share


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