{"skill":{"slug":"ai-seo-content-engine","displayName":"Ai Seo Content Engine","summary":"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...","description":"---\nname: ai-seo-content-engine\ndescription: 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.\ntags: [seo, content, blog, openai, gpt, hugo, saas, reviews, automation, n8n]\nauthor: mhmalvi\nversion: 1.2.0\nlicense: CC BY-NC-SA 4.0\nmetadata:\n  clawdbot:\n    emoji: \"\\u270D\\uFE0F\"\n    requires:\n      n8nCredentials: [google-sheets-oauth2, openai]\n      env: [NICHE_BLOG_ADMIN_API_KEY]\n    os: [linux, darwin, win32]\n---\n\n# SEO Content Engine\n\nAn 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.\n\n## Problem\n\nBuilding 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.\n\nThis engine automates the entire pipeline: topic selection, article generation, blog publishing, and tracking.\n\n## What It Does\n\n1. **Topic Selection** — Randomly selects from 18 SaaS tools and 4 content types (reviews, comparisons, best-of guides, how-to guides)\n2. **AI Article Generation** — Uses OpenAI GPT-4o to write 1,500-2,500 word SEO articles with proper headings, pros/cons, pricing, and recommendations\n3. **Hugo Formatting** — Adds frontmatter (title, date, categories, tags, affiliate links) for Hugo static site publishing\n4. **Blog Publishing** — Pushes the formatted post to a Hugo blog via admin API\n5. **Sheet Tracking** — Logs every published article (slug, date, category, tool, status) in Google Sheets\n6. **Owner Notification** — Sends email alert when a new article is published for review\n\n## Included Workflows\n\n| # | File | Purpose |\n|---|------|---------|\n| 1 | `content-gen-workflow.json` | Scheduled content generation, publishing, tracking, and notification |\n\n## Architecture\n\n```\nSchedule Trigger (every 12 hours)\n    |\n    v\nKeyword & Topic Selector\n    |  (random SaaS tool + content type)\n    v\nOpenAI GPT-4o Article Generator\n    |  (1500-2500 word SEO article)\n    v\nHugo Post Formatter\n    |  (add frontmatter, categories, tags)\n    v\nPublish to Blog (Admin API)\n    |\n    +------+------+\n    |             |\n    v             v\nTrack in       Notify Owner\nGoogle Sheets  (email alert)\n```\n\n## Supported Content Types\n\n| Type | Template Example |\n|------|-----------------|\n| Review | `{Tool} Review 2026: Pricing, Features, and Honest Take` |\n| Comparison | `{Tool A} vs {Tool B}: Which Is Better in 2026?` |\n| Best-of | `Best {Category} Tools for {Audience} in 2026` |\n| Guide | `How to Set Up {Tool} for {Use Case}` |\n\n## Supported SaaS Categories\n\nCRM, 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.\n\n## Required n8n Credentials\n\n| Credential Type | Used For | Placeholder in JSON |\n|----------------|----------|---------------------|\n| OpenAI | GPT-4o article generation | `YOUR_OPENAI_CREDENTIAL_ID` |\n| Google Sheets OAuth2 | Article tracking | `YOUR_GOOGLE_SHEETS_CREDENTIAL_ID` |\n\n## Configuration Placeholders\n\n| Placeholder | Description |\n|-------------|-------------|\n| `YOUR_OPENAI_CREDENTIAL_ID` | Your n8n OpenAI credential ID |\n| `YOUR_GOOGLE_SHEETS_CREDENTIAL_ID` | Your n8n Google Sheets credential ID |\n| `YOUR_BLOG_ADMIN_API_KEY` | API key for your blog admin API |\n| `YOUR_TRACKER_SHEET_ID` | Google Sheet ID for tracking published articles |\n| `YOUR_NOTIFICATION_EMAIL` | Email for publish notifications |\n| `YOUR_SMTP_CREDENTIAL_ID` | Your n8n SMTP credential ID |\n\n## Quick Start\n\n### 1. Prerequisites\n- n8n v2.4+ (self-hosted)\n- OpenAI API key (GPT-4o access)\n- Hugo blog with an admin API (e.g., blog-admin service)\n- Google Sheets OAuth2 credentials\n\n### 2. Environment Variables\n```bash\nNICHE_BLOG_ADMIN_API_KEY=your-blog-admin-api-key\n```\n\n### 3. Create Tracking Sheet\nSet up a Google Sheet with columns: `slug`, `source`, `date`, `category`, `tool`, `status`. Use `appendOrUpdate` matching on `slug` + `source` to prevent duplicates.\n\n### 4. Import & Configure\nImport the workflow JSON into n8n. Replace all `YOUR_*` placeholders. Connect your OpenAI and Google Sheets credentials.\n\n### 5. Activate\nActivate the workflow. It runs every 12 hours by default — adjust the schedule trigger as needed.\n\n## Companion Skills\n\nFor cross-posting generated articles to LinkedIn, Dev.to, Hashnode, and other platforms, see the **multi-platform-crosspost** skill.\n\n## Use Cases\n\n1. **Affiliate marketing sites** — Auto-generate SaaS review content with affiliate link placeholders\n2. **Niche blogs** — Build organic SEO traffic with consistent publishing\n3. **SaaS comparison sites** — Automated tool comparisons and best-of lists\n4. **Content agencies** — Generate first drafts for human editors to refine\n5. **Personal blogs** — Keep publishing cadence without daily writing\n\n## Customization\n\n- **Tools list** — Edit the Code node to add/remove SaaS tools and categories\n- **Content quality** — Adjust the system prompt and temperature for different tones\n- **Schedule** — Change trigger frequency (daily, twice daily, weekly)\n- **Blog API** — Modify the HTTP Request node for any blog admin API\n- **Affiliate links** — Add affiliate URLs in the frontmatter `affiliate_links` field\n\n## Requirements\n\n- n8n v2.4+ (self-hosted recommended)\n- OpenAI API account (GPT-4o, ~$0.01-0.03 per article)\n- Hugo blog with admin API endpoint\n- Google Sheets OAuth2 credentials\n","tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":787,"installsAllTime":2,"installsCurrent":2,"stars":0,"versions":1},"createdAt":1772557181782,"updatedAt":1779077609117},"latestVersion":{"version":"1.0.0","createdAt":1772557181782,"changelog":"Initial release: AI-powered SEO content generator with OpenAI GPT-4o","license":null},"metadata":{"setup":[{"key":"NICHE_BLOG_ADMIN_API_KEY","required":true}],"os":["linux","darwin","win32"],"systems":null},"owner":{"handle":"mhmalvi","userId":"s17ckmpx5rg8a7zpj559th6fj5884s1w","displayName":"Muhammad H.M. Alvi","image":"https://avatars.githubusercontent.com/u/74125579?v=4"},"moderation":{"isSuspicious":false,"isMalwareBlocked":false,"verdict":"clean","reasonCodes":["review.llm_review"],"summary":"Review: review.llm_review","engineVersion":"v2.4.24","updatedAt":1780089744832}}