Bulk YouTube Channel Content Analysis with Apify & DeepSeek AI to Google Sheets

🎓📺 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

🔑 Connect credentials (once) 🗂️ Google Drive 📊 Google Sheets (OAuth enabled) ✉️ Gmail 🧠 DeepSeek API (or alternative LLM); Apify API (YouTube scraper actor)

📝 Configure the form 🔗 Youtuber_MainPage_URL (e.g., https://www.youtube.com/@n8n-io) 🔢 Total_number_video (tip: use the channel’s current total to crawl all) 🏷️ Storing_Name (used for the Drive filename & the Sheet tab) 🔑 Apify_API (Apify provides $5 free credit per month, which can crawl ~1,000 YouTube videos → https://console.apify.com/) 📧 Email

📁 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 Select_Subtitle_Language 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 <owenlzyxg@gmail.com>