Automated SEO blog publishing with WordPress, OpenAI & Perplexity
Ready for 3.0What this workflow does
This AI workflow has 34 nodes and runs on a schedule (every day). Along the way it connects OpenAI Chat Model, Google Gemini, Perplexity and Google Sheets and 2 more. It also calls api.pexels.com over HTTP.
How it runs
Trigger: On a schedule (every day).
- Get data databse (Google Sheets): uses Google Sheets
- Limit: keeps the first few items
- Set input data/credintenials (Edit Fields (Set)): sets 6 fields: blog_title, blog_s_descritpion, cloudinary account name…
- Content planer (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Message a model in Perplexity); output parser: Structured Output Parser
- Split Out: splits a list into separate items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Aggregate: combines items into one
- Generate an image (Google Gemini): work with image
- Generate an image (OpenAI): work with image
- Article wrtiter (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model
…plus 16 more steps. See the full node list below.
Services it uses
HTTP calls to: api.pexels.com
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 (16)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Aggregate
n8n-nodes-base.aggregate - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Limit
n8n-nodes-base.limit - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Perplexity Tool
n8n-nodes-base.perplexityTool - Google Sheets
n8n-nodes-base.googleSheets - Wordpress
n8n-nodes-base.wordpress - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Automated Blog n8n System – Professional Articles in Minutes Most blogs publish words. This system publishes experiences. With one simple row in Google Sheets, your blog comes alive with SEO & RAO-friendly WordPress articles — written, illustrated, and…