Automated blog post generation from OpenAI to WordPress using PostgreSQL

• Automate blog content creation for WordPress
• Generate SEO-optimized article titles and content
• Manage WordPress categories and track usage with PostgreSQL
• Schedule regular blog updates without manual intervention

Scheduled trigger initiates the workflow at defined intervals Fetches categories from WordPress and filters out excluded ones Selects the least-used category for the next blog post Generates a unique article title and content using OpenAI Downloads and uploads images to WordPress media Publishes the completed post to the WordPress site

1. 1
   Import the workflow into n8n
2. 2
   Set the WordPress domain in the Config node
3. 3
   Create and configure necessary credentials for WordPress, PostgreSQL, and OpenAI
4. 4
   Run the first few nodes manually to verify connections
5. 5
   Enable the Schedule Trigger to automate the workflow