✍️ Blog Image SEO & Size Auditor with Ghost and Google Sheets

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 and analytics to improve visibility, enhance performance, and reduce manual work.

Let’s use n8n to automate SEO audits to increase your traffic!

📬 For business inquiries, feel free to connect on LinkedIn

Who is this template for?

This workflow is perfect for bloggers, marketers, or content teams using Ghost CMS who want to:

• Extract and review all images from articles
• Detect missing or short alt texts
• Check image file size and filename SEO compliance
• Push the audit results into a Google Sheet

How does it work?

This n8n workflow extracts all blog posts from Ghost CMS, scans the HTML to collect all embedded images, then evaluates each image for:

• ✅ Presence and length of alt text
• 📏 File size in kilobytes
• 🔤 Filename SEO quality (e.g. lowercase, hyphenated, no special chars)

All findings are written to Google Sheets for further analysis or manual cleanup.

🧭 Workflow Steps:

1. 🚀 Trigger the workflow manually or on schedule
2. 📰 Extract blog post content from Ghost CMS
3. 🖼️ Parse all <img> tags with src and alt attributes
4. 📤 Store image metadata in a Google Sheet (step 1)
5. 🌐 Download each image using HTTP request
6. 🧮 Extract file size, extension, and filename SEO flag
7. 📄 Update the audit sheet with size and format insights

What do I need to get started?

This workflow requires:

• A Ghost Content API key
• A Google Sheet (to log audit results)
• No AI or external APIs required — works fully with built-in nodes

Next Steps

🗒️ Follow the sticky notes inside the workflow to:

• Plug in your Ghost blog credentials
• Select or create a Google Sheet
• Run the audit and start improving your SEO!

This template was built using n8n v1.93.0
Submitted: June 8, 2025