Author and publish blog posts from Google Sheets
Ready for 3.0Ready 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 22 nodes and runs on a schedule (every hour) (plus 1 other trigger). Along the way it connects Google Sheets and OpenAI Chat Model.
How it runs
Trigger: On a schedule (every hour) (plus 1 other trigger).
- Settings (Edit Fields (Set)): sets 9 fields: urlSpreadsheet, urlWordpress, wordpressUsername…
- fetchConfig (Google Sheets): uses Google Sheets
- Schedule (Google Sheets): uses Google Sheets
- Config (Code): runs custom JavaScript code
- PreparedData (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- PrepareXmlPost (Code): runs custom JavaScript code
…plus 9 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 (9)
- Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - HTTP Request
n8n-nodes-base.httpRequest
From the author
What it is: An automation to plan→draft→finalize and publish your textual blog post ideas to your wordpress blog Works in stages and hand back control to you in between those You can use a Google Spreadsheet for planning topics and configuring LLM models and…