Skip to content
agentusehub

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.

Time saved
Not reported
Setup time
Not reported
Running cost
Not reported
Cost range
Not reported

Use case overview

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.

Reported experience

  1. 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.

  2. 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.

  3. 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.

Example prompts

Try 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.