This template starts when YouTube publishes a new video in the channel you watch. It loads title, description, and tags, fetches the caption track, and JavaScript strips timestamps into a readable transcript.
The transcript is saved as a Google Drive text file, and a Google Sheets row stores title, URL, and an excerpt. Connect YouTube, Google Drive, and Google Sheets. When captions are missing, transcribe the soundtrack with Latenode speech-to-text.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
The scenario starts when YouTube publishes a new video in the channel you watch.
YouTube returns title, description, and tags, then the subtitle track. When captions are missing, transcribe the soundtrack with Latenode speech-to-text.
JavaScript strips timestamps and leftover markup so you have one readable text block.
Google Drive stores the transcript as a text file. Google Sheets appends title, URL, and an excerpt.
Add a YouTube connection with access to the channel. Watch new videos in that channel.
Add a Google Drive connection and pick the folder for transcript files. Add a Google Sheets connection and use a sheet with columns for title, URL, published time, and transcript excerpt.
Get video info for title, description, and tags. Get subtitles for the caption track. In JavaScript, strip timestamps and join the cue text.
Create a Drive text file from the transcript. Add a Sheets row with title, URL, and an excerpt. Publish a public test video that has captions and confirm both destinations.
FAQ
More templates
This template watches a Google Drive folder for new video files, downloads each file, transcribes the soundtrack with Latenode speech-to-text, and asks ChatGPT for a title, description, and tags. It then uploads the video to YouTube and applies that metadata. Connect Google Drive and YouTube, then point the trigger at the folder you drop videos into.
This template publishes new video files from Google Drive to your YouTube channel. It watches the folder you choose, downloads each file, and uploads it to the connected channel. If the folder also holds other files, keep only video types. Set the title from the filename and a privacy status after upload. Connect Google Drive and YouTube, then point the trigger at the upload folder.
This template watches a YouTube channel for new videos and builds RSS in JavaScript. The trigger supplies title, description, video URL, and published time. JavaScript maps those fields into RSS item XML or a full feed document. Google Drive saves the XML in the folder you choose. Connect YouTube and Google Drive, then point the trigger at the channel you want to publish.
