Approve supplier invoices in Slack before they become bills

import json
from urllib.parse import parse_qs
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from slack_sdk import WebClient
from clickruntime import on_trigger, on_event, credentials, http, state, ai, report_fetched
API = "https://quickbooks.api.intuit.com/v3/company/1234567890"  # your QuickBooks company id

def qb(method, path, **kw):
    r = http.request(method, API + path, params={"minorversion": 73, **kw.pop("params", {})}, **kw, headers={"Accept": "application/json", "Authorization": "Bearer " + credentials.connection("quickbooks", "company")})
    return r.raise_for_status() or r.json()

@on_trigger
def run(event):
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    seen = set(state.get("seen") or [])
    msgs = [m for m in gmail.users().messages().list(userId="me", q="label:Invoices newer_than:3d").execute().get("messages", []) if m["id"] not in seen]
    report_fetched(len(msgs))
    if not msgs:
        return {"summary": "Nothing new"}
    slack = WebClient(token=credentials.connection("slack", "work"))
    for m in msgs:
        snippet = gmail.users().messages().get(userId="me", id=m["id"]).execute()["snippet"]
        f = ai.generate(f"Return JSON vendor, number, amount from:\n{snippet}", max_output_tokens=80, json_schema={"type": "object",
                        "properties": {"vendor": {"type": "string"}, "number": {"type": "string"}, "amount": {"type": "number"}}}).json
        value = json.dumps(f)
        slack.chat_postMessage(channel="#finance", text=f"{f['vendor']} #{f['number']}: ${f['amount']:,.2f}", blocks=[
            {"type": "section", "text": {"type": "mrkdwn", "text": f"*{f['vendor']}* invoice {f['number']}: ${f['amount']:,.2f}"}},
            {"type": "actions", "elements": [{"type": "button", "text": {"type": "plain_text", "text": t}, "action_id": t.lower(), "value": value}
                                             for t in ("Approve", "Reject")]}])
        seen.add(m["id"])
    state.set("seen", list(seen)[-500:])
    return {"posted": len(msgs)}

@on_event
def clicked(event):
    p = json.loads(parse_qs(event.body)["payload"][0])
    action, f = p["actions"][0]["action_id"], json.loads(p["actions"][0]["value"])
    if action == "approve":
        v = qb("GET", "/query", params={"query": f"select * from Vendor where DisplayName = '{f['vendor']}'"})["QueryResponse"]["Vendor"][0]
        qb("POST", "/bill", json={"VendorRef": {"value": v["Id"]}, "DocNumber": f["number"], "Line": [{"Amount": f["amount"],
           "DetailType": "AccountBasedExpenseLineDetail", "AccountBasedExpenseLineDetail": {"AccountRef": {"value": "7"}}}]})
    WebClient(token=credentials.connection("slack", "work")).chat_update(channel=p["channel"]["id"], ts=p["message"]["ts"], blocks=[],
        text=f"{f['vendor']} #{f['number']} ${f['amount']:,.2f}: {action}d by <@{p['user']['id']}>")
    return {"action": action}