πŸ”„ 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