Turn Telegram ideas into short videos logged in a sheet

import time
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials, http, ai, state

SHEET_ID = "your-spreadsheet-id"
VIDEO_API_URL = "https://api.your-video-service.com"
VIDEO_API = f"{VIDEO_API_URL}/v1/videos"

@on_event
def handle(event):
    msg = (event.json or {}).get("message") or {}
    idea, chat = msg.get("text"), msg.get("chat", {}).get("id")
    if not idea or state.get(event.event_id):
        return {"skipped": True}
    tg = f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}"
    script = ai.generate(f"Write a 30-second video script about: {idea}", max_output_tokens=400).text
    key = {"Authorization": f"Bearer {credentials.secret('VIDEO_API_KEY')}"}
    job = http.post(VIDEO_API, json={"script": script}, headers=key).json()
    for _ in range(40):
        job = http.get(f"{VIDEO_API}/{job['id']}", headers=key).json()
        if job.get("status") == "done":
            break
        time.sleep(10)
    link = job.get("url", "pending")
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Videos!A:D", valueInputOption="USER_ENTERED",
        body={"values": [[event.received_at, idea, script, link]]}).execute()
    http.post(f"{tg}/sendMessage", json={"chat_id": chat, "text": f"Your video is ready: {link}"})
    state.set(event.event_id, True)
    return {"video": link}