n8nflow.net logo

Automate SEO Analysis for Multiple Domains with Ahrefs and Google Sheets

by Michael MuenzerUpdated: Last update a month agoSource: n8n.io
Loading workflow viewer...

Getting Started

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