✍️ Blog image SEO & size auditor with Ghost and 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 workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Ghost and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Extract Blog Posts (Ghost): get many
- Extract Post Content (Edit Fields (Set)): sets 6 fields: id, title, featured_image…
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Collect All Images (Code): runs custom JavaScript code
- Collect Records by Id (Google Sheets): uses Google Sheets
- Add Records (Google Sheets): append
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Get Image (HTTP Request): calls an HTTP API
- Extract Image Info (Code): runs custom JavaScript code
- Results Images (Google Sheets): append or update
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 (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Ghost
n8n-nodes-base.ghost - Edit Fields (Set)
n8n-nodes-base.set - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest
From the author
Tags: Ghost CMS, SEO Audit, Image Optimisation, Alt Text, Google Sheets, Automation Context Hi! I’m Samir — a Supply Chain Engineer and Data Scientist based in Paris, and founder of LogiGreen Consulting. I help companies and content creators use automation…