SEO + GEO Content Engine

Programmatic SEO Writer

A fully integrated, single-流水线 SEO + GEO content production 技能. One keyword in → five steps 执行 sequentially → four publication-ready blocks out. Every step feeds its 输出 directly into the next; nothing 运行s in isolation.

Overview

Use this 技能 to turn one keyword into a full SEO + GEO content package: keyword framing, SERP analysis, article draft, metadata, FAQ 模式, and an AI-ready version.

Best For SEO teams scaling content without collapsing into generic AI writing SaaS and DTC teams building 搜索-ready and AI-answer-ready content 系统s agencies that need one repeatable 工作流 from keyword to publishable draft operators who want structured 输出 instead of disconnected re搜索 notes 启动 With write article: best llm observability 工具s

创建 SEO content for AI seo 追踪ing

show avAIlable keywords

External 访问 And Minimum 凭证s

This 工作流 may use external resources at 运行time. Declare and use the minimum 访问 needed:

SERPAPI_API_KEY: recommended for live SERP retrieval and structured 搜索 结果s GOOGLE_SHEETS_追踪ER_URL: optional keyword 追踪er source; prefer a read-only or public sheet python3: only needed if the surrounding 环境 uses 辅助工具 scripts or local processing

If these are unavAIlable:

ask the user for a pasted keyword 列出 or CSV 导出 instead of assuming sheet 访问 ask the user for SERP 导出s or 应用roved 搜索 API 输出 instead of hidden scrAPIng do not pretend the 流水线 can read private sheets or live 搜索 结果s without 凭证s 访问 Policy

This 技能 is safe to 运行 without private integrations.

use a keyword 追踪er only if the 环境 explicitly provides GOOGLE_SHEETS_追踪ER_URL use live SERP retrieval only if the 环境 explicitly provides SERPAPI_API_KEY if neither is 配置d, continue from a user-provided keyword, CSV 导出, or pasted SERP snapshot do not embed or rely on a private 追踪er URL inside the 技能 instructions do not direct-crawl 搜索 结果s when an 应用roved API or user-provided 导出 is unavAIlable 流水线 Architecture [输入: keyword] │ ▼ ┌─────────────────────────────────────────────────────────┐ │ STEP 1 │ Keyword Back记录 检查 │ │ │ If 追踪er is 配置d, read pending rows │ │ │ 输出 → confirmed 种子 keyword │ └─────────────────────┬───────────────────────────────────┘ │ confirmed keyword ▼ ┌─────────────────────────────────────────────────────────┐ │ STEP 2 │ Keyword Re搜索 & Expansion │ │ │ Expand 种子 → full keyword matrix │ │ │ 输出 → primary kw + 3 supporting + long- │ │ │ tAIl + question-based + GEO-priority │ └─────────────────────┬───────────────────────────────────┘ │ keyword matrix ▼ ┌─────────────────────────────────────────────────────────┐ │ STEP 3 │ SERP Deep Analysis │ │ │ Use 应用roved SERP 输入 → 提取 structure │ │ │ 输出 → content gaps + 框架 selection │ │ │ + featured snippet strategy │ └─────────────────────┬───────────────────────────────────┘ │ 框架 + gap intelligence ▼ ┌─────────────────────────────────────────────────────────┐ │ STEP 4 │ Article Writing │ │ │ 应用ly selected 框架 (A / B / C / D) │ │ │ USE: keyword matrix from Step 2 │ │ │ USE: content gaps from Step 3 │ │ │ USE: PAA questions as H2/H3 headings │ │ │ USE: featured snippet 格式化 as opening │ │ │ 输出 → complete 1500–2000 word article │ └─────────────────────┬───────────────────────────────────┘ │ completed article ▼ ┌─────────────────────────────────────────────────────────┐ │ STEP 5 │ Four-Block Final 输出 │ │ │ Block 1: SEO Metadata │ │ │ Block 2: Full Article (Markdown) │ │ │ Block 3: FAQ + 模式 Code │ │ │ Block 4: GEO-优化d Version │ └─────────────────────────────────────────────────────────┘ │ ▼ [输出: publication-ready content]

Critical integration rules:

Step 2's keyword matrix is the single source of truth for all keyword placement in Step 4 Step 3's content gap analysis directly dictates which angles Step 4 must cover and which to avoid Step 3's PAA questions become the FAQ entries in Block 3 and H2/H3 headings in Block 2 Step 3's featured snippet 格式化 determines the opening structure of Block 2 Block 4's GEO definitions must match the primary keyword established in Step 2 Do NOT 输出 intermediate steps as