Categorize SEO keywords & create content strategy with AI and Airtable
Needs changesWhat this workflow does
This AI workflow has 31 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Airtable and OpenAI Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Airtable Fields (Edit Fields (Set)): sets 6 fields: airtable_base_id, categories_table_id, content_ideas_from_kws_table_id…
- Airtable: search
- Set WF Fields (Edit Fields (Set)): sets 10 fields: keyword, record_id, primary_keyword…
- Aggregate: combines items into one
- Category AI Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Set Field for Agent (Edit Fields (Set)): sets 1 field: keyword_dataset
- Set Category Table Fields (Edit Fields (Set)): sets 8 fields: keyword, category, reasoning…
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- Category Table (Airtable): create
- Edit Fields (Edit Fields (Set)): sets 1 field: items
…plus 16 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 Agent Create Content Opps (v1.7), Category AI Agent (v1.7), Content Ideas from Category AI Agent (v1.7)…: 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) Agent Create Content Opps (v1.7), Category AI Agent (v1.7), Content Ideas from Category AI Agent (v1.7), AI Agent Analyze and Cluster KWs (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Filter
n8n-nodes-base.filter - Edit Fields (Set)
n8n-nodes-base.set - Airtable
n8n-nodes-base.airtable - Split Out
n8n-nodes-base.splitOut - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Aggregate
n8n-nodes-base.aggregate - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Premium n8n Workflow: SMART AI Keyword Categorization & Content Strategy This n8n workflow transforms raw keyword data into actionable content intelligence using advanced AI categorization and clustering. It creates a comprehensive content strategy with…