Build YouTube analytics reports and lead outreach with Claude Code
Claude Code pulled YouTube analytics via API into a verified Excel file, built a job-tracking app, and found and enriched sales leads with outreach.
Done withClaude Code
- What they did
- Each task started from a plain-English goal set with a slash goal prompt, so Claude Code kept looping until done. For analytics, it read a markdown file describing the channel, pulled data through the YouTube API with a script, built a multi-tab Excel workbook, and screenshotted it to check formatting. It also built a local HTML job-tracking app and a 50-lead enrichment sheet with drafted outreach emails.
- How it went
- The demo reports the quarterly analytics report took about 10 minutes, and the 50-lead enrichment and outreach about 20. Claude Code flagged missing impressions and CTR data in the analytics. The source gives no accuracy figures for the leads or emails.
- Worth knowing
- Claude Code works from local files, so notes on your business, case studies and target customer profile improve the outreach. The source describes demos, not results from real campaigns.
Try it yourself with Claude Code
Pull [metrics, e.g. views, watch time, subscribers] for [my channel or account] over [date range] using the [API name] API and build an Excel report with a summary tab and charts. Double-check the totals against the source and tell me how you verified them. I'll provide API credentials in [file]; don't send any messages or emails to anyone.
Source: mindstudio.ai · Undated
Five of these in your inbox every morning
The best things people got an AI agent to do, each with the prompt to try it.
More like this
Turn tickets into merged pull requests
Pulls tasks from GitHub Issues or Linear, then runs Claude Code or Codex in isolated Kubernetes pods to carry each one through to a PR.
Run content research and sponsor outreach with Claude computer use
The author tested Claude computer use in Cowork and Claude Code over two days on six workflows including research, sponsor outreach and product listings.
Build a 2D platformer game without coding
A content creator with no coding experience used Claude Code to build a black-and-white wave-combat platformer in HTML canvas and played it live.
- GitHub Copilot
Run a solo company with eight agent departments
A founder set up CEO, CFO, COO, lawyer, accountant, marketing, CTO, and improver agents that share memory and consult each other.
Turn trip receipts into an expense report and triage files
The author used Cowork to build an expense report from 47 receipts, pick what to read from 4,992 files and make slide decks via Gamma.
Turn email invoices into a live financial dashboard
An n8n workflow scans emailed invoices, extracts supplier, amount, date and description, and feeds a real-time Google Sheets dashboard.