Create PDF invoices from your order form

import io
from datetime import date
from reportlab.pdfgen import canvas
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from googleapiclient.http import MediaIoBaseUpload
from clickruntime import on_event, credentials, state

FOLDER_ID, SHEET_ID = "your-invoices-folder-id", "your-spreadsheet-id"

@on_event
def handle(event):
    if state.get(f"done:{event.event_id}"):
        return {"skipped": "duplicate"}
    order = event.json
    number = (state.get("last_number") or 1000) + 1
    total = sum(i["qty"] * i["price"] for i in order["items"])
    buf = io.BytesIO(); pdf = canvas.Canvas(buf)
    lines = [f"Invoice {number}", f"Date: {date.today()}", f"Bill to: {order['name']}", ""] +             [f"{i['qty']} x {i['item']} @ {i['price']:.2f}" for i in order["items"]] + ["", f"Total: {total:.2f}"]
    for n, line in enumerate(lines):
        pdf.drawString(60, 780 - n * 18, line)
    pdf.save()
    creds = Credentials(credentials.connection("google", "work"))
    f = build("drive", "v3", credentials=creds, cache_discovery=False).files().create(body={"name": f"Invoice {number}.pdf", "parents": [FOLDER_ID]},
        media_body=MediaIoBaseUpload(io.BytesIO(buf.getvalue()), mimetype="application/pdf"), fields="webViewLink").execute()
    build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Invoices!A:E",
        valueInputOption="USER_ENTERED", body={"values": [[number, str(date.today()), order["name"], total, f["webViewLink"]]]}).execute()
    state.set("last_number", number)
    state.set(f"done:{event.event_id}", True)
    return {"invoice": number}