Send a certificate to everyone who passes your quiz

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
import base64
from datetime import date
from email.mime.application import MIMEApplication
from email.mime.multipart import MIMEMultipart
from googleapiclient.http import MediaInMemoryUpload
from clickruntime import on_event, credentials

TEMPLATE_ID, FOLDER_ID = "your-template-doc-id", "your-certificates-folder-id"

@on_event
def handle(event):
    r = event.json or {}
    if float(r.get("score", 0)) <= 80:
        return {"passed": False}
    creds = Credentials(credentials.connection("google", "work"))
    drive = build("drive", "v3", credentials=creds, cache_discovery=False)
    copy = drive.files().copy(fileId=TEMPLATE_ID, body={"name": f"tmp {r['name']}"}).execute()
    swaps = {"{{name}}": r["name"], "{{course}}": r.get("course", ""), "{{date}}": date.today().strftime("%d %B %Y")}
    build("docs", "v1", credentials=creds, cache_discovery=False).documents().batchUpdate(documentId=copy["id"], body={"requests": [
        {"replaceAllText": {"containsText": {"text": k}, "replaceText": v}} for k, v in swaps.items()]}).execute()
    pdf = drive.files().export(fileId=copy["id"], mimeType="application/pdf").execute()
    drive.files().delete(fileId=copy["id"]).execute()
    drive.files().create(body={"name": f"Certificate - {r['name']}.pdf", "parents": [FOLDER_ID]},
                         media_body=MediaInMemoryUpload(pdf, "application/pdf")).execute()
    msg = MIMEMultipart()
    msg["to"], msg["subject"] = r["email"], "Your certificate"
    msg.attach(MIMEApplication(pdf, Name="certificate.pdf"))
    build("gmail", "v1", credentials=creds, cache_discovery=False).users().messages().send(
        userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    return {"issued": r["email"]}