Marketing Workflows
Marketing and advertising tools
"Blog Image SEO & Size Auditor with Ghost and Google Sheets"
**Tags**: Ghost CMS, SEO Audit, Image Optimization, 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](https://logi-green.com). 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](https://www.linkedin.com/in/samir-saci) ### 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
n8n$9.99Automate SEO Keyword Tracking and Notifications with Google Sheets and SerpAPI
This n8n workflow automates the tracking of SEO keyword positions in Google SERPs using SerpAPI, logs the data in Google Sheets, and sends notifications via WhatsApp and email for any ranking changes.
n8n$14.99Automate Google SERP Data Collection for SEO Analysis
This workflow automates the retrieval of Google Search Engine Results Pages (SERPs) using the ScrapingRobot API, enabling efficient SEO research and analysis.
n8n$14.99Automate Daily Ad Spend Alerts with Google Sheets and Slack
This n8n workflow automatically monitors daily ad spend from a Google Sheet and sends a Slack alert if the spend exceeds $100. Ideal for marketing teams to track budget spikes in real-time.
n8n$9.99Automate Lead Generation and Outreach from Google Maps to Airtable and Gmail
Streamline your lead generation process by automatically extracting business data from Google Maps, cleaning and storing it in Airtable, and sending personalized emails via Gmail.
n8n$14.99Automate Google Indexing with n8n Workflow
Streamline the process of keeping your website indexed on Google by automating URL submissions using the Google Indexing API. This workflow extracts URLs from your sitemap and submits them for indexing, ensuring your site's visibility and SEO are always up-to-date.
n8n$9.99Automate AI-Driven Cold Email Campaigns with n8n, GPT-4, and Mailgun
Leverage AI to personalize and automate cold email sequences using n8n, GPT-4, and Mailgun. This workflow enhances lead engagement through intelligent scheduling and dynamic content generation.
n8n$19.99Automate Business Email Extraction from Google Maps to Google Sheets
Streamline the process of extracting business emails from Google Maps search results using a keyword and save them to Google Sheets. Ideal for outreach, marketing, and research.
n8n$14.99Automate LinkedIn Content Creation from Reddit Discussions Using GPT-4 and Google Sheets
This workflow is designed for marketers and content strategists to transform Reddit discussions into LinkedIn post ideas. It leverages GPT-4 to extract insights and generates content ideas, which are then organized in Google Sheets for easy access.
n8n$14.99Automate Prospect Research and Connection Strategy with Claude AI
This workflow empowers outreach specialists by automating the generation of detailed prospect research reports. It leverages Claude AI to analyze profiles and social media, providing actionable insights and strategies for authentic connections.
n8n$4.99Automate Social Media Content Creation and Publishing with AI
Streamline your social media strategy by automating content generation and publishing across platforms using AI. This workflow pulls content ideas from Google Sheets, generates platform-specific posts with OpenAI, and publishes them on LinkedIn and Twitter.
n8n$9.99Automate Brand Strategy Creation with ChatGPT and Google Docs
Streamline the process of creating a comprehensive brand strategy by leveraging ChatGPT for AI insights and organizing them in Google Docs. This workflow ensures consistency and thoroughness in your strategic planning.
Make$9.99Automate Rank Math SEO Field Updates for WordPress or WooCommerce
This workflow automates the process of updating important Rank Math SEO fields (SEO Title, Description, and Canonical URL) directly via n8n. By leveraging a custom WordPress plugin that extends the WordPress REST API, this workflow ensures that you can programmatically manage SEO metadata for your posts and WooCommerce products efficiently. [Bulk version available here.](https://n8n.io/workflows/4646-rank-math-bulk-title-and-description-optimizer-for-wordpress/) ## How it works: - Sends a POST request to a custom API endpoint exposed by the Rank Math plugin. - Updates SEO Title, Description, and Canonical URL fields for a specified post or product. ### Setup steps: - Install and activate the Rank Math API Manager Extended plugin on WordPress. - Provide the post or product ID you want to update in the workflow. - Run the workflow to update the metadata automatically. ### Benefits: - Full automation of SEO optimizations. - Works for both standard posts and WooCommerce products. - Simplifies large-scale SEO management tasks. To understand exactly how to use it in detail, check out my [comprehensive documentation here.](https://medium.com/@rentierdigital/supercharge-the-rank-math-wordpress-api-how-to-automatically-update-rank-math-seo-fields-with-n8n-6f9127ee0340) ## Rank Math API Manager Extended plugin on WordPress ```language // ATTENTION: Replace the line below with <?php - This is necessary due to display constraints in web interfaces. <?php /** * Plugin Name: Rank Math API Manager Extended v1.4 * Description: Manages the update of Rank Math metadata (SEO Title, SEO Description, Canonical URL) via a dedicated REST API endpoint for WordPress posts and WooCommerce products. * Version: 1.4 * Author: Phil - https://inforeole.fr */ if (!defined('ABSPATH')) { exit; // Exit if accessed directly. } class Rank_Math_API_Manager_Extended { public function __construct() { add_action('rest_api_init', [$this, 'register_api_routes']); } /** * Registers the REST API route to update Rank Math meta fields. */ public function register_api_routes() { register_rest_route('rank-math-api/v1', '/update-meta', [ 'methods' => 'POST', 'callback' => [$this, 'update_rank_math_meta'], 'permission_callback' => [$this, 'check_route_permission'], 'args' => [ 'post_id' => [ 'required' => true, 'validate_callback' => function($param) { $post = get_post((int)$param); if (!$post) { return false; } $allowed_post_types = class_exists('WooCommerce') ? ['post', 'product'] : ['post']; return in_array($post->post_type, $allowed_post_types, true); }, 'sanitize_callback' => 'absint', ], 'rank_math_title' => [ 'type' => 'string', 'sanitize_callback' => 'sanitize_text_field', ], 'rank_math_description' => [ 'type' => 'string', 'sanitize_callback' => 'sanitize_text_field', ], 'rank_math_canonical_url' => [ 'type' => 'string', 'sanitize_callback' => 'esc_url_raw', ], ], ] ); } /** * Updates the Rank Math meta fields for a specific post. * * @param WP_REST_Request $request The REST API request instance. * @return WP_REST_Response|WP_Error Response object on success, or WP_Error on failure. */ public function update_rank_math_meta(WP_REST_Request $request) { $post_id = $request->get_param('post_id'); // Secondary, more specific permission check. if (!current_user_can('edit_post', $post_id)) { return new WP_Error( 'rest_forbidden', 'You do not have permission to edit this post.', ['status' => 403] ); } $fields = ['rank_math_title', 'rank_math_description', 'rank_math_canonical_url']; $results = []; $updated = false; foreach ($fields as $field) { if ($request->has_param($field)) { $value = $request->get_param($field); $current_value = get_post_meta($post_id, $field, true); if ($current_value === $value) { $results[$field] = 'unchanged'; } else { $update_status = update_post_meta($post_id, $field, $value); if ($update_status) { $results[$field] = 'updated'; $updated = true; } else { $results[$field] = 'update failed'; } } } } if ($updated) { return new WP_REST_Response($results, 200); } else { return new WP_Error('no_updates', 'No fields were updated.', ['status' => 400]); } } } ```
n8n$3.99Automate SEO Meta Tag Optimization with Google Sheets and Google Gemini
This workflow automates the process of optimizing SEO meta titles and descriptions directly from Google Sheets using Google Gemini. It ensures that meta tags are concise and meet SEO standards.
n8n$9.99Automate Backlink Status Monitoring with Google Sheets and DataForSEO
This n8n workflow automates the process of checking the status of backlinks listed in a Google Sheet using the DataForSEO On-Page API. It verifies if backlinks are live, dofollow, or lost, and updates the status back in the Google Sheet.
n8n$9.99Automate SEO Blog Publishing for Jekyll with AI and GitHub Integration
Streamline the process of publishing SEO-optimized blog posts to a Jekyll site on GitHub using AI-generated content. This workflow automates content creation, formatting, and social media sharing.
n8n$9.99Automate SEO-Optimized Blog Posts on Blogger with OpenAI and DALL-E
This n8n workflow automates the creation and publishing of SEO-optimized blog posts to Blogger. By sending a blog title via Telegram, it generates comprehensive articles with custom images and publishes them with proper SEO structure.
n8n$14.99Automate Lead Magnet Idea Generation from Google Sheets with RapidAPI AI
This n8n workflow automates the generation of lead magnet ideas by leveraging topics and URLs stored in Google Sheets. It utilizes the Lead Magnet Idea Generator AI API to create valuable content suggestions, streamlining the content ideation process for marketers.
n8n$9.99Identify and Resolve Keyword Cannibalization with Google Search Console
This n8n workflow detects keyword cannibalization in Google Search Console, helping you identify competing pages for the same query. Optimize your site's content strategy by consolidating pages and improving internal linking.
n8n$4.99Automate Daily Email Reports of Google Ads Campaign Performance
This workflow retrieves daily performance statistics from your Google Ads account and sends them via email. Customize the GAQL query to include specific metrics and adjust the email format to suit your needs.
Make$4.99🤖 Automated SEO Strategy Generator (BrowserAct + Make + AI)
This workflow creates an automated, end-to-end SEO strategy generator. It is triggered by a Telegram message, where an initial AI Toolkit refines the user's keyword. The system then uses four separate BrowserAct nodes to scrape real-time data from Google, Bing, Brave, and Google Trends. All collected data is synthesized by Google Gemini AI (acting as an expert SEO specialist) and delivered as a structured, mobile-ready keyword report back to the user via Telegram. Key Technologies: Trigger/Delivery: Telegram Web Scraping: BrowserAct (4 parallel/sequential tasks) Analysis: Google Gemini AI Refinement: Make AI Toolkit (initial processing) Orchestration: Make (formerly Integromat)
Make$4.99Automate Multilingual Content Creation and Distribution with Claude, WordPress, and Mailchimp
This workflow automates the creation of multilingual blog posts, Facebook updates, and email campaigns using Claude, WordPress, and Mailchimp. It leverages AI to generate content in multiple languages from a single email prompt.
Make$4.99Enhance SEO with Browse AI and ChatGPT Integration
Boost your website's Google keyword rankings by leveraging Browse AI for data extraction and ChatGPT for actionable insights. This workflow automates the process of fetching and processing search engine results to improve SEO strategies.
Make$4.99Automate SEO Analysis and Data Logging with RapidAPI and Google Sheets
Streamline your SEO analysis by automating data collection and logging using RapidAPI and Google Sheets. This workflow captures website data, performs various SEO analyses, and logs the results into structured Google Sheets.
n8n$24.99
Related categories
Custom AI Systems & Services
Our team of experienced AI builders will help build custom AI systems, workflows, and solutions.
Request Custom Work