Ai Seo Content Engine

Automated SEO content generator that schedules daily SaaS review articles using OpenAI GPT-4o, publishes to a Hugo blog via API, and tracks output in Google Sheets. Supports 18 SaaS categories and 4 content types.

Muhammad H.M. Alvi@mhmalvi

Install

openclaw skills install @mhmalvi/ai-seo-content-engine

SEO Content Engine

An automated content generation pipeline that produces SEO-optimized SaaS review articles on a schedule, publishes to a Hugo blog, and tracks everything in Google Sheets.

Problem

Building organic search traffic requires consistent, high-quality content. Manually researching, writing, and publishing SEO articles is time-consuming. Most SaaS review sites need 2-4 articles per week to compete — that's hours of work daily.

This engine automates the entire pipeline: topic selection, article generation, blog publishing, and tracking.

What It Does

Topic Selection — Randomly selects from 18 SaaS tools and 4 content types (reviews, comparisons, best-of guides, how-to guides)
AI Article Generation — Uses OpenAI GPT-4o to write 1,500-2,500 word SEO articles with proper headings, pros/cons, pricing, and recommendations
Hugo Formatting — Adds frontmatter (title, date, categories, tags, affiliate links) for Hugo static site publishing
Blog Publishing — Pushes the formatted post to a Hugo blog via admin API
Sheet Tracking — Logs every published article (slug, date, category, tool, status) in Google Sheets
Owner Notification — Sends email alert when a new article is published for review

Included Workflows

#	File	Purpose
1	`content-gen-workflow.json`	Scheduled content generation, publishing, tracking, and notification

Architecture

text

Schedule Trigger (every 12 hours)
    |
    v
Keyword & Topic Selector
    |  (random SaaS tool + content type)
    v
OpenAI GPT-4o Article Generator
    |  (1500-2500 word SEO article)
    v
Hugo Post Formatter
    |  (add frontmatter, categories, tags)
    v
Publish to Blog (Admin API)
    |
    +------+------+
    |             |
    v             v
Track in       Notify Owner
Google Sheets  (email alert)

Supported Content Types

Type	Template Example
Review	`{Tool} Review 2026: Pricing, Features, and Honest Take`
Comparison	`{Tool A} vs {Tool B}: Which Is Better in 2026?`
Best-of	`Best {Category} Tools for {Audience} in 2026`
Guide	`How to Set Up {Tool} for {Use Case}`

Supported SaaS Categories

CRM, Project Management, Email Marketing, Automation, Database, Communication, Issue Tracking, Hosting, CDN & Security, Backend, Payments — covering 18 tools including HubSpot, Notion, Pipedrive, ClickUp, ConvertKit, Zapier, Make, n8n, Airtable, Supabase, Stripe, and more.

Required n8n Credentials

Credential Type	Used For	Placeholder in JSON
OpenAI	GPT-4o article generation	`YOUR_OPENAI_CREDENTIAL_ID`
Google Sheets OAuth2	Article tracking	`YOUR_GOOGLE_SHEETS_CREDENTIAL_ID`

Configuration Placeholders

Placeholder	Description
`YOUR_OPENAI_CREDENTIAL_ID`	Your n8n OpenAI credential ID
`YOUR_GOOGLE_SHEETS_CREDENTIAL_ID`	Your n8n Google Sheets credential ID
`YOUR_BLOG_ADMIN_API_KEY`	API key for your blog admin API
`YOUR_TRACKER_SHEET_ID`	Google Sheet ID for tracking published articles
`YOUR_NOTIFICATION_EMAIL`	Email for publish notifications
`YOUR_SMTP_CREDENTIAL_ID`	Your n8n SMTP credential ID

Quick Start

1. Prerequisites

n8n v2.4+ (self-hosted)
OpenAI API key (GPT-4o access)
Hugo blog with an admin API (e.g., blog-admin service)
Google Sheets OAuth2 credentials

2. Environment Variables

bash

NICHE_BLOG_ADMIN_API_KEY=your-blog-admin-api-key

3. Create Tracking Sheet

Set up a Google Sheet with columns: slug, source, date, category, tool, status. Use appendOrUpdate matching on slug + source to prevent duplicates.

4. Import & Configure

Import the workflow JSON into n8n. Replace all YOUR_* placeholders. Connect your OpenAI and Google Sheets credentials.

5. Activate

Activate the workflow. It runs every 12 hours by default — adjust the schedule trigger as needed.

Companion Skills

For cross-posting generated articles to LinkedIn, Dev.to, Hashnode, and other platforms, see the multi-platform-crosspost skill.

Use Cases

Affiliate marketing sites — Auto-generate SaaS review content with affiliate link placeholders
Niche blogs — Build organic SEO traffic with consistent publishing
SaaS comparison sites — Automated tool comparisons and best-of lists
Content agencies — Generate first drafts for human editors to refine
Personal blogs — Keep publishing cadence without daily writing

Customization

Tools list — Edit the Code node to add/remove SaaS tools and categories
Content quality — Adjust the system prompt and temperature for different tones
Schedule — Change trigger frequency (daily, twice daily, weekly)
Blog API — Modify the HTTP Request node for any blog admin API
Affiliate links — Add affiliate URLs in the frontmatter affiliate_links field

Requirements

n8n v2.4+ (self-hosted recommended)
OpenAI API account (GPT-4o, ~$0.01-0.03 per article)
Hugo blog with admin API endpoint
Google Sheets OAuth2 credentials