n8n SEO Content Creation Marketing
Contributed by Sabrina Ramonov 🍄. From the community directory at agents.sabrina.dev, republished with permission and full credit.
What this flow does
• Selects the least-used WordPress category (tracked in PostgreSQL)
• Uses GPT (4-mini or better) to generate a fully formatted SEO article with headings, TOC, lists, CTA, and Yoast blocks
• Creates a placeholder cover image and uploads it to WordPress Media
• Publishes the final post via /wp-json/wp/v2/posts with correct category + featured image
• Logs the used category for future rotation (zero duplicates!)
Setup in 3 mins
Add your WordPress domain with a simple Set node:domain=https://yourdomain.com
Create these 3 credentials in n8n:YOUR_WORDPRESS_CREDENTIAL, for /media, /postsYOUR_POSTGRES_CREDENTIAL, for category trackingYOUR_OPENAI_CREDENTIAL, GPT-4-mini or better
Run the SQL from docs to create the used_categories table
Manually test first 3-5 nodes to check WP auth, OpenAI response, and DB connection
Then just schedule it and let the bot write for you.
Why it's awesome
This is your personal AI content writer + publisher, perfect for:
• SEO content farms
• Affiliate blogs
• Micro niche sites
• PBNs with rotation-safe automation
No more manual uploads, broken categories, or GPT spam. Every post is structured, beautiful, and intelligently categorized.
Tools used: OpenAI ChatGPT, WordPress, Postgres
Download the workflow template (JSON)
Want this running in your business? KOBA42 builds and operates automations like this one.