Track competitors' YouTube videos and performance automatically

Type in any YouTube channel name and get its videos' views, likes, and titles logged into a spreadsheet.

How the work actually flows

A straight line. Runs once per each recent video.

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

flowchart TD trig>"channel name submitted"]:::trig s0["look up channel id and videos"]:::svc s1[["pull each video's stats"]]:::mi s2[("write data to sheet")]:::store trig --> s0 s0 -->|"one per each recent video"| s1 s1 --> s2 out[/"spreadsheet of competitor video stats"/]:::out pay{{"benchmark competitor content quickly"}}:::pay s2 --> 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 itAn outside serviceRuns once per itemA record or sheetResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Image & Media ProcessingSpreadsheet & Database OpsReporting & AnalyticsResearch & Market IntelligenceSurvey & Feedback
Connects
YouTubeGoogle Sheets

The problem it solves

You want to know what's working for competing YouTube channels, but scrolling through their videos one by one to track views and likes eats up time you don't have. Trends move fast, and manual checking means you're always a step behind.

Who it fits

Content creators, YouTubers, and marketing teams tracking competitor channels.

How it works

  1. You submit a YouTube channel name through a form
  2. The channel's ID and recent video list are looked up
  3. Each video's title, views, likes, and description are pulled
  4. The data is written to a connected Google Sheet
What you get

Competitor video performance you track over time

You build a running spreadsheet of competitors' video views, likes, and titles, giving you a clear picture of how their channel is trending.

What you get

A spreadsheet of a competitor's recent videos with performance metrics for easy comparison.

What you need

A Google account with Google Sheets and a YouTube Data 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

Back to the AI Playbook