Create monday.com items from new sheet rows

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

SHEET_ID, BOARD = "your-spreadsheet-id", 1234567890

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 sheets():
    return build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()

@on_trigger
def run(event):
    rows = sheets().get(spreadsheetId=SHEET_ID, range="Tasks!A2:D").execute().get("values", [])
    new = [(n, r + [""] * (4 - len(r))) for n, r in enumerate(rows, start=2) if r and r[0] and (len(r) < 4 or not r[3])]
    report_fetched(len(new))
    if not new:
        return {"created": 0}
    for n, (name, due, notes, _) in new:
        cols = {"date": {"date": due} if due else None, "text": notes}
        item = monday("mutation ($b: ID!, $n: String!, $c: JSON) { create_item(board_id: $b, item_name: $n, column_values: $c) { id } }",
                      b=BOARD, n=name, c=json.dumps({k: v for k, v in cols.items() if v}))["create_item"]["id"]
        sheets().update(spreadsheetId=SHEET_ID, range=f"Tasks!D{n}", valueInputOption="RAW", body={"values": [[item]]}).execute()
    return {"created": len(new)}