SEO Content Machine · AI Automation Society

SEO Content Machine

I Built a 7-Workflow SEO Content Machine (Topic → Published Blog in 24 Hours)

Spent about 1 day building something I've wanted for a while, a fully automated content pipeline that takes a topic idea and turns it into a published, SEO-optimized blog post with a custom AI image.

I know there have been similar projects before, but I really wanted to use NeuronWriter for the SEO optimization.

Here's the breakdown:

What It Actually Does

Input: I type "API cost management for agencies" into a database field and check a box.

Output: 5-8 fully written articles scheduled to publish one per day at 9 AM, each with:

SEO-optimized title and meta description
1,500-2,000 words hitting all the right keywords
Custom AI-generated featured image
Auto-assigned category
Internal links to my existing content

My only job: Review each article in NeuronWriter (5-10 min), make edits if needed, click "Done." The system handles the rest. At some point, I may make it fully automated. But I am a control freak.

The 7 Workflows

1️⃣ Keyword Strategy Generation

Pulls 150+ keywords from DataForSEO
GPT-4.1mini analyzes search intent, competition, clusters
Outputs 5-8 article recommendations with priority scores

2️⃣ SEO Brief Creation

Creates NeuronWriter queries for each article
Pulls competitor analysis, word count targets, must-use terms
Saves brief to database

3️⃣ Draft Generation

GPT-4.1mini writes the full article following my brand voice
Includes internal links from my content inventory
Converts to HTML, submits to NeuronWriter for scoring

4️⃣ Image Generation

Analyzes article content
Picks optimal image style (diagram, illustration, data viz)
Generates via fal.ai, uploads to HighLevel media library

5️⃣ Human Review Notification

Discord ping + email
Includes NeuronWriter link, SEO score, quick stats

6️⃣ Approval Sync

Polls NeuronWriter every 10 min for "Done" tag
Fetches final edited content
Updates database status → Approved

7️⃣ Publish to HighLevel

Triggers on Approved status
Smart scheduling (1 post/day, 9 AM CST, finds next open slot)
Auto-categorizes with GPT-4o-mini
Creates scheduled post in CMS

Tech Stack

n8n (self-hosted)
Database: NocoDB (self-hosted)
Keyword Research: DataForSEO API
SEO + Editing: NeuronWriter (Purchased LTD years ago)
Content Generation: GPT-4o Category Matching GPT-4o-mini
Image Generation: fal.ai (Nano Banana)
CMS: HighLevel
Notifications: Discord + Gmail

The Parts That Took Forever to Figure Out:

NeuronWriter API quirks — Their /import-content endpoint wants the title as a separate field, not in the HTML body. Took an embarrassing amount of time to realize the H1 was duplicating.

HighLevel image uploads — Needs multipart form-data with hosted: true and parentId (not folderId). Their API docs are... sparse.

Smart scheduling logic — Had to query existing scheduled posts, find gaps, calculate next available 9 AM slot. Simple concept, annoying implementation.

HTML conversion — Markdown bullet lists were rendering with double spacing. Built a custom converter to handle edge cases.

ROI Reality Check:

Setup time: ~8-10 hours

Per article time (before): 3-4 hours (research, write, edit, format, publish)

Per article time (now): 10-15 minutes (review + light edits)

At 5 articles/week, I'm saving 15+ hours weekly. System pays for itself in week one.

Questions?

Happy to go deeper on any part of this. The n8n workflows are complex but not complicated — just a lot of steps.

What content workflows are you all building?

20 comments