Add expenses from a sheet into QuickBooks

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, report_fetched

SHEET_ID = "your-spreadsheet-id"
BANK_ACCOUNT = "35"  # QuickBooks account the money is paid from
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):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Expenses!A2:F").execute().get("values", [])
    todo = [(i, r) for i, r in enumerate(rows, start=2) if len(r) >= 5 and (len(r) < 6 or not r[5])]
    report_fetched(len(todo))
    if not todo:
        return {"summary": "Nothing new"}
    accounts = {a["Name"]: a["Id"] for a in qb("GET", "/query", params={"query": "select * from Account where AccountType = 'Expense'"})["QueryResponse"]["Account"]}
    for i, (day, payee, desc, amount, category, *_) in todo:
        p = qb("POST", "/purchase", json={"PaymentType": "CreditCard", "AccountRef": {"value": BANK_ACCOUNT}, "TxnDate": day,
               "PrivateNote": f"{payee}: {desc}", "Line": [{"Amount": float(amount), "DetailType": "AccountBasedExpenseLineDetail",
               "AccountBasedExpenseLineDetail": {"AccountRef": {"value": accounts[category]}}}]})["Purchase"]
        sheets.values().update(spreadsheetId=SHEET_ID, range=f"Expenses!F{i}", valueInputOption="RAW", body={"values": [[f"Uploaded {p['Id']}"]]}).execute()
    return {"uploaded": len(todo)}