Automatically save new YouTube transcripts without duplicates

Every day the system checks your tracked channels for new videos and saves fresh transcripts to your database automatically.

How the work actually flows

It branches. Exactly one path is taken; runs once per each tracked channel's videos.

Pattern: Exclusive Choice (4) · Simple Merge (5) · Multiple Instances without Synchronization (12)

flowchart TD trig(["daily schedule check"]):::trigtime s0[["check tracked channels for new videos"]]:::mi s1["filter out videos outside window"]:::task s2["check database for duplicates"]:::task s3[("save new video and transcript")]:::store trig --> s0 s0 --> s1 s1 --> s2 gx{"× already saved in database"}:::gate s2 --> gx p00["skip video"]:::task gx -->|"already saved"| p00 p10["transcribe and save"]:::task gx -->|"new video"| p10 jn{"○ continue processing"}:::gate p00 --> jn p10 --> jn jn --> s3 out[/"deduplicated transcript archive updated"/]:::out pay{{"saves manual checking and dedup work"}}:::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 stepRuns once per itemA record or sheetOne path onlyPaths rejoinResultPayoff
Build size
Advanced

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

Business functions
Spreadsheet & Database OpsScheduling & Calendar
Connects
YouTubeSupabase

The problem it solves

Keeping a searchable archive of video content from channels you follow means manually checking for new uploads and pulling transcripts one at a time. It is easy to accidentally save the same video twice or miss new ones altogether.

Who it fits

Content teams and analysts who monitor multiple YouTube channels and need a clean, deduplicated transcript archive.

How it works

  1. On a daily schedule, the system checks your list of tracked YouTube channels for new videos
  2. It filters out videos older than your chosen time window
  3. It checks your database to confirm the video has not already been saved
  4. New videos are sent off for transcription
  5. The title, link, transcript, and author are saved to your database
What you get

A growing transcript archive you never built by hand

You get fresh transcripts from every tracked YouTube channel saved automatically to your database each day.

What you get

A deduplicated database of video transcripts from your tracked YouTube channels.

What you need

A Supabase account and an API key from youtube-transcript.io.

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