Make a personalised pitch deck for each prospect in a CSV

import csv, io
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, state, notify, report_fetched

TEMPLATE_ID, IN_FOLDER, OUT_FOLDER = "your-template-id", "prospects-folder-id", "decks-folder-id"

@on_trigger
def run(event):
    drive, done = build("drive", "v3", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False), set(state.get("done") or [])
    files = [f for f in drive.files().list(q=f"'{IN_FOLDER}' in parents and mimeType='text/csv' and trashed=false").execute()["files"] if f["id"] not in done]
    report_fetched(len(files))
    if not files:
        return {"summary": "Nothing new"}
    slides, links = build("slides", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).presentations(), []
    for f in files:
        for row in csv.DictReader(io.StringIO(drive.files().get_media(fileId=f["id"]).execute().decode("utf-8-sig"))):
            deck = drive.files().copy(fileId=TEMPLATE_ID, body={"name": f"Northwind for {row['company']}", "parents": [OUT_FOLDER]}).execute()["id"]
            slides.batchUpdate(presentationId=deck, body={"requests": [{"replaceAllText": {"containsText": {"text": "{{" + k + "}}"}, "replaceText": v}}
                                                                      for k, v in row.items()]}).execute()
            links.append(f"{row['name']} ({row['company']}): https://docs.google.com/presentation/d/{deck}")
        done.add(f["id"])
    notify.email_me(f"{len(links)} personalised decks ready", "\n".join(links))
    state.set("done", list(done))
    return {"decks": len(links)}