Latenode

Automate video analysis: AI insights from Google Drive to Google Sheets

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 topics and takeaways. JavaScript cleans the transcript.

Google Sheets stores file name, summary, and the time of the run. Connect Google Drive and Google Sheets, then point the trigger at the folder you drop videos into. ChatGPT is a Latenode AI step, so you do not paste an OpenAI key. This analyzes existing video. It does not render a new video.

Updated Sep 16, 2026Est. run: 22sEst. cost: $0.0014
How Latenode estimates time and cost

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

What this template does

  • Turns new Drive videos into a readable insights row
  • Transcribes with Latenode speech-to-text
  • Writes topics and takeaways with ChatGPT
  • Stores file name and summary in Google Sheets

How it works

1
Trigger

Watch the Drive folder

The scenario starts when a new video appears in the Google Drive folder you choose.

2
Action

Download and transcribe

Latenode downloads the file and turns the soundtrack into text with speech-to-text. JavaScript tidies the transcript.

3
AI

Write topics and takeaways

ChatGPT reads the transcript and returns structured insights. ChatGPT is Latenode AI, so you do not paste an OpenAI key.

4
Action

Log the Google Sheets row

Google Sheets adds a row with file name, summary, topics, and the time of the run.

Setup guide

1

Connect Google Drive

Add a Google Drive connection with access to the folder you drop videos into. Add a trigger for new files and select that folder.

2

Connect Google Sheets

Add a Google Sheets connection. Use columns for file name, summary, topics, and timestamp.

3

Transcribe and summarize

Download the Drive file, transcribe with Latenode speech-to-text, clean the transcript in JavaScript, then send it to ChatGPT for topics and takeaways. ChatGPT is a Latenode AI step. Append the Sheets row.

Requirements

A Google Drive folder Latenode can read
A Google Sheet Latenode can append to
Videos small enough for the speech-to-text step you pick
ChatGPT available as a Latenode AI step

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work. Plug-and-Play AI nodes are billed separately.