Turn support emails into Trello cards and flag urgent ones in Slack

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

LIST_ID = "your-trello-list-id"
LABELS = {"urgent": "urgent-label-id", "normal": "normal-label-id", "low": "low-label-id"}

@on_trigger
def run(event):
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    seen = state.get("seen") or []
    found = gmail.users().messages().list(userId="me", q="to:support newer_than:1d").execute().get("messages", [])
    ids = [m["id"] for m in found if m["id"] not in seen]
    report_fetched(len(ids))
    if not ids:
        return {"summary": "Nothing new"}
    auth = {"key": credentials.secret("TRELLO_KEY"), "token": credentials.secret("TRELLO_TOKEN")}
    for mid in ids:
        m = gmail.users().messages().get(userId="me", id=mid, format="metadata", metadataHeaders=["From", "Subject"]).execute()
        h = {x["name"]: x["value"] for x in m["payload"]["headers"]}
        try:
            p = ai.generate(f"Support email: {h.get('Subject')}\n{m['snippet']}\nAnswer one word: urgent, normal or low.", max_output_tokens=5).text.strip().lower()
        except ai.AIError:
            p = "normal"
        p = p if p in LABELS else "normal"
        http.post("https://api.trello.com/1/cards", params={**auth, "idList": LIST_ID, "name": h.get("Subject", "(no subject)"),
                  "desc": f"From {h.get('From')}\n\n{m['snippet']}", "idLabels": LABELS[p]})
        if p == "urgent":
            notify.slack(f"Urgent support email from {h.get('From')}: {h.get('Subject')}", channel="#support")
        seen.append(mid)
    state.set("seen", seen[-500:])
    return {"summary": f"{len(ids)} cards created"}