Automate SEO Blog Post Creation with AI

This is a comprehensive content automation pipeline. It reads a topic from a Google Sheet, then leverages AI models like DeepSeek and OpenAI to generate a full article, title, and featured image. The workflow assembles these elements, creates SEO meta tags, and publishes a complete, optimized draft directly to your WordPress site, drastically accelerating your content production schedule.

Workflow Overview

What is this?: This workflow provides an end-to-end solution for automated content creation. It takes a topic from a Google Sheet row and uses various AI models to generate a complete, well-structured blog post, a catchy title, a relevant featured image, and SEO-optimized meta tags for WordPress.
What problem does it solve?: Tired of the endless cycle of ideation, writing, sourcing images, and SEO-tweaking for every single blog post? This automation eliminates the manual grind of content production, freeing up your time to focus on strategy instead of repetitive tasks.
What will you get?: Fully automate your blog content pipeline from a single prompt. Generate high-quality, SEO-ready articles in minutes, not hours. Ensure consistent content quality and formatting for every post published. Scale your content marketing efforts without increasing your team's workload.

Apps Included

How to Use

Prerequisites

An active n8n instance.

A Google account with a pre-configured Google Sheet (a template link is usually provided).

A WordPress site with REST API access enabled.

API keys for the AI services used (e.g., OpenAI for images, DeepSeek or OpenRouter for text generation).

Setup Steps

Configure Google Sheet

Clone the provided Google Sheet template. In your copy, populate the 'PROMPT' column with the topics or keywords you want the AI to write about.

Add Credentials in n8n

Navigate to the 'Credentials' section in your n8n instance and add new credentials for Google Sheets, WordPress, OpenAI, and any other AI model provider used in the workflow.

Update Workflow Nodes

Open the workflow editor. In the Google Sheets nodes, select your newly created credential and enter your specific Sheet ID. Similarly, update the WordPress and HTTP Request nodes with your site's URL and select the correct credential.

Test and Activate

Click the 'Test workflow' button to run the process for a single row in your sheet. Once you confirm that a draft post is successfully created in WordPress, save and activate the workflow for future use.

Pro Tips

Consider adding an error-handling branch after each API call. This can send a notification to Slack or email if a service fails, preventing the workflow from stopping unexpectedly.

Customize the prompts within the 'Generate article' and 'SEO Expert' nodes to better match your brand's specific tone of voice and content style.

To fully automate publishing, change the 'status' field in the 'Add draft to WP' node from 'draft' to 'publish'.

Back

Information

Published date9/23/2025
Last updated9/23/2025