Work & OperationsDone with Claude Code
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.
- 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.
Do this with a skill.
These SkillShop playbooks do this exact job.