Turn support emails into Linear issues

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai, report_fetched
TEAM_ID, DONE_LABEL = "your-linear-team-id", "your-processed-label-id"
SCHEMA = {"type": "object", "properties": {"title": {"type": "string"}, "description": {"type": "string"}, "priority": {"type": "integer"}}, "required": ["title", "description", "priority"]}

def linear(query, variables):
    return http.post("https://api.linear.app/graphql", headers={"Authorization": credentials.secret("LINEAR_API_KEY")}, json={"query": query, "variables": variables}).json()["data"]

@on_trigger
def run(event):
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    msgs = gmail.users().messages().list(userId="me", q="label:support -label:linear-done").execute().get("messages", [])
    report_fetched(len(msgs))
    if not msgs: return {"summary": "Nothing new"}
    for m in msgs:
        msg = gmail.users().messages().get(userId="me", id=m["id"], format="full").execute()
        sender = next(h["value"] for h in msg["payload"]["headers"] if h["name"] == "From")
        try:
            d = ai.generate(f"Support email from {sender}:\n{msg['snippet'][:2000]}", system="Write a Linear issue. Priority 1 urgent to 4 low.", json_schema=SCHEMA).json
        except ai.AIError:
            d = {"title": msg["snippet"][:80], "description": msg["snippet"], "priority": 3}
        found = linear("query($t: String!) { issueSearch(query: $t, first: 1, filter: {state: {type: {nin: [\"completed\", \"canceled\"]}}}) { nodes { id } } }", {"t": d["title"]})["issueSearch"]["nodes"]
        body = f"{d['description']}\n\nReported by {sender}"
        if found:
            linear("mutation($i: CommentCreateInput!) { commentCreate(input: $i) { success } }", {"i": {"issueId": found[0]["id"], "body": body}})
        else:
            linear("mutation($i: IssueCreateInput!) { issueCreate(input: $i) { success } }", {"i": {"teamId": TEAM_ID, "title": d["title"], "description": body, "priority": d["priority"]}})
        gmail.users().messages().modify(userId="me", id=m["id"], body={"addLabelIds": [DONE_LABEL]}).execute()
    return {"summary": f"{len(msgs)} emails handled"}