Turn labelled Gmail emails into monday.com items

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

BOARD, LABEL = 1234567890, "To monday"
CREATE = """mutation ($board: ID!, $name: String!, $cols: JSON!) {
  create_item(board_id: $board, item_name: $name, column_values: $cols) { id } }"""
UPDATE = """mutation ($item: ID!, $body: String!) { create_update(item_id: $item, body: $body) { id } }"""
def monday(query, **variables):
    resp = http.post("https://api.monday.com/v2", json={"query": query, "variables": variables},
                     headers={"Authorization": credentials.secret("MONDAY_API_TOKEN"), "API-Version": "2024-10"})
    resp.raise_for_status()
    return resp.json()["data"]

def plain_text(payload):
    if payload.get("mimeType") == "text/plain" and payload.get("body", {}).get("data"):
        return base64.urlsafe_b64decode(payload["body"]["data"]).decode("utf-8", "replace")
    for part in payload.get("parts", []):
        text = plain_text(part)
        if text:
            return text
    return ""

@on_trigger
def run(event):
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    label_id = next(l["id"] for l in gmail.users().labels().list(userId="me").execute()["labels"] if l["name"] == LABEL)
    msgs = gmail.users().messages().list(userId="me", labelIds=[label_id], maxResults=25).execute().get("messages", [])
    created = []
    for m in msgs:
        full = gmail.users().messages().get(userId="me", id=m["id"], format="full").execute()
        h = {x["name"].lower(): x["value"] for x in full["payload"]["headers"]}
        sender = h.get("from", "")
        email = sender.split("<")[-1].rstrip(">").strip()
        cols = '{"email": {"email": "%s", "text": "%s"}}' % (email, email)
        item = monday(CREATE, board=BOARD, name=(h.get("subject") or "(no subject)")[:200], cols=cols)["create_item"]
        monday(UPDATE, item=item["id"], body=f"From {sender}\n\n{plain_text(full['payload'])[:20000]}")
        gmail.users().messages().modify(userId="me", id=m["id"], body={"removeLabelIds": [label_id]}).execute()
        created.append(item["id"])
    return {"created": len(created)}