Auto WordPress Blog Generator (Community Unverified)

Name: Auto WordPress Blog Generator (Community Unverified)
Rating: 1.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

50 views

0 downloads

Content Generationautomationbloggingcontent-creationgptopenaipostgreswordpress

Automates WordPress blog post generation using GPT and PostgreSQL for category management.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

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_categories table.
Configure Nodes: Update node parameters, especially the YOUR_WORDPRESS_CREDENTIAL name 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

automation

blogging

content-creation

gpt

openai

postgres

wordpress

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.