Templates / Automated SEO blog publishing with WordPress, OpenAI & Perplexity

Automated SEO blog publishing with WordPress, OpenAI & Perplexity

Ready for 3.0

by LukaszB ✓ · 297 views · created 2025-08-27 · Content Creation, Multimodal AI

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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).

  1. Get data databse (Google Sheets): uses Google Sheets
  2. Limit: keeps the first few items
  3. Set input data/credintenials (Edit Fields (Set)): sets 6 fields: blog_title, blog_s_descritpion, cloudinary account name…
  4. 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
  5. Split Out: splits a list into separate items
  6. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  7. Aggregate: combines items into one
  8. Generate an image (Google Gemini): work with image
  9. Generate an image (OpenAI): work with image
  10. 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

OpenAI Chat ModelGoogle GeminiPerplexityGoogle SheetsWordpressOpenAI

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)

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…

Excerpt from LukaszB's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.