Spot upsell chances in support tickets

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

ZOHO = "https://www.zohoapis.com/crm/v6"

@on_trigger
def run(event):
    since = state.get("since") or "2026-01-01T00:00:00Z"
    tickets = http.get("https://support.acme.example/api/tickets", params={"created_after": since},
                       headers={"Authorization": f"Bearer {credentials.secret('HELPDESK_API_KEY')}"}).json()["tickets"]
    report_fetched(len(tickets))
    if not tickets:
        return {"summary": "No new tickets"}
    zh = {"Authorization": f"Zoho-oauthtoken {credentials.connection('zoho', 'work')}"}
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    for t in tickets:
        r = ai.generate(f"Is this support ticket an upsell opportunity? {t['body'][:1500]}", max_output_tokens=80,
                        json_schema={"type": "object", "properties": {"score": {"type": "integer"}, "reason": {"type": "string"}}}).json
        if r["score"] < 7:
            continue
        contact = http.get(f"{ZOHO}/Contacts/search", headers=zh, params={"email": t["email"]}).json()["data"][0]
        http.post(f"{ZOHO}/Notes", headers=zh, json={"data": [{"Parent_Id": {"id": contact["id"]}, "$se_module": "Contacts",
                                                                "Note_Content": f"Upsell signal: {r['reason']}"}]})
        http.post(f"{ZOHO}/Tasks", headers=zh, json={"data": [{"Subject": f"Upsell follow-up: {t['subject']}", "What_Id": {"id": contact["id"]}}]})
        raw = f"To: sales@acme.example\r\nSubject: Upsell signal from {t['email']}\r\n\r\n{r['reason']}\n\nTicket: {t['subject']}"
        gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(raw.encode()).decode()}).execute()
    state.set("since", tickets[-1]["created_at"])
    return {"checked": len(tickets)}