Research trending YouTube videos and get content ideas automatically

This finds trending YouTube videos on your topic, analyzes them with AI, and logs content ideas to a spreadsheet.

How the work actually flows

A straight line. Runs once per one per trending video.

Pattern: Sequence (1) ยท Multiple Instances without Synchronization (12)

flowchart TD trig>"topic submitted via form"]:::trig s0["find trending videos"]:::svc s1["filter to top videos"]:::task s2[["analyze video content"]]:::mi s3[("log content ideas")]:::store trig --> s0 s0 --> s1 s1 -->|"one per one per trending video"| s2 s2 --> s3 out[/"spreadsheet of vetted video ideas"/]:::out pay{{"data driven content planning saved time"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceRuns once per itemA record or sheetResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Spreadsheet & Database OpsResearch & Market IntelligenceSurvey & Feedback
Connects
YouTubeOpenAIGoogle Sheets

The problem it solves

Figuring out what's actually working on YouTube in your niche means watching dozens of videos, reading titles, and guessing what made them popular. That kind of research eats an entire afternoon if you do it properly.

Who it fits

A content creator, marketer, or business that publishes video content and wants data-driven ideas.

How it works

  1. You submit a keyword or topic through a form
  2. The system finds trending YouTube videos matching that topic
  3. It filters down to the videos most worth studying
  4. AI reviews thumbnails and transcripts to spot what's working
  5. AI-generated titles and outlines are added to a spreadsheet
What you get

Content ideas grounded in what's already trending

Give it a topic and get a spreadsheet full of video ideas based on what's actually trending, with thumbnails and transcripts already studied.

What you get

A spreadsheet of vetted video ideas, complete with suggested titles and outlines.

What you need

A Google Sheets account and an OpenAI API key.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Post an AI summary in Slack every time a YouTube channel uploads

Checks your favorite YouTube channels for new videos and posts a short AI-written summary straight to Slack.

Advanced

Get an AI sentiment summary of your YouTube comments by email

Add a video to a spreadsheet and receive an emailed summary of what viewers are saying in the comments.

Advanced

Turn YouTube comments into an AI-written sentiment report by email

Analyzes the comments on your YouTube video with AI and emails you a report on sentiment, themes, and viewer questions.

Advanced

Summarize YouTube comments into themes and sentiment reports

Reads every comment on your YouTube videos and turns them into a clear summary of themes, sentiment, and common questions.

Advanced
Back to the AI Playbook