A zero-touch Python automation pipeline that harvests educational quiz data, generates dynamic vertical video assets via Pillow and FFmpeg, loops audio tracks with Creative Commons attribution, auto-publishes to YouTube Shorts and Facebook Reels twice daily, and alerts status via Telegram.
Python 3.10+FFmpegPillow (PIL)YouTube Data API v3Facebook Graph APITelegram Bot APIGitHub ActionsBase64 OAuth Secrets
The Problem
The Friction of Short-Form Video Syndication
Short-form video platforms (YouTube Shorts, Facebook Reels) are key to brand discoverability, but maintaining a consistent posting cadence is incredibly labor-intensive. Creators spend hours daily editing layouts, lining up audio tracks, formatting descriptions, and manually uploading to each publisher dashboard. For quiz and educational content, this manual cycle is highly formulaic, making it a prime candidate for complete, zero-touch programmatic automation.
⌛
Repetitive Video Editing
Generating visual slides, aligning durations, importing audio, and exporting high-definition MP4 clips in the correct vertical aspect ratio (9:16) consumes hours of editor time.
🔑
Interactive OAuth in CI/CD
Cloud environments like GitHub Actions run headlessly, making it impossible to perform standard browser-redirect logins required to refresh Google/YouTube OAuth credentials.
📂
Content Sync Fragility
Older architectures (v1.0) split content across separate pools (`captions.json`, `descriptions.json`, `hashtags.json`). Random matching caused mismatched context and formatting bugs.
🛡️
Duplicate Upload Control
Uncoordinated retries or cron triggers run the risk of posting duplicate content, which triggers platform spam algorithms and compromises channel authority.