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 14 days), transcribes them using Google Gemini, and saves detailed summaries back to your spreadsheet with relevance scores based on custom criteria. How It Works Schedule Trigger : Runs weekly (every 7 days at 7:05 AM) Fetch Channels : Reads channel URLs and filter criteria from Google Sheets Process Channels : Loops through each channel and fetches recent videos via YouTube RSS feeds Filter Videos : Only processes videos from the last 14 days that don't already exist in the database Transcribe : Uses Google Gemini API to transcribe video content Summarize & Score : AI agent analyzes transcripts against your criteria and generates: Full 500-word summary in markdown Short bullet-point summary Topic classification Relevance score (1-10) Relevance reasoning Save Results : Appends or updates video data in Google Sheets Setup Instructions Prerequisites n8n instance (cloud or self-hosted) Google account with Sheets API access Google Gemini API key Step 1: Google Sheets Setup Create a new Google Spreadsheet with two sheets: Google Sheet Template : Click here to access Make a copy to your Google Drive Configure the two sheets as described below Sheet 1: "channels" Column A: category (e.g., "AI Tools", "Marketing") Column B: channels (comma-separated YouTube channel URLs) Column C: video filter criteria (describe what makes videos relevant) Sheet 2: "videos" Columns: id , title , video url , date , channel , category , topic , summary , short sumary , transcript , relevance score , relevance reason Step 2: Configure n8n Workflow Import the workflow JSON into n8n Google Sheets Authentication : Connect your Google account in both "Get row(s) in sheet" nodes Update the document ID to match your spreadsheet Gemini API Key : In the "set channel" node, replace the placeholder API key with your own Gemini API key Get your key from: https://makersuite.google.com/app/apikey Step 3: Adjust Settings (Optional) Video lookback period : Edit line 6 in "Videos Posted in Last X days" node (default: 14 days) Videos per channel : Modify the "Limit" node (default: 4 videos) Schedule : Change the "Schedule Trigger5" node timing as needed Wait times : Adjust wait nodes to respect API rate limits Step 4: Test & Activate Add a test channel URL to your "channels" sheet Run the workflow manually to verify it works Activate the workflow to run on schedule Notes The workflow includes rate limiting (wait nodes) to avoid API throttling Videos are checked for duplicates before processing Failed transcriptions continue to the next video without stopping the workflow Results are automatically saved to Google Sheets after each video processes