Turn topics in a sheet into researched video scripts

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

SHEET_ID = "your-spreadsheet-id"

def sonar(prompt):
    r = http.post("https://api.perplexity.ai/chat/completions", headers={"Authorization": f"Bearer {credentials.secret('PERPLEXITY_API_KEY')}"},
                  json={"model": "sonar", "messages": [{"role": "user", "content": prompt}]}, timeout=90).json()
    return r["choices"][0]["message"]["content"], [s["url"] for s in r.get("search_results", [])]

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")),
                   cache_discovery=False).spreadsheets().values()
    rows = sheets.get(spreadsheetId=SHEET_ID, range="Video ideas!A2:C").execute().get("values", [])
    new = [(i + 2, r[0]) for i, r in enumerate(rows) if len(r) == 1 and r[0]]
    report_fetched(len(new))
    if not new:
        return {"new": 0}
    for n, topic in new:
        facts, links = sonar(f"Give the key current facts about: {topic}. Short bullets with numbers where possible.")
        script = ai.generate(f"Write a 30-second video script (about 75 words) about '{topic}': a hook, three short points, "
                             f"a call to action. Use only these facts:\n{facts[:3000]}", max_output_tokens=250).text
        sheets.update(spreadsheetId=SHEET_ID, range=f"Video ideas!B{n}:C{n}", valueInputOption="RAW",
                      body={"values": [[script.strip(), "\n".join(links[:5])]]}).execute()
    return {"scripts": len(new)}