Turn topics in your content sheet into carousel slides

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

SHEET_ID, TEMPLATE_ID = "your-spreadsheet-id", "carousel-template-id"
VOICE = "Plain, practical, friendly. Short sentences. No hashtags."

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Content!A2:C").execute().get("values", [])
    todo = [(i, r[0]) for i, r in enumerate(rows, start=2) if r and r[0] and len(r) < 2]
    report_fetched(len(todo))
    if not todo:
        return {"summary": "Nothing new"}
    drive, slides = build("drive", "v3", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False), build("slides", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).presentations()
    for i, topic in todo:
        texts = ai.generate(f"Write a 6-slide carousel on '{topic}'. Voice: {VOICE} Slide 1 is a hook, slide 6 a call to action. Max 25 words each.",
                            json_schema={"type": "object", "properties": {"slides": {"type": "array", "items": {"type": "string"}}}}, max_output_tokens=500).json["slides"]
        deck = drive.files().copy(fileId=TEMPLATE_ID, body={"name": f"Carousel – {topic}"}).execute()["id"]
        slides.batchUpdate(presentationId=deck, body={"requests": [{"replaceAllText": {"containsText": {"text": f"{{{{s{n}}}}}"}, "replaceText": t}}
                           for n, t in enumerate(texts[:6], 1)]}).execute()
        sheets.values().update(spreadsheetId=SHEET_ID, range=f"Content!B{i}:C{i}", valueInputOption="RAW",
                               body={"values": [["Drafted", f"https://docs.google.com/presentation/d/{deck}"]]}).execute()
    return {"carousels": len(todo)}