Log every shop order in a sheet and post it to Discord

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials, http, state

SHEET_ID = "your-spreadsheet-id"
CHANNEL_ID = "your-discord-channel-id"

@on_event
def handle(event):
    o = event.json or {}
    oid = str(o.get("id", ""))
    if not oid:
        return {"skipped": True}
    name = f"{o.get('billing', {}).get('first_name', '')} {o.get('billing', {}).get('last_name', '')}".strip()
    items = ", ".join(f"{i.get('quantity')}x {i.get('name')}" for i in o.get("line_items", []))
    row = [oid, o.get("date_created", ""), name, items, o.get("total", ""), o.get("status", "")]
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    rows = state.get("rows") or {}
    if oid in rows:
        sheets.spreadsheets().values().update(spreadsheetId=SHEET_ID, range=f"Orders!A{rows[oid]}:F{rows[oid]}",
                                              valueInputOption="USER_ENTERED", body={"values": [row]}).execute()
        return {"updated": oid}
    res = sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Orders!A:F", valueInputOption="USER_ENTERED",
                                                body={"values": [row]}).execute()
    rows[oid] = int(res["updates"]["updatedRange"].split("!A")[1].split(":")[0])
    state.set("rows", rows)
    http.post(f"https://discord.com/api/v10/channels/{CHANNEL_ID}/messages",
              headers={"Authorization": f"Bot {credentials.secret('DISCORD_BOT_TOKEN')}"},
              json={"content": f"New order #{oid}: {items} - {o.get('total', '')} {o.get('currency', '')}"[:2000]})
    return {"added": oid}