YouTube channel monitor with Video Stats, AI transcription & Summarization

This n8n workflow monitors YouTube channels 24/7, transcribes new videos with AI, and scores them by relevance—all automatically saved to Google Sheets.

About

This n8n workflow automatically monitors YouTube channels, transcribes new videos, and generates AI-powered summaries with relevance scoring. It pulls channel URLs from a Google Sheet, fetches recent videos (last 30 days) using the YouTube Data API v3, grabs each video's views and likes, transcribes them using Google Gemini, and saves detailed summaries back to your spreadsheet with relevance scores based on your custom criteria.

How It Works

1. Schedule Trigger: Runs weekly (every 7 days at 7:05 AM) 2. Fetch Channels: Reads channel URLs and filter criteria from Google Sheets 3. Get Channel ID: Uses the YouTube API to look up each channel's ID from its handle 4. Fetch Recent Videos: Pulls up to 20 latest videos per channel via the YouTube API 5. Filter Videos: Only keeps videos from the last 30 days 6. Get Video Stats: Fetches each video's view count and like count from the YouTube API 7. Check for Duplicates: Skips videos already saved in your spreadsheet 8. Transcribe: Uses Google Gemini API to watch and transcribe the video content 9. Summarize & Score: AI agent analyzes the transcript against your criteria and generates: - Full 500-word summary in markdown - Short bullet-point summary - Topic classification - Relevance score (1–10) - Relevance reasoning 10. Save Results: Appends or updates all video data (including views, likes, transcript, summary) in Google Sheets

---

Setup Instructions — Step by Step (Anyone Can Do This!)

What You'll Need Before Starting