I have never made anything real in Claude Code before. Over the weekend, I made
By Aaronorendorff · October 1, 2026 · Curated by George's Blog
I have never made anything real in Claude Code before. Over the weekend, I made this ↓
Operators Data Pipeline & Content Analytics Dashboard
- YouTube’s 3 APIs
for each show’s channel
- Spotify for Creators API
(unofficial) all shows too
- Used Open Podcast’s
free connector GraphQL
- Pulled it all into BigQuery
using Google Cloud
- Data stored & mapped
metrics + some formulas
- 4 daily automations
for APIs to refresh it
- 14 QA checks with
6 Google Cloud alerts
- Slack notifications
if something fails
- Made an artifact first
to test the reports
- Then I built the website
in Next.js using Vercel
- 9operators subdomain
Set up through GoDaddy
- GitHub repos (first time)
docs generate Notion page
- Hosted it and launched it
password-protected preload
- Told Claude Code to
make a local site version
- Styled everything quickly
by giving it our design guide
- Spoke 90% of prompts
using Wispr (amazing)
- Added Operators favicon
little icon for webpages
- Share previews elements
like title, meta, social image
- Hover to reveal all data points
easy to use on mobile also
- 39 analytics tables
19 different report types
- Dropdown selectors
lots of display options
- 1.27M hours consumed
with 24.9M views + listens
- Spread across 36.4M cells
another 610k added per day
- Exhaustive episode key
transcripts from the Portal
- Pulling in thumbnails
to learn more, test faster
- Might try social data
if it’s not too expensive
- Just getting started
now prompting for insights
Admittedly, I have been smashing my face trying to get unified and clean data for months. That manual process taught me so, so, so freaking much about YouTube, podcasts, and organic-social analytics.
But I could never get it to work.
Last weekend I finally said …
F*** it. Let’s do it. And it worked.
We live in incredible times for anyone brave enough to just do s***