Discover trending YouTube videos in your niche automatically

Submit a topic and it finds high-performing YouTube videos and builds a ranked report in Google Sheets.

How the work actually flows

A straight line. Runs once per each matching video.

Pattern: Sequence (1) ยท Multiple Instances with a priori Run-Time Knowledge (14)

flowchart TD trig(("user submits topic and timeframe")):::human s0["Search YouTube for videos"]:::task s1[["Pull engagement data"]]:::mi s2["Filter low performers"]:::task s3["Build Sheets report"]:::task s4["Send report link"]:::task trig --> s0 s0 -->|"one per each matching video"| s1 s1 --> s2 s2 --> s3 s3 --> s4 out[/"ranked trend report delivered"/]:::out pay{{"faster content research"}}:::pay s4 --> 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
A stepRuns once per itemA personResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

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

The problem it solves

Finding out what's actually trending in your niche means scrolling YouTube for hours and guessing which videos are worth studying. By the time you spot a pattern manually, the trend has often already peaked.

Who it fits

A content creator, digital marketer, or YouTube strategist researching content trends.

How it works

  1. You submit a topic and a time range through a simple form
  2. YouTube is searched for videos matching your topic and timeframe
  3. View, like, comment, and engagement data is pulled for each video
  4. Low-performing and duplicate videos are filtered out
  5. The results are organized into a Google Sheets report with a link sent back to you
What you get

Trending videos in your niche already ranked for you

You can submit a topic and get back a ranked report of the best-performing YouTube videos in that space, organized in a spreadsheet.

What you get

A ranked Google Sheets report of trending videos in your niche, with engagement data for each one.

What you need

A YouTube Data API key and a Google Sheets account.

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

Back to the AI Playbook