Turn any YouTube video into instant audience insights, AI-generated summaries, sentiment reports, and new viral video ideas—all fully automated.

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.