Email a personalised certificate to everyone who passes

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

TEMPLATE_ID, PASS_MARK = "certificate-template-id", 80

@on_event
def handle(event):
    r = event.json or {}
    if float(r.get("score", 0)) < PASS_MARK or state.get(f"sent:{r['email'].lower()}"):
        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().delete(fileId=deck).execute()
    msg = EmailMessage()
    msg["To"], msg["Subject"] = r["email"], "Your certificate of completion"
    msg.set_content(f"Congratulations {r['name']}, you passed with {r['score']}%! 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'].lower()}", True)
    return {"sent": r["email"]}