
This workflow is an all-in-one content creation engine for YouTube and other video platforms. It analyzes what is already working in a niche by scraping existing video data (Transcripts, Comments, Descriptions). It then uses Gemini AI to synthesize this audience data, generate a completely new, high-potential video idea, and write the full, timestamped, ready-to-record script, saving the entire strategy directly to Google Sheets.
This core module performs a deep-dive content audit on successful videos:
The Agent takes two inputs: min_View (minimum view count to filter by) and Keyword.
It navigates to YouTube and performs a search for the specified keyword (e.g., "laptop repair tutorial").

The Agent enters a Loop List to iterate through the list of top-performing videos (implicitly filtered by the min_View setting).
For each video, the Agent executes specialized actions to extract hidden data:

Clicks "...more" to reveal the full video description.
Clicks "Show transcript" to load the complete, text-based script.
Data Capture: It extracts the video Link, Comments (to gauge audience sentiment/pain points), Description, and the full Transcript.
The Make.com scenario handles the strategic decision-making and structured output generation:

The workflow starts with a Telegram Bot trigger.
An initial filter and logic check determine if the user is simply chatting (false) or initiating a content creation request (e.g., "Write a script about laptop repair").
If a request is detected, an AI node refines the user's input into precise search keywords for the BrowserAct module.
After the scraping is complete, the raw data (Transcripts, Comments, Descriptions of competing videos) is sent to a specialized Gemini AI node, prompted as an "Expert Content Strategist."
Analysis & Synthesis: The AI analyzes the scraped data to understand audience demand (from comments) and content delivery (from transcripts).
Structured Output: The AI generates a complex JSON array that contains:
The New Viral Video Idea Name (in the first object).
A complete, multi-section script with Titles and precise Timestamps for every line of dialogue.
The JSON output is parsed by an Iterator and saved row-by-row into Google Sheets. This creates a professional, ready-to-use content calendar or script database for the video editor/creator.
Content Creator Strategy: Automate the ideation process by finding topics that resonate with your existing audience, guaranteeing higher view potential.
Competitor Content Gaps: Analyze a competitor's successful videos and their viewer comments to find pain points or unaddressed topics, which you can turn into your next video.
SEO & Transcript Optimization: Generate SEO-optimized, timestamped scripts instantly, significantly speeding up the production pipeline.
Podcast/Voiceover Production: Use the generated timestamped script directly as a guide for recording, ensuring efficient recording and synchronization.