Publish WordPress posts from Google Sheets with images and tags
Ready for 3.0What this workflow does
This workflow has 20 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Variables (Edit Fields (Set)): sets 2 fields: website_URL, google_sheet_URL
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Code: runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- If: checks a condition and branches into true / false
- Load $image as binary (HTTP Request): calls an HTTP API
- If: checks a condition and branches into true / false
- Upload $image to WP (HTTP Request): calls an HTTP API (POST)
- Parse $tags (Code): runs custom JavaScript code
- Prepare data (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 (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Split Out
n8n-nodes-base.splitOut - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code
From the author
Who this is for This workflow is for content teams, marketers, and solo site owners who draft posts in Google Sheets and want a reliable way to publish to WordPress automatically — including featured images and tags. What it does - Pulls rows from a Google…