Optimize WordPress Blog Posts with AI Automation

What this workflow does

This workflow gets a blog topic from Google Sheets and makes a new WordPress draft post using AI.

It writes SEO-friendly articles and titles, creates images for posts, and adds SEO meta tags automatically.

This solves the problem of slow, error-filled manual content work.

The user saves time and keeps SEO consistent.

Who should use this workflow

• Content managers: Those managing blog post ideas and drafts frequently.
• Marketing teams: Teams needing quick, consistent SEO-optimized posts.
• Bloggers: Anyone wanting AI help for writing and image creation.

Tools and services used

• Google Sheets: Stores blog topics and post planning data.
• WordPress REST API with Yoast SEO plugin: Publishes posts and manages metadata.
• OpenAI and DeepSeek AI models: Generate text and images via Langchain nodes.
• n8n automation platform: Runs the workflow and connects all services.

How the workflow works: Inputs, processing, and outputs

Inputs

• Post topic or idea from Google Sheets.
• User API credentials for Google Sheets, WordPress, and OpenAI.

Processing steps

• Fetch blog prompt from Google Sheets using the Google Sheets (Get context) node.
• Set the prompt for AI generation.
• Use AI (Langchain OpenAI with DeepSeek) to generate article content and SEO-friendly titles.
• Add draft post to WordPress with generated content.
• Generate image based on title with AI.
• Upload image to WordPress media library.
• Set the image as post’s featured media.
• Run SEO analysis AI to get optimized meta title and description.
• Update post meta in WordPress via API.
• Record all data back in Google Sheets.

Outputs

• New WordPress draft post with AI article and title.
• Featured image in WordPress media library.
• SEO meta title and description set in the post.
• Updated Google Sheets row with post details.

Beginner step-by-step: How to use this workflow in n8n

Download and Import Workflow

1. Download the workflow file using the Download button on this page.
2. Open the n8n editor where you want to run this automation.
3. Use the Import from File option in n8n.
4. Select the downloaded workflow file and import it.

Add Credentials and Update IDs

1. In n8n, add your Google Sheets API Key credential.
2. Add your WordPress API credentials with proper permissions.
3. Configure OpenAI API key or DeepSeek model credentials.
4. Update Google Sheets document ID and sheet name if needed inside the Google Sheets (Get context) node.
5. Verify the WordPress site URL and API path in WordPress nodes.
6. Check any image prompt or other text-based inputs and modify if needed.

Test the Workflow

1. Run the workflow manually by clicking the Manual Trigger node or respective trigger.
2. Check n8n logs for errors.
3. Verify a new draft post appears in WordPress and images upload correctly.

Activate for Production Use

1. Turn on the workflow in n8n by switching activation to ON.
2. Set the trigger as desired (for example, webhook or cron schedule) for automatic runs.
3. Monitor execution logs regularly.
4. Consider using error notification nodes or retry logic for stability.
5. For better control, consider self-host n8n to run securely.

Input and output details

Input comes from a Google Sheets row with a post prompt or topic.

The output is a WordPress post draft with AI text, a featured image stored in the media library, and meta tags optimized for SEO.

Google Sheets updates with post URLs, IDs, and meta info for tracking.

Common problems and how to fix them

• Authentication errors: Fix by re-adding and saving API keys for Google Sheets or WordPress.
• Image upload fails: Check that HTTP headers send the correct filename and authentication is present.
• SEO meta too long: Edit SEO Expert AI prompt to stress length limits and run test generation.

How to customize this workflow

• Change AI model in all Langchain OpenAI nodes by editing the modelId property.
• Modify style or size of generated images by changing prompt text in Generate image node.
• Publish posts directly by setting WordPress post status to “publish” instead of “draft”.
• Add extra columns like categories or tags in Google Sheets and edit nodes to handle these.
• Adjust SEO rules by rewriting the prompt in the SEO Expert node for custom branding.

Before you start running this workflow

• Confirm Google Sheets document ID and sheet name are correct.
• Test WordPress REST API with credentials.
• Verify OpenAI or DeepSeek access and keys are valid.
• Check all AI prompts are correct and use proper HTML formatting if needed.
• Run a test with a sample prompt and confirm draft posts create correctly.
• Ensure images upload to WordPress media and set as featured image.
• Check SEO meta tags appear in WordPress source code after publishing.
• Back up Google Sheets data before batch runs to avoid data loss.

Summary

✓ Automates blog post creation from planning sheet to WordPress draft.

✓ Generates SEO-friendly article text and titles using AI models.

✓ Creates featured images automatically and uploads to WordPress.

✓ Adds SEO meta tags checked by expert AI model.

✓ Keeps Google Sheets updated with post info for tracking.

→ Users get faster, less error-prone content publishing workflows.