Automate blog content creation from topics to WordPress with AI, Google Drive & Sheets
Ready for 3.0What 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”.
- Get Blog Topics (Google Sheets): uses Google Sheets
- Split In Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Configuration (Edit Fields (Set)): sets 2 fields: Brand, Blog Title
- If: checks a condition and branches into true / false
- Basic LLM Chain: sends a prompt to an LLM, with model: OpenRouter Chat Model
- Send a message (Slack): uses Slack
- Basic LLM Chain: sends a prompt to an LLM, with model: OpenRouter Chat Model
- Code: runs custom JavaScript code
- Upload file (Google Drive): uses Google Drive
- Publish to WordPress (HTTP Request): calls an HTTP API (POST)
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 (11)
- Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Google Drive
n8n-nodes-base.googleDrive - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
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…