Welcome every new QuickBooks customer by email

import base64
from datetime import date
from email.message import EmailMessage
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 str(date.today())
    found = qb("GET", "/query", params={"query": f"select * from Customer where MetaData.CreateTime > '{since}'"})["QueryResponse"].get("Customer", [])
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    logged = {r[0] for r in sheets.values().get(spreadsheetId=SHEET_ID, range="Customers!A2:A").execute().get("values", []) if r}
    new = [c for c in found if c["Id"] not in logged]
    report_fetched(len(new))
    if not new:
        return {"summary": "Nothing new"}
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    for c in new:
        if c.get("PrimaryEmailAddr"):
            msg = EmailMessage()
            msg["To"], msg["Subject"] = c["PrimaryEmailAddr"]["Address"], f"Welcome to Northwind, {c['DisplayName']}"
            msg.set_content(f"Hi {c.get('GivenName') or c['DisplayName']},\n\nWelcome aboard. Invoices are due within 30 days; reply to this email with any questions.")
            gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()
    sheets.values().append(spreadsheetId=SHEET_ID, range="Customers!A:C", valueInputOption="RAW", body={"values": [[c["Id"], c["DisplayName"], str(date.today())] for c in new]}).execute()
    state.set("since", max(c["MetaData"]["CreateTime"] for c in new))
    return {"welcomed": len(new)}