---

name: ai-seo-content-engine description: 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. tags: [seo, content, blog, openai, gpt, hugo, saas, reviews, automation, n8n] author: mhmalvi version: 1.2.0 license: CC BY-NC-SA 4.0 metadata: clawdbot: emoji: "\u270D\uFE0F" requires: n8nCredentials: [google-sheets-oauth2, openai] env: [NICHE_BLOG_ADMIN_API_KEY] os: [linux, darwin, win32]

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

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

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

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

1. Affiliate marketing sites — Auto-generate SaaS review content with affiliate link placeholders
2. Niche blogs — Build organic SEO traffic with consistent publishing
3. SaaS comparison sites — Automated tool comparisons and best-of lists
4. Content agencies — Generate first drafts for human editors to refine
5. 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