Create a PDF certificate in Drive for everyone who passes

import base64, io
from datetime import date
from email.message import EmailMessage
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from googleapiclient.http import MediaIoBaseUpload
from clickruntime import on_event, credentials, http, state

TEMPLATE_ID, FOLDER = "certificate-template-id", "certificates-folder-id"

@on_event
def handle(event):
    r = event.json or {}
    if float(r.get("score", 0)) < 80 or state.get(f"sent:{r['email']}"):
        return {"skipped": True}
    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()
    deck = drive.files().copy(fileId=TEMPLATE_ID, body={"name": f"Certificate – {r['name']}"}).execute()["id"]
    slides.batchUpdate(presentationId=deck, body={"requests": [{"replaceAllText": {"containsText": {"text": "{{" + k + "}}"}, "replaceText": v}}
                       for k, v in {"name": r["name"], "date": f"{date.today():%d %B %Y}"}.items()]}).execute()
    pdf = drive.files().export(fileId=deck, mimeType="application/pdf").execute()
    drive.files().create(body={"name": f"Certificate – {r['name']}.pdf", "parents": [FOLDER]}, media_body=MediaIoBaseUpload(io.BytesIO(pdf), mimetype="application/pdf")).execute()
    drive.files().delete(fileId=deck).execute()
    msg = EmailMessage()
    msg["To"], msg["Subject"] = r["email"], "Your certificate"
    msg.set_content(f"Congratulations {r['name']}! Your certificate is attached.")
    msg.add_attachment(pdf, maintype="application", subtype="pdf", filename="certificate.pdf")
    build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    state.set(f"sent:{r['email']}", True)
    return {"sent": r["email"]}