Audience Problem Keyword Research Workflow with OpenAI, Ahrefs and Google Sheets

Description

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

Generates relevant keywords and questions from a a customer profile. Keyword data is enriched from ahref and everything is stored in a Google Sheet. This is great for market and customer research. Understanding search intent for a well defined audience and gives relevant actionable data in a fraction of time that manual research takes.

How it works
We'll define a customer profile in the 'Data' node
We use an OpenAI LLM to fetch relevant search intent as keywords and questions
We use an SEO MCP server to fetch keyword 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
Add OpenAI API credentials