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.

Resources