Bulk YouTube channel content analysis with Apify & DeepSeek AI to Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (16)
- HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Auto-fixing Output Parser
@n8n/n8n-nodes-langchain.outputParserAutofixing - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Convert to File
n8n-nodes-base.convertToFile - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - n8n Form Trigger
n8n-nodes-base.formTrigger - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - DeepSeek Chat Model
@n8n/n8n-nodes-langchain.lmChatDeepSeek - Edit Fields (Set)
n8n-nodes-base.set
What it does
🎓📺 Watching top YouTubers is now a mainstream way to learn, but watching dozens—or even hundreds—of videos isn’t realistic. This workflow gives learners a fast way to grasp an entire creator’s catalog at a glance. 📄🔗 Demo Google Sheet: click me --- 🧠🔍 YouTube Channel Research & Summarization Workflow 👥 Who’s it for 📚 Learners and educators who want a fast overview of a creator’s entire catalog. 🧩 Research, SEO, and content ops teams building an intelligence layer on top of YouTube channels. ⚙️ How it works 📝 Collects parameters via a Form Trigger. 🕷️ Launches an Apify YouTube Scraper, polls for completion, and fetches the final dataset. 💾 Saves the raw JSON to Google Drive, reloads it, and processes records in batches. 🗣️ Auto-selects English subtitles when available, extracts core metadata, and feeds transcript + metadata to an AI Summarization Agent. 📧 Sends a Gmail completion notification when done. 🛠️ How to set up 1. 🔑 Connect credentials (once) 🗂️ Google Drive 📊 Google Sheets (OAuth enabled) ✉️ Gmail 🧠 DeepSeek API (or alternative LLM); Apify API (YouTube scraper actor) 2. 📝 Configure the form 🔗 YoutuberMainPageURL (e.g., https://www.youtube.com/@n8n-io) 🔢 Totalnumbervideo (tip: use the channel’s current total to crawl all) 🏷️ StoringName (used for the Drive filename & the Sheet tab) 🔑 ApifyAPI (Apify provides $5 free credit per month, which can crawl ~1,000 YouTube videos → https://console.apify.com/) 📧 Email 3. 📁 Point Sheets & Drive 🔗 Create a Google Sheet and link it to all Google Sheets–related nodes. 💽 Select a Drive folder to save raw CSV backups (optional). 🎛️ How to customize the workflow 🈯 Subtitle logic: Extend the language selector SelectSubtitleLanguage to choose English, Mandarin, or another language. 🔔 Notifications: Customize the Gmail subject/body, or add Slack/Teams alerts on success/failure with basic run stats. 📬 Need help? Contact me <[email protected]>