Extract YouTube channel videos into a tracking spreadsheet

Pulls video titles, links, thumbnails, and publish dates from any YouTube channel into your spreadsheet.

How the work actually flows

It branches. Exactly one path is taken; runs once per one per youtube channel.

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

flowchart TD trig(("run with channel link list")):::human s0[["look up channel id"]]:::mi s1["pull latest videos"]:::task s2["log video details"]:::task trig --> s0 s0 --> s1 s1 --> s2 gx{"× did the channel fetch succeed"}:::gate s2 --> gx p00["mark channel done"]:::task gx -->|"success"| p00 p10["flag channel for review"]:::task gx -->|"failure"| p10 p00 --> out p10 --> out out[/"spreadsheet filled with channel video data"/]:::out pay{{"track many channels without manual 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
A stepRuns once per itemA personOne path onlyResultPayoff
Build size
Advanced

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

Business functions
Spreadsheet & Database OpsReporting & Analytics
Connects
YouTubeGoogle Sheets

The problem it solves

Tracking what competitors or partners post on YouTube means visiting each channel by hand and copying down titles, links, and dates. Doing this for more than a couple of channels quickly turns into a tedious, repetitive chore.

Who it fits

Content strategists, marketing teams, or researchers tracking multiple YouTube channels.

How it works

  1. Starts when you run it with a list of channel links in your spreadsheet
  2. Looks up each channel's ID automatically, even from a custom URL
  3. Pulls the latest videos with titles, descriptions, thumbnails, and publish dates
  4. Logs the video details into your spreadsheet and marks the channel as done
  5. Flags any channel that fails so you can review it later
What you get

Every channel's new videos tracked in one place

You get titles, thumbnails, links, and publish dates for every video across all the YouTube channels you follow, logged automatically.

What you get

A spreadsheet full of organized video data for every channel you're tracking.

What you need

A Google Sheets account and access to the YouTube API.

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

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

Track sentiment and keywords in your YouTube comments automatically

Reads new YouTube comments, scores each one for sentiment, and sends you a Telegram summary report.

Advanced

Manage YouTube playlists by chatting with an AI assistant

Lets you create, update, and review YouTube playlists just by typing a request, with every action logged.

Standard

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
Back to the AI Playbook