Automate WordPress Blog Post Generation with AI, Smart Categories & Media Uploads

• Scheduled Content Generation: Automatically creates and publishes new blog posts at predefined intervals (e.g., every few hours).
• AI-Powered Article Creation: Utilizes OpenAI's GPT models to generate unique, well-structured articles with professional formatting.
• Smart Category Management: Integrates with PostgreSQL to track and prioritize the least-used WordPress categories for balanced content distribution.
• Automated Media Uploads: Generates and uploads relevant featured images directly to your WordPress media library, linking them to the post.
• Full WordPress Integration: Publishes posts directly to your WordPress site with a 'publish' status, ready for readers.

To get this workflow up and running, follow these steps:

1. Set DOMAIN Variable: Define your WordPress site URL (e.g., DOMAIN=https://your-wordpress-site.com) as an environment variable or in a 'Set' node anywhere before the workflow starts. This is used for all WordPress REST API calls.
2. Create n8n Credentials: Set up the following credentials in n8n (use the exact names specified in the workflow's sticky note):
   • YOUR_WORDPRESS_CREDENTIAL (WordPress API with POST /media, POST /posts scope)
   • YOUR_POSTGRES_CREDENTIAL (PostgreSQL access)
   • YOUR_OPENAI_CREDENTIAL (OpenAI key for GPT-4 mini or better)
3. Configure PostgreSQL Database:
   • Connect to your PostgreSQL server (e.g., sudo -u postgres psql in terminal).
   • Execute the SQL commands provided in the workflow's sticky note to create the n8n_blog database, n8n_writer user, and the used_categories tracking table. Grant necessary privileges.
   • Configure your YOUR_POSTGRES_CREDENTIAL in n8n with these database details.
4. Initial Test: Manually run the first 3–5 nodes of the workflow to verify WordPress authentication, database connection, and GPT responses.
5. Enable Schedule Trigger: Once initial tests are successful, activate the 'Schedule Trigger' node to begin automated blog post publishing.