YouTube Transcript Vault — Automated Daily Pipeline

Automated system that transcribes 59 monitored YouTube channels daily, stores results locally, mirrors to VPS3, and posts new transcripts to Discord.

Infrastructure

| Component | Location | |-----------|----------| | Pipeline script | D:\Ecosystem\ops\scripts\yt-daily-pipeline.py | | VPS3 mirror | /root/scripts/yt-daily-pipeline.py | | GitHub Actions backup | github.com/mmerlino23/yt-living-pipeline | | Transcript vault | D:\Ecosystem\youtube-transcripts\ | | Channel registry | D:\Ecosystem\youtube-transcripts\_channels.json |

Schedule

| Run | Schedule | Host | |-----|----------|------| | Primary | 07:00 UTC daily | VPS3 cron | | Backup | 12:00 UTC daily | GitHub Actions | | Local mirror | 22:00 local | Windows Task Scheduler YTVaultSync |

Required Env Vars

Load from D:\Ecosystem\secrets\MASTER_API_KEYS.env:

• YOUTUBE_API_KEY — YouTube Data API v3
• DISCORD_BOT_TOKEN_OLIVER — Discord posting
• DISCORD_CHANNEL_YT_TRANSCRIPTS — 1484579049933115447
• VAULT_PATH — D:\Ecosystem\youtube-transcripts (Windows) or /root/yt-transcripts (VPS3)

Manual Invocation

# Dry run — no writes, no Discord post
python D:\Ecosystem\ops\scripts\yt-daily-pipeline.py --dry-run

# Single channel
python D:\Ecosystem\ops\scripts\yt-daily-pipeline.py --channel indydevdan

# Full run (requires env vars)
python D:\Ecosystem\ops\scripts\yt-daily-pipeline.py

Channel Registry

59 channels tracked in _channels.json. Each entry has: YouTube handle, youtube_channel_id (resolved via YouTube Data API on first run), and SOP site mapping.

| Channel Slug | Repo | Site | |---|---|---| | indydevdan | mmerlino23/tac-sop | https://tac-sop.vercel.app | | corbin | mmerlino23/anthropic-academy-sops | VitePress | | creatify | mmerlino23/creatify-ai-docs | VitePress |

Tool: yt

Local transcript tool at D:\ClaudeDev\00_GITHUB\Tools\youtube-social\yt.

# Single video
yt <video-url>

# Whole channel
yt --channel <handle>

Registry: D:\Ecosystem\youtube-transcripts\_REGISTRY.json

Transcript Storage Format

D:\Ecosystem\youtube-transcripts\
  _REGISTRY.json
  _channels.json
  <channel-handle>\
    <video-id>_<date>.txt
    <video-id>_<date>.txt

Use in Video Production

Transcripts from this vault feed:

• Script research — pull transcripts from reference channels before writing
• Hook analysis — study first 30 seconds of top-performing videos
• Keyword extraction — find natural language patterns for YouTube SEO

Related Topics

• [[ytdlp-agent]] — on-demand YouTube download and transcript CLI
• [[youtube-fetch]] — lightweight YouTube metadata sub-skill
• [[social-transcript-extractor]] — transcripts from non-YouTube platforms
• [[long-form-video-seo-2026]] — how to use transcripts for SEO

#video-sop #youtube #transcript #automation #vault #cron