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.