Turn video ideas in a sheet into finished videos in Drive

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

SHEET_ID, FOLDER_ID, VIDEO_API = "your-videos-sheet-id", "your-drive-folder-id", "https://api.your-video-service.com/v1/videos"

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    values = build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values()
    rows = values.get(spreadsheetId=SHEET_ID, range="Videos!A2:C").execute().get("values", [])
    ready = next((i for i, r in enumerate(rows, start=2) if len(r) > 1 and r[1] == "Ready"), None)
    if ready is None:
        return {"made": 0}
    prompt = ai.generate(f"Write a detailed prompt for a 15-second vertical video about: {rows[ready - 2][0]}", max_output_tokens=300).text
    job = http.post(VIDEO_API, json={"prompt": prompt}, headers={"Authorization": f"Bearer {credentials.secret('VIDEO_API_KEY')}"},
                    timeout=300).json()
    video = http.get(job["video_url"], timeout=120).content
    f = build("drive", "v3", credentials=creds, cache_discovery=False).files().create(
        body={"name": f"{rows[ready - 2][0][:60]}.mp4", "parents": [FOLDER_ID]},
        media_body=MediaInMemoryUpload(video, mimetype="video/mp4"), fields="webViewLink").execute()
    values.update(spreadsheetId=SHEET_ID, range=f"Videos!B{ready}:C{ready}", valueInputOption="RAW",
                  body={"values": [["Done", f["webViewLink"]]]}).execute()
    return {"made": 1}