Templates / Automate blog content creation from topics to WordPress with AI, Google Drive & Sheets

Automate blog content creation from topics to WordPress with AI, Google Drive & Sheets

Ready for 3.0

by Jonas Frewert ✓ · 795 views · created 2025-11-10 · 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 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Drive, Slack, OpenRouter Chat Model and Google Sheets.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. Get Blog Topics (Google Sheets): uses Google Sheets
  2. Split In Batches (Loop Over Items (Split in Batches)): loops over the items in batches
  3. Configuration (Edit Fields (Set)): sets 2 fields: Brand, Blog Title
  4. If: checks a condition and branches into true / false
  5. Basic LLM Chain: sends a prompt to an LLM, with model: OpenRouter Chat Model
  6. Send a message (Slack): uses Slack
  7. Basic LLM Chain: sends a prompt to an LLM, with model: OpenRouter Chat Model
  8. Code: runs custom JavaScript code
  9. Upload file (Google Drive): uses Google Drive
  10. Publish to WordPress (HTTP Request): calls an HTTP API (POST)

Services it uses

Google DriveSlackOpenRouter Chat ModelGoogle Sheets

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 (11)

From the author

Blog Post Content Creation (Multi-Topic with Brand Research, Google Drive, and WordPress) Description This workflow automates the full lifecycle of generating and publishing SEO-optimized blog posts from a list of topics. It reads topics (and optionally…

Excerpt from Jonas Frewert'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.