AI YouTube Comment Intelligence System – Auto-Scraper, Transcript Extractor, (Make.com )

This advanced Make.com automation scrapes YouTube comments, combines them, extracts the video transcript, summarizes the content, analyzes viewer emotions, and generates ranked video ideas. Everything is then automatically saved into Airtable.

If you want a plug-and-play YouTube intelligence engine, this is the most complete workflow on the market.

⭐ WHAT THIS AUTOMATION DOES

✔ 1. Auto-Trigger via Apify Webhook The workflow begins the moment an Apify Actor finishes scraping YouTube data.

✔ 2. Fetches Up to 100 YouTube Comments Automatically It retrieves cleaned comment data in JSON format for fast processing.

✔ 3. Aggregates All Comments Into One AI-Ready Text Block A two-step aggregator merges all comments into a single text document used for sentiment and idea generation.

✔ 4. Extracts the Video Transcript Using Custom Python Code The system automatically extracts the original video transcript via the YouTube Transcript API.

The Python block:

Detects YouTube video ID

Fetches transcript

Returns clean text

This unlocks deep AI analysis.

✔ 5. AI Generates a 35-Word Summary of the YouTube Video (GPT-4o) The workflow creates a concise, high-quality summary that captures the main ideas without fluff.

Perfect for:

Content repurposing

Social media captions

Research databases

✔ 6. Sentiment Analysis of Viewer Comments (GPT-4o) AI reads the combined comment block and produces a 35-word emotional + sentiment breakdown, including:

Positive / Negative / Neutral percentages

Emotional trends

Key patterns viewers mention

✔ 7. AI Generates 5 Ranked Video Ideas for Your Next Upload Using sentiment, themes, and engagement signals from comments, GPT-4o produces:

Five new video ideas

Each with a curiosity-driven title under 50 characters

Ranked from most to least relevant

Each with an emoji

This helps you create videos the audience actually wants.

✔ 8. Automatically Stores Everything in Airtable The final step writes all insights into your Airtable table, including:

Video URL

YouTube Title

AI Summary

Sentiment Report

Video Ideas

This becomes your YouTube content intelligence library.

🎯 WHAT YOU GET FROM THIS TEMPLATE

From just one YouTube URL, the automation gives you:

Clean video transcript

35-word AI summary

Aggregated comment dataset

Sentiment analysis report

5 video ideas ranked by demand

All results stored automatically in Airtable

Everything happens without writing, editing, or manual scraping.

🧠 PERFECT FOR:

YouTube creators

Agencies

Scriptwriters

Research teams

Editors

AI automation agencies

Shorts/Reels repurposing workflows

If you want to know exactly what your audience wants you to make next, this system does the thinking for you.

🚀 WHY THIS TEMPLATE IS EXTREMELY POWERFUL

Because it turns raw video + comments into:

Insight

Opportunities

Content strategy

New viral ideas

Data-driven decisions

All in under 10 seconds once configured.

No more guessing. No more manual scraping. No more wasted content.

This is your AI YouTube optimization engine.