Create PDF invoices from Airtable orders into Drive

import io
from fpdf import FPDF
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from googleapiclient.http import MediaIoBaseUpload
from clickruntime import on_trigger, credentials, http, report_fetched
BASE_ID, FOLDER_ID = "appXXXXXXXXXXXXXX", "1FolderIdOfInvoices"
@on_trigger
def run(event):
    api, headers = f"https://api.airtable.com/v0/{BASE_ID}/Orders", {"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"}
    orders = http.get(api, headers=headers, params={"filterByFormula": "{Status}='Invoice'"}).json()["records"]
    report_fetched(len(orders))
    if not orders:
        return {"invoiced": 0}
    drive = build("drive", "v3", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    for rec in orders:
        f, pdf, total = rec["fields"], FPDF(), 0.0
        pdf.add_page(); pdf.set_font("Helvetica", size=12)
        pdf.cell(0, 10, f"Invoice {f.get('Order number')} - {f.get('Customer')}", new_x="LMARGIN", new_y="NEXT")
        for line in (f.get("Line items") or "").splitlines():
            desc, qty, price = [p.strip() for p in line.split(",")]
            total += float(qty) * float(price)
            pdf.cell(0, 8, f"{desc}  x{qty}  @ {float(price):.2f}", new_x="LMARGIN", new_y="NEXT")
        pdf.cell(0, 10, f"Total: {total:.2f}")
        file = drive.files().create(body={"name": f"Invoice {f.get('Order number')}.pdf", "parents": [FOLDER_ID]},
                                    media_body=MediaIoBaseUpload(io.BytesIO(bytes(pdf.output())), mimetype="application/pdf"),
                                    fields="webViewLink").execute()
        http.patch(api, headers=headers, json={"records": [{"id": rec["id"], "fields": {
            "Status": "Invoiced", "Invoice PDF": file["webViewLink"], "Total": total}}]}).raise_for_status()
    return {"invoiced": len(orders)}