Creating SEO-optimized blogs for WordPress using specific tools
Ready for 3.0What this workflow does
This AI workflow has 100 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Wordpress, OpenAI, Postgres and OpenAI Chat Model and 3 more.
How it runs
Trigger: On a schedule (every day) (plus 1 other trigger).
- Fetch Keywords (Postgres): uses Postgres
- select blog table (Postgres): uses Postgres
- Limit: keeps the first few items
- Limit: keeps the first few items
- Edit Fields (Edit Fields (Set)): sets or maps fields
- Preliminary Plan (OpenAI): uses OpenAI
- Aggregate: combines items into one
- Message a model (Perplexity): uses Perplexity
- Choose keywords, Intent, etc (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Select rows from a table in Postgres); output parser: Structured Output Parser
- Split Out: splits a list into separate items
…plus 76 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (24)
- Wordpress
n8n-nodes-base.wordpress - OpenAI
@n8n/n8n-nodes-langchain.openAi - Perplexity
n8n-nodes-base.perplexity - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Limit
n8n-nodes-base.limit - Filter
n8n-nodes-base.filter - Aggregate
n8n-nodes-base.aggregate - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Postgres
n8n-nodes-base.postgres - Merge
n8n-nodes-base.merge - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - GitHub
n8n-nodes-base.github - Extract from File
n8n-nodes-base.extractFromFile - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Postgres Tool
n8n-nodes-base.postgresTool - Schedule Trigger
n8n-nodes-base.scheduleTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Slack
n8n-nodes-base.slack - No Operation, do nothing
n8n-nodes-base.noOp
From the author
✍️ AI-Powered High-Quality Blog Automation Automate SEO-optimized blog creation, publishing, and internal linking — designed for Lovable.dev or seamless WordPress integration. Proven to boost impressions by +15% weekly on real websites. 📌 Example: AI…