In simple English
This tool searches YouTube for any topic you pick. It ranks the top videos by views, engagement, or momentum. It writes all the details into an Excel spreadsheet. You see which creators are winning and what their viewers are saying. It helps you plan your own content without clicking through dozens of videos by hand.
What it is
Claude Code (an AI coding assistant that runs in your terminal) skill that queries the YouTube Data API and outputs an Excel workbook. It gathers video statistics, comments, transcripts, and channel metrics into formatted sheets.
What it is good for
Solo creators and marketers who want to research competitor content or find popular video hooks without spending hours browsing YouTube.
- Gathers up to 48 data columns per video in one command.
- Appends fresh research directly into your existing tracking spreadsheets.
- Extracts opening lines and comment summaries automatically.
- Requires a Google Cloud API key and a terminal environment.
- YouTube API quotas limit how many searches you can run each day.
- Whisper transcription needs a powerful computer with a graphics card to run fast.
manual YouTube video research and spreadsheet data entry
Claude Code
- yt-dlp/yt-dlp200k stars
Downloads videos and subtitles from YouTube, but lacks the automated spreadsheet reporting and ranking features.
- cybertec-postgresql/pg_timetable1.4k stars
A job scheduler for PostgreSQL whose jobs and schedules live in the database itself.
- PrefectHQ/prefect24k stars
Adds scheduling, retries and a run history to Python functions you already have.
git clone https://github.com/AgriciDaniel/youtube-scout.git cd youtube-scout ./install.sh python3 -m pip install --user openpyxl yt-dlp