Summarise new videos in a playlist every day

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, http, credentials, ai, notify

YT = "https://www.googleapis.com/youtube/v3"

def yt(path, **params):
    return http.get(f"{YT}/{path}", params={**params, "key": credentials.secret("YOUTUBE_API_KEY")}).json().get("items", [])

def api(name, version):
    return build(name, version, credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)

SHEET_ID, PLAYLIST = "your-spreadsheet-id", "PLxxxxxxxxxxxxxxxxxxxx"

@on_trigger
def run(event):
    sheet = api("sheets", "v4").spreadsheets().values()
    logged = {r[0] for r in sheet.get(spreadsheetId=SHEET_ID, range="Watch Log!A2:A").execute().get("values", []) if r}
    ids = [i["contentDetails"]["videoId"] for i in yt("playlistItems", part="contentDetails", playlistId=PLAYLIST, maxResults=50)]
    new = [i for i in ids if i not in logged]
    if not new:
        return {"logged": 0}
    rows = []
    for v in yt("videos", part="snippet", id=",".join(new)):
        s = v["snippet"]
        summary = ai.generate(f"{s['title']}\n\n{s['description'][:3000]}", system="Summarise this video in 3 sentences for a busy marketer.",
                              max_output_tokens=150).text.strip()
        rows.append([v["id"], s["title"], s["channelTitle"], f"https://youtu.be/{v['id']}", summary])
    sheet.append(spreadsheetId=SHEET_ID, range="Watch Log!A:E", valueInputOption="RAW", body={"values": rows}).execute()
    notify.email_me(f"{len(rows)} new videos summarised", "\n\n".join(f"{r[1]} ({r[2]})\n{r[4]}\n{r[3]}" for r in rows))
    return {"logged": len(rows)}