Turn support emails into Zendesk tickets and log them

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

ZD, AGENT = "https://yourcompany.zendesk.com/api/v2", "you@yourcompany.com"

def zd(method, path, **kw):
    r = http.request(method, ZD + path, auth=(f"{AGENT}/token", credentials.secret("ZENDESK_API_TOKEN")), **kw)
    return r.raise_for_status() or (r.json() if r.content else None)

SHEET_ID = "your-spreadsheet-id"

def categorise(text):
    try: return ai.generate(text, system="One word: billing, bug, question or feedback.", max_output_tokens=5).text.strip().lower()
    except ai.AIError: return ""

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    gmail = build("gmail", "v1", credentials=creds, cache_discovery=False).users()
    seen, rows = set(state.get("seen") or []), []
    ids = [m["id"] for m in gmail.messages().list(userId="me", q="label:support newer_than:1d").execute().get("messages", []) if m["id"] not in seen]
    report_fetched(len(ids))
    if not ids:
        return {"summary": "No new emails"}
    for mid in ids:
        h = {x["name"]: x["value"] for x in (m := gmail.messages().get(userId="me", id=mid, format="full").execute())["payload"]["headers"]}
        cat = categorise(f"{h['Subject']}\n{m['snippet']}")
        t = zd("POST", "/tickets", json={"ticket": {"subject": h["Subject"], "comment": {"body": m["snippet"]},
               "requester": {"email": h["From"].split("<")[-1].strip(">"), "name": h["From"].split("<")[0].strip()}, "tags": [cat] if cat else []}})["ticket"]
        rows.append([h["Date"], h["From"], h["Subject"], cat, t["id"]])
        seen.add(mid)
    build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Intake!A:E", valueInputOption="RAW", body={"values": rows}).execute()
    state.set("seen", sorted(seen)[-2000:])
    return {"tickets": len(rows)}