Audience problem keyword research workflow with OpenAI, Ahrefs and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI, Google Sheets and Mcp (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Data (Edit Fields (Set)): sets 3 fields: customer_profile, ahref_seo_country, ahref_search_engine
- AEO Questions (OpenAI): uses OpenAI
- SEO Seed Keywords (OpenAI): uses OpenAI
- Parse Question JSON (Code): runs custom JavaScript code
- Parse Keyword JSON (Code): runs custom JavaScript code
- Loop Over AI Questions (Loop Over Items (Split in Batches)): loops over the items in batches
- Loop Over AI Keywords (Loop Over Items (Split in Batches)): loops over the items in batches
- Add AI question (Google Sheets): append or update
- Add keyword (Google Sheets): append or update
- Related Keyword Generator (Mcp Client): execute tool
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-mcp is verified or supports 3.0 (used in Related Keyword Generator).
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Mcp Client
n8n-nodes-mcp.mcpClient - If
n8n-nodes-base.if
From the author
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…