Auto WordPress Blog Generator

This workflow is ideal for:

• Bloggers looking to automate their content creation process, saving time and effort in writing posts.
• Content marketers who want to generate unique articles regularly to engage their audience and improve SEO.
• Website administrators managing WordPress sites who need a streamlined method to publish content consistently.
• Small business owners who may not have the resources to hire content creators but want to maintain an active online presence.
• Developers interested in integrating AI and automation into their projects to enhance functionality and efficiency.

This workflow addresses the challenge of content creation for WordPress blogs by:

• Automating the generation of unique articles using AI, ensuring consistent and high-quality content.
• Streamlining the process of selecting categories and titles, thus reducing the time spent on planning and organization.
• Integrating with PostgreSQL to track category usage, allowing for strategic content planning based on past performance.
• Simplifying image handling by automatically downloading and uploading cover images, enhancing the visual appeal of posts.

1. Schedule Trigger: Initiates the workflow at specified intervals, ensuring regular content generation.
2. Load Categories: Fetches all WordPress categories to identify available topics for articles.
3. Category Filter: Excludes specific categories that are not suitable for AI-generated content.
4. Selecting Recent: Queries the PostgreSQL database to find the least recently used categories, optimizing content diversity.
5. Picks Less Used: Chooses the least-used category for the next post based on the filtered categories and usage data.
6. 10 Latest Headlines: Retrieves the latest article titles from the selected category to avoid duplication.
7. AI Agent SEO Headings: Generates a new, unique article title based on the selected category and existing titles.
8. AI Agent SEO Writer: Produces a full blog post using a structured format, ensuring it meets WordPress HTML standards.
9. Placeholder Creator: Creates a placeholder image URL for the article.
10. Download Image: Downloads the cover image based on the generated title.
11. Media Upload to WP: Uploads the downloaded image to the WordPress media library.
12. Prepare Post JSON: Assembles all necessary data for the WordPress post, including title, content, and media.
13. Post to WP: Publishes the completed article to the WordPress site.
14. Updating Posts DB: Updates the PostgreSQL database with the new article's details to track category usage and ensure future content is diverse.