Auto WordPress Blog Generator (Community Unverified)
detail.loadingPreview
Automates WordPress blog post generation using GPT and PostgreSQL for category management.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automates the creation and publishing of WordPress blog posts. It leverages OpenAI's GPT models to generate content, uses a PostgreSQL database to track category usage and select the least-used category for new posts, and uploads generated images to the WordPress media library. The workflow is designed to be scheduled for continuous content generation.
Key Features
- Schedules regular blog post generation.
- Selects the least-used category from a PostgreSQL database.
- Generates unique, well-structured WordPress articles using GPT (including Table of Contents and Call to Actions).
- Creates and uploads cover images to WordPress.
- Publishes posts to WordPress and updates category usage in the database.
How To Use
- Set Environment Variable: Add
DOMAIN={{ $env.WEBHOOK_URL }}to your n8n environment. - Configure Credentials: Set up WordPress API, PostgreSQL, and OpenAI API credentials in n8n.
- Bootstrap PostgreSQL: Execute the provided SQL script to create the database, user, and
used_categoriestable. - Configure Nodes: Update node parameters, especially the
YOUR_WORDPRESS_CREDENTIALname in the WordPress-related nodes. - Test First Nodes: Run the initial nodes manually to verify connections and GPT responses.
- Enable Schedule Trigger: Once confirmed, activate the schedule trigger to automate the workflow.
Apps Used
Workflow JSON
{
"id": "9ced9bc3-c1ca-4a7d-bca0-0c8e94b3ed74",
"name": "Auto WordPress Blog Generator (Community Unverified)",
"nodes": 0,
"category": "Content Generation",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 9ced9bc3-c1ca...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Verification Info
Related Integrations
- Postgres + Schedule Trigger(39 workflows)
- Execute Workflow Trigger + Postgres(27 workflows)
- Split Out + WordPress(27 workflows)
- Schedule Trigger + WordPress(26 workflows)
- Google Sheets + WordPress(24 workflows)
- Postgres + Slack(17 workflows)
- Postgres + Postgres Tool(16 workflows)
- Execute Workflow Trigger + WordPress(16 workflows)
- Form Trigger + WordPress(16 workflows)
- Postgres + Supabase(16 workflows)
Related Workflows
Discover more workflows you might like
Community Contributed Blog Post Generator (Unverified)
Generates a blog post draft on WordPress from user-provided keywords, including a featured image, and prompts for user feedback.
Arabic Kids Story Generator
Automates the creation of illustrated and narrated Arabic stories for children.
Community Contributed: News to Podcast Script
Transforms news articles into engaging podcast scripts for LLM processing.
Transform Gmail Newsletters to LinkedIn Posts
Automate the extraction of key news items from Gmail newsletters and generate insightful LinkedIn posts using OpenAI.
General 3D Presentation
Generates a 3D presentation from a prompt, involving image generation and video creation.
Cocktail Recipe Sharing
Automatically generate and share cocktail recipes.