Comprehensive SEO keyword research with OpenAI & DataForSEO analytics to NocoDB
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 26 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI Chat Model, NocoDB, Slack and Dataforseo (community).
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Set relevant fields (Edit Fields (Set)): sets 8 fields: primary_topic, competitor_urls, target_audience…
- Topic Expansion (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Format Json and add Competitor URLs (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Update Status - Started (NocoDB): update
- Start Notification (Slack): uses Slack
- split primary keywords (Split Out): splits a list into separate items
- Merge: merges the data from its input branches
- Split the Competitor URLs (Split Out): splits a list into separate items
- Final Keyword Strategy (AI Agent): runs an AI agent, with model: OpenAI Chat Model
…plus 11 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Topic Expansion (v1.8), Competitor Analysis (v1.8), Final Keyword Strategy (v1.8): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Topic Expansion (v1.8), Competitor Analysis (v1.8), Final Keyword Strategy (v1.8) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (12)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent
@n8n/n8n-nodes-langchain.agent - Data For Seo
n8n-nodes-dataforseo.dataForSeo - Split Out
n8n-nodes-base.splitOut - Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Aggregate
n8n-nodes-base.aggregate - Merge
n8n-nodes-base.merge - NocoDB
n8n-nodes-base.nocoDb - Slack
n8n-nodes-base.slack
From the author
AI-Powered SEO Keyword Research Workflow with n8n > automates comprehensive keyword research for content creation Table of Contents 1. Introduction 2. Workflow Architecture 3. NocoDB Integration 4. Data Flow 5. Core Components 6. Setup Requirements 7.…