Summarise long videos from their transcripts

Give it a list of transcript links, one per line with an optional title, and run it whenever you have a batch of videos to get through. Each transcript is fetched, cut into sections along its own line breaks and read section by section by the AI, which notes the actual claims in each part. Those notes are then written up as one summary in the style you describe, with key points underneath, so the end of a long talk is covered too.

You end up with a 'Video summaries' tab in your Google Sheet holding one row per video: date, title, transcript link, word count, sections covered, summary and key points. The tab is created on the first run and added to after that, never overwritten. A transcript that cannot be fetched or comes back empty is reported and skipped while the rest go through, and a very long one is capped at a set number of sections, with the row saying how many were read.

Transcripts must be reachable by link; the video itself cannot be read.