- “Every single Monday it runs automatically — I know 5.34% of people watching the video converted and downloaded the PDF.” — Stefano
The problem
Stefano tracked his YouTube channel's buckets, themes, views, and conversion rates in a spreadsheet, but a team member had to fill in all the data manually every month. He also used third-party landing pages, which meant he couldn't fully control or measure his funnel.
The AI solution
First, he rebuilt his entire website with Claude and hosts it on Netlify, so every piece of the funnel is his own: each video links to a lead-magnet landing page (name, email, level, download PDF), which triggers an email to a thank-you/download page hosting the PDF itself. Then he had Claude write a Google Apps Script (Extensions → Apps Script in Google Sheets) that integrates the YouTube Analytics API and the Google Analytics API — "I built it with AI but there's no AI involved in this," it's pure API calls.
Every Monday at 6:00 AM the script runs automatically: it looks for new videos on the channel and adds each one's link, title, and publication date; it updates view counts for all previous videos; and it parses each video's description to extract the landing-page URL (his links always follow the same structure), then derives the download page and PDF columns from it. From Google Analytics it pulls landing-page views, unique visitors, and submissions — counted as people who reached the thank-you page from that specific landing page — and calculates a page conversion rate plus a YouTube-views-to-lead conversion rate per video. Every Monday it also saves a backup copy of the sheet to Google Drive, so he can later hand Claude the whole backup history and have it analyze how each video's performance evolved.
The sheet doubles as a support tool: for any video, the team can instantly find the exact PDF and landing page associated with it, and spot broken links. He deliberately stopped short of tracking sales per video — Google Analytics-only means no personal data collected.
Tools & costs
Results
Fully replaced the manual monthly data entry — the whole thing updates itself weekly at zero extra cost. Example from the sheet: a days-old video with ~3,000 views drove 294 landing-page views, 230 unique visitors, and 170 form submissions — a 5.34% views-to-download conversion rate, visible per video across the channel's full history.
How to copy it
- Host your own lead-magnet landing pages and thank-you pages on a domain you control so Google Analytics can see the whole funnel.
- Keep your video descriptions' landing-page links in a consistent format so a script can parse them.
- Ask Claude to write a Google Apps Script that calls the YouTube Analytics API (new videos, titles, dates, views) and Google Analytics API (page views, unique visitors, thank-you-page submissions).
- Schedule it as a weekly time-driven trigger (e.g. Mondays 6 AM) and have it compute page and views-to-lead conversion rates.
- Auto-save a weekly backup to Google Drive so AI can later analyze trends across snapshots.
Source
AI Hangout — July 2026 (recording) · watch this segment on YouTube (38:38) →