Keep a Google Sheet of every QuickBooks invoice

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

SHEET_ID = "your-spreadsheet-id"
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):
    since = state.get("since") or "2020-01-01T00:00:00Z"
    invoices = qb("GET", "/query", params={"query": f"select * from Invoice where MetaData.LastUpdatedTime > '{since}'"})["QueryResponse"].get("Invoice", [])
    report_fetched(len(invoices))
    if not invoices:
        return {"summary": "Nothing new"}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    ids = [r[0] if r else "" for r in sheets.values().get(spreadsheetId=SHEET_ID, range="Invoices!A2:A").execute().get("values", [])]
    new = []
    for inv in invoices:
        row = [inv["Id"], inv.get("DocNumber"), inv["CustomerRef"]["name"], inv["TotalAmt"], inv.get("DueDate"), inv["Balance"]]
        if inv["Id"] in ids:
            sheets.values().update(spreadsheetId=SHEET_ID, range=f"Invoices!A{ids.index(inv['Id']) + 2}", valueInputOption="RAW", body={"values": [row]}).execute()
        else:
            new.append(row)
    if new:
        sheets.values().append(spreadsheetId=SHEET_ID, range="Invoices!A:F", valueInputOption="RAW", body={"values": new}).execute()
    state.set("since", max(i["MetaData"]["LastUpdatedTime"] for i in invoices))
    return {"updated": len(invoices) - len(new), "added": len(new)}