Case StudyScalabilityAutomation
Case Study: Managing 24 YouTube Channels without Chaos
2026-01-10•Yash Rawat
The Problem: Managing 24 separate YouTube channels manually is an operations nightmare. Authentication, analytics aggregation, and content updates took 2.5 hours/day.
The "OAuth Hell" Solution
The biggest technical hurdle wasn't the data; it was managing 24 distinct OAuth2 refresh token lifecycles securely. I built a custom "Environment Array" architecture to rotate credentials dynamically.
Architecture Highlights
- Quota Engineering: Implemented local "Quota Tracking" to predict API costs before execution (e.g., updating 100 video titles = 5,000 units), preventing service bans.
- Atomic Batching: Used Firestore transactions to ensure data consistency across thousands of video records.
- Serverless Sync: Deployed Vercel functions to act as a "Daemon," syncing analytics every night at 12:00 UTC automatically.