Remind customers about overdue invoices and log each chase

from datetime import date, timedelta
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, notify

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):
    today = date.today()
    overdue = qb("GET", "/query", params={"query": f"select * from Invoice where Balance > '0' and DueDate < '{today}'"})["QueryResponse"].get("Invoice", [])
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    log = sheets.values().get(spreadsheetId=SHEET_ID, range="Collections!A2:B").execute().get("values", [])
    recent = {r[1] for r in log if len(r) > 1 and r[0] >= str(today - timedelta(days=7))}
    chased = []
    for inv in overdue:
        if inv["DocNumber"] in recent or not inv.get("BillEmail"):
            continue
        qb("POST", f"/invoice/{inv['Id']}/send")
        days = (today - date.fromisoformat(inv["DueDate"])).days
        chased.append([str(today), inv["DocNumber"], inv["CustomerRef"]["name"], inv["Balance"], days])
    if chased:
        sheets.values().append(spreadsheetId=SHEET_ID, range="Collections!A:E", valueInputOption="RAW", body={"values": chased}).execute()
    total = sum(i["Balance"] for i in overdue)
    notify.email_me(f"Chased {len(chased)} overdue invoices", "\n".join(f"{c[2]} #{c[1]}: ${c[3]:,.2f}, {c[4]} days late" for c in chased)
                    + f"\n\nTotal overdue: ${total:,.2f}")
    return {"overdue": len(overdue), "chased": len(chased)}