AI SEO Article Generator & Auto-Publisher to WordPress

This n8n workflow revolutionizes content creation by intelligently selecting the least-used WordPress category from a PostgreSQL database, generating fully formatted SEO articles using GPT-4-mini or better. It includes headings, table of contents, lists, calls-to-action, and Yoast SEO blocks for optimal search performance. A placeholder cover image is created and uploaded to WordPress media library, followed by publishing the post via the WP REST API with the correct category and featured image. Finally, it logs category usage to ensure rotation and prevent duplicates.

Setup is quick: add your WordPress domain, create credentials for WordPress, PostgreSQL, and OpenAI, run a simple SQL script to create the tracking table, and test the first few nodes. Schedule it to run automatically for hands-free content production.

Ideal for SEO content farms, affiliate blogs, micro-niche sites, and private blog networks (PBNs). It saves hours of manual writing, uploading, and categorization, delivering structured, professional posts that boost traffic and rankings without spam risks.