Auto WordPress Blog Generator (GPT + Postgres + WP Media)

Auto WordPress Blog Generator automates the creation of unique blog posts on your WordPress site. It generates content using GPT, selects the least-used categories, and uploads images, all on a scheduled basis. This workflow enhances productivity by streamlining blog management, ensuring fresh content is published regularly without manual effort.

7/8/2025
46 nodes
Complex
k8hqq1bbcqoesjjjschedulecomplexschedule triggerlangchainsticky notepostgresqlnoopautomationadvancedcronapiintegrationdatabasedata
Categories:
Schedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
Schedule TriggerLangChainSticky NotePostgreSQLNoOp

Target Audience

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.

Problem Solved

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.

Workflow Steps

  • 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.

    • Customization Guide

    Users can customize this workflow by:
    - Modifying the Schedule Trigger: Adjust the frequency of content generation by changing the interval settings.
    - Updating the Category Filter: Change the excluded category IDs to fit the specific needs of your blog.
    - Altering the AI Prompts: Customize the prompts used in the AI Agent nodes to better reflect your blog's voice and target audience.
    - Changing the Placeholder Image: Update the Placeholder creator code to use a different image service or style for cover images.
    - Integrating with Additional APIs: Expand the workflow by adding nodes for social media sharing or email notifications upon new post publication.