Log completed monday.com items to Google Sheets

from datetime import datetime, timezone
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials, http, state

SHEET_ID = "your-spreadsheet-id"
ITEM = """query ($id: [ID!]) { items(ids: $id) { name url created_at group { title }
  column_values(ids: ["person"]) { text } } }"""
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"]

@on_event
def handle(event):
    body = event.json or {}
    if "challenge" in body:
        return {"challenge": body["challenge"]}
    ev = body.get("event", {})
    if ((ev.get("value") or {}).get("label") or {}).get("text") != "Done":
        return {"skipped": "not Done"}
    item_id = str(ev["pulseId"])
    logged = state.get("logged") or []
    if item_id in logged:
        return {"skipped": "already logged"}
    i = monday(ITEM, id=[item_id])["items"][0]
    now = datetime.now(timezone.utc)
    created = datetime.fromisoformat(i["created_at"].replace("Z", "+00:00"))
    row = [now.strftime("%Y-%m-%d %H:%M"), i["name"], i["column_values"][0]["text"] or "",
           i["group"]["title"], created.date().isoformat(), (now - created).days, i["url"]]
    sheet = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheet.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Completed!A:G",
                                         valueInputOption="USER_ENTERED", body={"values": [row]}).execute()
    state.set("logged", (logged + [item_id])[-5000:])
    return {"logged": item_id, "days_open": row[5]}