Per visualizzare la demo del flow n8n e copiare il JSON devi acquistare il nostro Bundle... tranquillo è GRATIS

VAI AL BUNDLE

Auto-Generate & Publish SEO Articles to WordPress with GPT-4 + Postgres Tracking

🚀 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, /posts
    YOUR_POSTGRES_CREDENTIAL — for category tracking
    YOUR_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.

Do you want to automate your business?

Let's talk about your project