🚀 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.
🎧 Translate Audio with AI
October 5, 2025
OverviewThis workflow takes some French text and translates it into spoken audio. It then transcribes that audio back into text, translates it into English, and