Make a personalised deck for every new row in your sheet

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, FOLDER = "your-spreadsheet-id", "your-template-id", "decks-folder-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    header, *rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Prospects!A1:Z").execute()["values"]
    link_col = header.index("deck_link")
    todo = [(i, dict(zip(header, r))) for i, r in enumerate(rows, start=2) if not dict(zip(header, r)).get("deck_link")]
    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, row in todo:
        try:
            row["pitch"] = ai.generate(f"Write a 2-sentence tailored pitch for {row.get('company')} from: {row.get('notes', '')}", max_output_tokens=100).text
        except ai.AIError:
            row["pitch"] = ""
        deck = drive.files().copy(fileId=TEMPLATE_ID, body={"name": f"Northwind for {row.get('company')}", "parents": [FOLDER]}).execute()["id"]
        slides.batchUpdate(presentationId=deck, body={"requests": [{"replaceAllText": {"containsText": {"text": "{{" + k + "}}"}, "replaceText": v}}
                           for k, v in row.items() if k != "deck_link"]}).execute()
        sheets.values().update(spreadsheetId=SHEET_ID, range=f"Prospects!{chr(65 + link_col)}{i}", valueInputOption="RAW",
                               body={"values": [[f"https://docs.google.com/presentation/d/{deck}"]]}).execute()
    return {"decks": len(todo)}