🔄 CONTENT PIPELINE

From Data to Published

How new content flows from game data → DeepSeek → your website. Fully automated, always up-to-date.

📦 The 8-Step Content Pipeline

1
🔄

Daily Data Sync

Cron job fetches Wiki API every midnight. Detects changed values.

2
📋

Flag Affected Guides

Auto-marks guides with changed data as "Needs Update"

3
🤖

DeepSeek Generates

V4 Flash generates guide from structured data + template prompt

4

Self-Verify

2nd LLM call checks numbers vs source data. Flags errors.

5
🏷️

Auto-Tag

Adds version tag, SEO metadata, schema.org, categories

6
📄

Write HTML/MDX

Saves as .html file in pr-site/guides/ directory

7
📋

Update Index

Adds card to guides.html listing. Rebuilds sitemap.

8
🚀

Deploy Live

Vercel auto-deploys on git push. Site updated in <60s.

⚙️ How a New Guide Appears on the Site

Scenario: Game releases new character "Arlecchino"

# Step 1: Daily sync detects new character in Wiki API
$ python sync_wiki.py
[2026-06-17 00:00] New character detected: arlecchino
[2026-06-17 00:00] Fetching data… skills, ascension, weapons…

# Step 2: Pipeline generates the guide via DeepSeek
$ python generate.py --character arlecchino
[INFO] Building prompt with character data…
[INFO] Calling DeepSeek V4 Flash… (cost: ~$0.001)
[INFO] Generated 2,847 words

# Step 3: Self-verify numerical accuracy
[INFO] Verifying… 42/42 data points match ✓
[INFO] SEO metadata generated: title, desc, schema

# Step 4: Write file + update listings
$ python publish.py --character arlecchino
[INFO] Written: pr-site/guides/arlecchino.html
[INFO] Added card to pr-site/guides.html
[INFO] Sitemap updated. Committing to git…

# Step 5: Vercel auto-deploys on git push
[Vercel] Building… ✓
[Vercel] Deployed to genshinguide.pro ✓
[Vercel] New guide live at /guides/arlecchino.html

Total time: ~2 minutes. Cost: ~$0.001. Zero human intervention.

📊 Manual vs Automated

TaskManual (per guide)Automated (per guide)Saving
Research game data30 min (Wiki browsing)0 min (API fetch)100%
Write content45-90 min~10 sec (DeepSeek)99.8%
Verify accuracy15 min (manual)~5 sec (LLM self-check)99.4%
Add SEO metadata10 minIncluded in generation100%
Publish + list5 min0 min (auto)100%
Total105-150 min~2 min98.7%

🔔 What Triggers Content Generation?

🆕

New Character Release

Wiki API detects new character → auto-generates build guide + comparison pages + tier list update.

📦

Game Patch Drop

Daily sync detects version bump → flags all guides → regenerates affected guides in batch.

🔢

Data Value Change

Skill multiplier changed? → auto-flags that character's guide → regenerates within 24h.

📅

Weekly Refresh

Tier lists regenerated every Monday. Meta newsletter auto-compiled from patch notes.

🔧 Prototype vs Production

ComponentPrototype (current)Production (target)
Content sourceHand-written HTMLDeepSeek V4 Flash API
Data syncNot implementedCron job → Honey Impact API
New guide creationManual: write HTML + add to listingAuto: Python script generates + publishes
Version trackingManually tagged in HTMLAuto-detected from API, injected into frontmatter
DeployLocal files onlyGit push → Vercel auto-deploy
Listing updatesManually edit guides.htmlScript auto-appends card to listing

🚀 Production Stack (Next Step)

1
DeepSeek API
Content Pipeline
2
Wiki Data Sync
Cron Job
3
Next.js + Vercel
Auto Deploy
4
Lemon Squeezy
Pro Payments