Automated WordPress Blog Creator with GPT & PostgreSQL

This workflow fully automates the process of generating and publishing high-quality WordPress blog posts using GPT and PostgreSQL. It selects the least-used category from your WordPress site, generates a unique SEO-friendly article with structured WordPress HTML blocks, creates and uploads a featured image, and publishes the post directly to WordPress — while keeping track of category usage in a PostgreSQL database to ensure balanced content distribution.

Ideal for content creators, marketers, and website owners who want consistent, automated blog posting without manual effort.

✨ Features

• ⏰ Scheduled Automation — Runs automatically at defined intervals via the Schedule Trigger.
• 📂 Dynamic Category Selection — Loads categories from WordPress, excludes unwanted ones, and picks the least-used category from PostgreSQL.
• 🧠 AI-Powered Content Creation — Uses GPT to generate unique, structured blog posts with headings, lists, table of contents, and call-to-action blocks.
• 📝 SEO-Optimized Titles — GPT generates fresh, non-duplicate, engaging titles for every article.
• 🖼 Featured Image Handling — Creates a placeholder cover image, downloads it, and uploads it to WordPress Media.
• 📊 Database Tracking — Stores category usage and article metadata in PostgreSQL to avoid repetitive posts.
• 🚀 Automatic Publishing — Prepares the final JSON and publishes the post to WordPress with title, content, featured image, and category.
• 🔄 End-to-End Integration — Smoothly connects WordPress, PostgreSQL, and OpenAI into a single automated publishing pipeline.