Auto-Generate & Publish SEO Articles to WordPress with GPT-4 + Postgres Tracking
n8n template #3887Summary
Use templateπ 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: YOURWORDPRESSCREDENTIAL β for /media, /posts YOURPOSTGRESCREDENTIAL β for category tracking YOUROPENAICRED
Hand off to your agent
Prompt
Help me set up the n8n workflow "Auto-Generate & Publish SEO Articles to WordPress with GPT-4 + Postgres Tracking" (https://n8n.io/workflows/3887). It uses: HTTP Request, Postgres, Code, AI Agent, OpenAI Chat Model. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Similar workflows
NameViews
- Generate AI Viral Videos with Seedance and Upload to TikTok, YouTube & Instagram215K
- β¨π€Automate Multi-Platform Social Media Content Creation with AI205K
- Build Your First AI Data Analyst Chatbot134K
- Create a Branded AI-Powered Website Chatbot88K
- AI-Powered WhatsApp Chatbot π€π² for Text, Voice, Images & PDFs with memory π§ 71K
- β¨π©·Automated Social Media Content Publishing Factory + System Prompt Composition55K
- AI Youtube Trend Finder Based On Niche55K
- AI-Powered WhatsApp Chatbot for Text, Voice, Images, and PDF with RAG47K