WordPress AI Blog Post Generator

This workflow is for anyone who wants to automate blog post creation and publishing to WordPress, especially those managing content for multiple categories. This workflow automatically creates and publishes unique, high-quality blog posts to a WordPress site. It uses AI to generate titles and full articles, ensuring content is relevant to specific categories and avoids repetition. It also manages image downloads and uploads, and tracks category usage in a PostgreSQL database. Set up the WordPress domain in the "Config" node. Create WordPress, PostgreSQL, and OpenAI credentials in n8n with specific permissions (WordPress for media/posts, PostgreSQL for database access, OpenAI for GPT-4). Initialize the PostgreSQL database with the provided SQL script to create a database, user, and "used\_categories" table. Run the first few nodes manually to test connections before activating the hourly schedule. An n8n instance, access to a WordPress site with REST API enabled, a PostgreSQL database, and an OpenAI API key. You can customize excluded WordPress categories, the AI models used (GPT-4.1-2025-04-14 or GPT-4.1-mini-2025-04-14), and the AI prompts for title and content generation to fit specific writing styles or SEO needs. Key Technologies: n8n,WordPress REST API,PostgreSQL,OpenAI GPT-4,Langchain,HTTP Requests Automation Value: Time Savings: Automates the entire blog post creation and publishing process, from content generation to image handling, freeing up significant time for content creators and marketers. Content Consistency: Ensures a steady flow of fresh, relevant content by automatically selecting the least-used categories and generating unique articles. Improved SEO: Uses AI to craft SEO-friendly titles and structured content, potentially boosting search engine rankings and organic traffic. Scalability: Easily scales content production without increasing manual effort, making it ideal for large websites or those with ambitious content strategies. Reduced Manual Errors: Minimizes human error in content formatting, image uploads, and database updates through automated processes.