Build a free YouTube analytics pipeline in BigQuery with Claude Code
Watch Claude Code turn one structured prompt into a daily YouTube analytics pipeline on the Google Cloud free tier.
Who it's for: Google Cloud and BigQuery users, and YouTubers who want deeper analytics than YouTube Studio shows.
The problem: YouTube Studio only shows current totals, so you cannot compare a video's first week with its second.
One structured prompt has Claude Code build a Cloud Function that calls the YouTube Data API and YouTube Analytics API daily and writes snapshots to four BigQuery tables. It runs for $0 on the free tier, and a backfill loaded 125 days of history.
Takeaways:
- The Analytics API needs OAuth 2 for watch time and traffic sources.
- A detailed prompt can save hours of debugging.
- Have Claude Code run your SQL checks through the BigQuery CLI.