Flag stalled HubSpot deals with a suggested follow-up

import time
from datetime import date
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai, notify, state
SHEET_ID = "1AbCdEfGhIjKlMnOpQrStUvWxYz"
def hs(method, path, **kw):
    r = http.request(method, f"https://api.hubapi.com{path}", headers={"Authorization": f"Bearer {credentials.connection('hubspot', 'work')}"}, **kw)
    return r.raise_for_status() or (r.json() if r.content else {})

@on_trigger
def run(event):
    cutoff = str(int((time.time() - 14 * 86400) * 1000))
    deals = hs("POST", "/crm/v3/objects/deals/search", json={"filterGroups": [{"filters": [{"propertyName": "hs_is_closed", "operator": "EQ", "value": "false"},
               {"propertyName": "notes_last_updated", "operator": "LT", "value": cutoff}]}], "properties": ["dealname", "dealstage", "amount", "notes_last_updated"], "limit": 50})["results"]
    flagged = state.get("flagged") or {}
    new = [d for d in deals if flagged.get(d["id"]) != d["properties"].get("notes_last_updated")]
    if not new:
        return {"stalled": 0}
    rows = []
    for d in new:
        p = d["properties"]
        tip = ai.generate(f"Suggest a 2-sentence follow-up email to restart this stalled deal: {p['dealname']}, stage {p['dealstage']}, amount {p.get('amount')}.", max_output_tokens=120).text.strip()
        rows.append([date.today().isoformat(), p["dealname"], p.get("amount"), p["dealstage"], tip])
        flagged[d["id"]] = p.get("notes_last_updated")
    build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Stalled deals!A1", valueInputOption="RAW", body={"values": rows}).execute()
    notify.slack(f"{len(new)} deals have gone quiet for 14 days:\n" + "\n".join(f"- {r[1]} ({r[2]}): {r[4]}" for r in rows), channel="#sales")
    state.set("flagged", flagged)
    return {"stalled": len(new)}