Pull YouTube video stats straight into Google Sheets

Feed in YouTube video links and get view counts, likes, and comments filled into your Google Sheet automatically.

How the work actually flows

It branches. Exactly one path is taken; runs once per one per video link.

Pattern: Exclusive Choice (4) · Multiple Instances with a priori Run-Time Knowledge (14)

flowchart TD trig[\"video links marked ready"\]:::trigdata s0[["extract video id"]]:::mi s1["fetch latest video stats"]:::svc trig --> s0 s0 --> s1 gx{"× did the fetch succeed"}:::gate s1 --> gx p00["write stats to row"]:::task gx -->|"success"| p00 p01["mark row finished"]:::task p00 --> p01 p10["flag row as error"]:::task gx -->|"failure"| p10 p01 --> out p10 --> out out[/"sheet filled with current video stats"/]:::out pay{{"video performance tracked without copying"}}:::pay out --> pay s1 -. "failures recorded, run continues" .-> out 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 itemOne path onlyResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Spreadsheet & Database Ops
Connects
Google SheetsYouTube

The problem it solves

Tracking how your videos or competitors' videos are performing means opening each one individually and copying down the numbers. Doing that across dozens of videos is slow and easy to get wrong.

Who it fits

YouTubers, content strategists, or growth marketers who track video performance across many videos at once.

How it works

  1. A list of video links marked ready is read from your Google Sheet
  2. Each video's ID is pulled out one at a time
  3. The system requests the latest stats for that video, like views and likes
  4. The stats are written back into the matching row in your sheet
  5. Each row is marked finished, or flagged as an error if something went wrong
What you get

Video performance numbers ready without checking each one

You get view counts, likes, and comments filled into your Google Sheet automatically for every video link you track.

What you get

A Google Sheet filled in with up-to-date view, like, and comment counts for every video.

What you need

A Google Sheets account 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

Turn a text idea into an AI video and publish it everywhere

Turns a short text prompt into an AI-generated video, lets you approve it on Telegram, then posts it to five social platforms.

Advanced

Manage YouTube channels with AI chat commands and auto-logging

Lets you manage YouTube channels by typing plain-English commands, while every change is logged in Google Sheets.

Standard

Send a daily email digest of your top-performing YouTube videos

Tracks your YouTube channels, spots videos performing above average, and emails you a daily digest of the best ones.

Advanced

Write SEO landing pages using Reddit, YouTube, and GPT-4 research

Pulls research from Reddit, YouTube, and search results, then writes an SEO-ready article automatically.

Advanced
Back to the AI Playbook