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...

Security Scan

The skill's requests and runtime instructions are consistent with an automated SEO content generator that publishes to a Hugo blog and tracks posts in Google Sheets.

Purpose & Capability

The skill claims to generate SEO articles, publish them to a Hugo blog, and log them to Google Sheets; the only required environment variable (NICHE_BLOG_ADMIN_API_KEY) and the declared n8n credentials (OpenAI and Google Sheets OAuth2) align with that purpose. Placeholders for SMTP and other optional credentials are reasonable for notification features. The inclusion of affiliate placeholders is consistent with the stated affiliate/monetization use case.

Instruction Scope

SKILL.md and the included n8n workflow instruct the agent to: pick topics, call OpenAI (gpt-4o) to generate 1.5k–2.5k word articles, wrap the article with Hugo frontmatter (the system prompt instructs the model not to emit frontmatter, and the workflow adds it — this is coherent), POST the post to a blog admin API, append a row to Google Sheets, and send an email notification. There are no instructions to read arbitrary local files or unrelated environment variables. Note: the HTTP request uses a template URL (http://YOUR_BLOG_ADMIN_HOST:3000/api/posts) — if left misconfigured this could send the API key to an unintended endpoint and it uses http in the template (not https), so the user must configure a secure host. Also be aware this workflow automatically publishes content on a schedule — you should ensure editorial review or use draft mode if you do not want fully autonomous publishing.

Install Mechanism

This is an instruction-only skill with no install spec and no code files to write to disk. That minimizes installation risk; the only runtime artifact is the provided n8n workflow JSON which is intended to be imported into n8n.

Credentials

Required secrets are proportional: NICHE_BLOG_ADMIN_API_KEY for the blog admin API, OpenAI credential for article generation, and Google Sheets OAuth2 for tracking. No unrelated credentials or system config paths are requested. Recommendation: limit the blog admin API key's permissions (publish access only to a specific site or endpoint) and keep it scoped and rotated as appropriate.

Persistence & Privilege

always: false and normal autonomous invocation are used. The skill does not request permanent platform-wide privileges, does not attempt to modify other skills, and contains no install actions that change system-wide settings.

Assessment

This skill appears to do what it says (auto-generate articles, publish to your Hugo blog, and log them). Before enabling it live: 1) Test the workflow in a staging site or set posts to draft so you can review content before public publishing. 2) Ensure the NICHE_BLOG_ADMIN_API_KEY you provide is scoped minimally (only the endpoint/site needed) and is sent to a correctly configured, HTTPS blog-admin host (replace the http:// placeholder). 3) Be aware of costs and quotas for OpenAI (GPT-4o) and review generated content for accuracy, legal/affiliate disclosure compliance, and policy violations. 4) If you want human review, adjust the workflow to create drafts or route items to an editor email instead of publishing automatically. 5) Monitor the first runs and rotate keys if anything is misconfigured or if you detect unexpected endpoints receiving requests.

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