Ghost Blog Image Asset Audit to Google Sheets
detail.loadingPreview
This n8n workflow automates the extraction of image URLs and alt text from your Ghost CMS blog posts. It organizes and stores this valuable image metadata, along with article details, into a Google Sheet for easy auditing and asset management.
About This Workflow
Effortlessly manage and audit all image assets within your Ghost CMS blog with this n8n workflow. It connects to your Ghost site, retrieves your blog posts, and intelligently parses their HTML content to pinpoint every embedded image. For each image, it extracts the src URL and crucial alt text. This rich metadata, including the article ID, title, and URL, is then meticulously organized and appended to a specified Google Sheet. This not only streamlines your SEO efforts by highlighting missing alt text but also provides a comprehensive, centralized inventory of your blog's visual content, enhancing accessibility and content governance.
Key Features
- Automated Ghost CMS Integration: Seamlessly fetch blog posts from your Ghost CMS using the content API.
- Comprehensive Image Metadata Extraction: Automatically parse post HTML to identify and extract image URLs and their associated
alttext. - Centralized Data Storage: Log all extracted image and article details (ID, title, URL, image URL, alt text) into a Google Sheet for easy access and analysis.
- Scalable Batch Processing: Designed to process multiple blog posts and their embedded images, ensuring efficient auditing.
- SEO & Accessibility Ready: Helps identify and track images with missing or incomplete alt text, crucial for SEO and web accessibility.
How To Use
- Configure Ghost Credentials: In the "Extract Blog Posts" node, add your Ghost Content API credentials (API URL and Content API Key) to connect to your blog.
- Set Up Google Sheets Credentials: For the "Add Records" node, provide your Google Sheets OAuth2 API credentials. This will grant n8n access to your Google Sheet.
- Specify Google Sheet Details: Within the "Add Records" node, select the
Document ID(your Google Sheet) andSheet Namewhere you want the image data to be stored. Ensure your sheet has columns matching the data being sent (e.g.,articleId,articleTitle,article_url,image_url,alt_text). - Adjust Post Retrieval Limit: In the "Extract Blog Posts" node, modify the
Limitparameter from1to0(for all) or a specific number to control how many blog posts are processed. - Run the Workflow: Execute the workflow manually via the trigger node to test the setup. Once verified, activate it to run on a schedule or trigger it as needed for continuous auditing.
Apps Used
Workflow JSON
{
"id": "c87e0e26-e3be-4eb8-9249-410aa0415808",
"name": "Ghost Blog Image Asset Audit to Google Sheets",
"nodes": 28,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: c87e0e26-e3be...
About the Author
DevOps_Master_X
Infrastructure Expert
Specializing in CI/CD pipelines, Docker, and Kubernetes automations.
Statistics
Related Workflows
Discover more workflows you might like
Automate Getty Images Editorial Search & CMS Integration
This n8n workflow automates searching for editorial images on Getty Images, extracts key details and embed codes, and prepares them for seamless integration into your Content Management System (CMS), streamlining your content creation process.
Google Sheets to Icypeas: Automated Bulk Domain Scanning
This workflow streamlines the process of performing bulk domain scans by integrating your Google Sheets data directly with the Icypeas platform. Automate the submission of company names from your spreadsheet to Icypeas for comprehensive domain information, saving valuable time and effort.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.