Build a podcast analytics pipeline and dashboard

A first-time Claude Code user combined YouTube’s 3 APIs, Spotify for Creators and Open Podcast in one dashboard.

by Aaron Orendorff29 Sep 2026

Prompt for your agent

Goal: Build a data pipeline and content analytics dashboard for my shows.
Setup: agents used in source: Claude; tools/MCPs stated: YouTube APIs, Spotify for Creators, Open Podcast.
Steps:
1. Pull YouTube’s 3 APIs for each show’s channel.
2. Pull Spotify for Creators data for all shows.
3. Use Open Podcast’s free connector.
4. Combine everything into one dashboard.
Rules: ask me before anything irreversible (sending, posting, paying, deleting); don’t invent data, results or tools I haven’t given you; tell me what you couldn’t verify.
Based on: Aaron Orendorff — https://x.com/AaronOrendorff/status/2105005028834718067

Steps are from the source. Includes a “Based on” credit line.

I tried this

Tell the next builder. One anonymous answer each; click again to undo.

Agents, models and tools only what the source states

Agents
Claude
Tools
  • YouTube APIs
  • Spotify for Creators
  • Open Podcast

Sources & credit