Publish the next video from your sheet's queue

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

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

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    sheet = api("sheets", "v4").spreadsheets().values()
    rows = sheet.get(spreadsheetId=SHEET_ID, range="Videos!A2:E").execute().get("values", [])
    i = next((n for n, r in enumerate(rows) if len(r) > 3 and r[3] == "ready"), None)
    if i is None:
        return {"published": False}
    topic, notes, file_url = rows[i][0], rows[i][1], rows[i][2]
    meta = ai.generate(f"Topic: {topic}\nNotes: {notes}", system="Write a YouTube title (max 90 chars) and a 3-sentence description.",
                       json_schema={"type": "object", "properties": {"title": {"type": "string"}, "description": {"type": "string"}}}, max_output_tokens=300).json
    media = MediaIoBaseUpload(io.BytesIO(http.get(file_url, timeout=120).content), mimetype="video/mp4", resumable=True)
    video = api("youtube", "v3").videos().insert(part="snippet,status", media_body=media, body={
        "snippet": {"title": meta["title"], "description": meta["description"]}, "status": {"privacyStatus": "public"}}).execute()
    link = f"https://youtu.be/{video['id']}"
    sheet.update(spreadsheetId=SHEET_ID, range=f"Videos!D{i + 2}:E{i + 2}", valueInputOption="RAW", body={"values": [["published", link]]}).execute()
    notify.email_me(f"Published: {meta['title']}", link)
    return {"video": video["id"]}