Auto-generate & publish SEO articles to WordPress with GPT-4 + Postgres tracking
n8n23 modulesv1.0What 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
At a glance
Auto-generate & publish SEO articles to WordPress with GPT-4 + Postgres tracking is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects agent, code, httpRequest, lmChatOpenAi. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- agent, code, httpRequest, lmChatOpenAi, merge, noOp
- Modules
- 23
- Price
- Free
- Version
- v1.0
About this workflow
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= 🔐 Create these 3 credentials in n8n: YOURWORDPRESSCREDENTIAL — for /media, /posts YOURPOSTGRESCREDENTIAL — for category tracking YOUROPENAICREDENTIAL — GPT-4-mini or better 🧱 Run the SQL from docs to create the usedcategories 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.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
AI weather forecasts with MCP integration
Telegram appointment scheduler bot with Google Calendar & Sheets
🎓 Learn n8n expressions with an interactive step-by-step tutorial for beginners
💰 Financial AI agent Telegram and WhatsApp
Gmail auto-reply generator with ChatGPT
Learn anything, write a book, design a curriculum
Real-time crypto news & sentiment analysis via Telegram with GPT-4o
Audio-to-Trello task bot
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you