WordPress Blog Auto-Generation (GPT + Postgres)

Inside this workflow

Overview

Scheduled automation generates blog post ideas from a database, writes full content with GPT-4, saves drafts to WordPress, stores metadata in PostgreSQL, and publishes on schedule. Maintains consistent publishing cadence for content teams. Nodes & apps: Schedule trigger, HTTP requests, PostgreSQL driver, Code node for logic, Merge for data combination, WordPress API for publishing. Credentials needed: 1. PostgreSQL connection string 2. OpenAI API key 3. WordPress API credentials Setup steps: 1. Set up PostgreSQL database with post ideas schema 2. Configure schedule trigger (e.g., daily) 3. Add OpenAI credentials for writing 4. Connect WordPress API for publishing 5. Configure post metadata schema in PostgreSQL 6. Set up drafting vs. publishing workflow 7. Test with sample idea 8. Deploy to production Difficulty: High | Setup time: 25 minutes | Price: $45 | Nodes: 46 | Source: Zie619/n8n-workflows

What's included

Quickstart

1. 01

   Download the JSON

   With an active Library Pass, download the workflow file right from this page or your dashboard.

2. 02

   Import into n8n

   Choose Import from File and select the downloaded JSON. The full agent graph appears, ready to configure.

3. 03

   Plug in credentials

   Each integration node prompts for credentials on first run. The setup guide lists every credential the agent expects.

4. 04

   Activate and test

   Run once with sample input, confirm the expected output, then flip the activate toggle.

Sign in to leave a review.