Overview
The Problem This Solves
Most SEO content workflows are disconnected:
- Keywords researched in one tool (SpyFu)
- Content optimization done in another (NeuronWriter)
- Writing done with AI via opencode (DeepSeek Flash V4 / Pro V4)
- Publishing done manually to WordPress
This pipeline connects all four into a single system driven by real data at every step.
The Four-Phase Pipeline
| Phase | Tool | Purpose |
|---|---|---|
| 1. Discover | SpyFu API | Find high-opportunity keywords with real search data (SV, KD, CPC, intent, SERP features) |
| 2. Optimize | NeuronWriter API | Analyze SERP competitors, extract terms per section, PAA questions, entities, content scores |
| 3. Generate | opencode (DeepSeek) | Write SEO-optimized content using structured prompts with reference terms |
| 4. Publish | wp-cli → WordPress | Automatically create drafts via wp-cli, then finalize in WordPress editor (images, admonitions, formatting) |
Pipeline CSV — Command Center
content-pipeline.csv is the single source of truth. Every keyword enters as a row and progresses through statuses:
Discovered → Researched → Briefed → Writing → Editing → Scheduled → Published
Each status corresponds to a pipeline phase and a required action.
Supported Sites
| Site | Status | Focus |
|---|---|---|
| fundamentalstock.com | Active — 361 published rows | Financial statements, ratios |
| opshell.dev | Starting — 2 pending rows | VPS hosting, DevOps |
| balancesheet.pro | NeuronWriter project exists | Not yet launched |
| metaxenith.com | NeuronWriter project exists | Not yet launched |