Scheduled YouTube transcription with de-duplication using Transcript.io and Supabase

Scheduled YouTube Transcription with Duplicate Prevention

Who's It For?

This template is for advanced users, content teams, and data analysts who need a robust, automated system for capturing YouTube transcripts. It’s ideal for those who monitor multiple channels and want to ensure they only process and save each video's transcript once.

What It Does

This is an advanced, "set-it-and-forget-it" workflow that runs on a daily schedule to monitor YouTube channels for new content. It enhances the basic transcription process by connecting to your Supabase database to prevent duplicate entries.

The workflow fetches all recent videos from the channels you track, filters out any that are too old, and then checks your database to see if a video's transcript has already been saved. Only brand-new videos are sent for transcription via the youtube-transcript.io API, with the final data (title, URL, full transcript, author) being saved back to your Supabase table.

Requirements

A Supabase account with a table to store video data. This table must have a column for the sourceurl to enable duplicate checking. An API key from [youtube-transcript.io](https://www.youtube-transcript.io/) (offers a free tier). The Channel ID for each YouTube channel you want to track.