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, a 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.
