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

Description

🎓📺 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 <[email protected]>