Export a monday.com board to Google Sheets hourly

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

SHEET_ID, TAB, BOARD = "your-spreadsheet-id", "Board", 1234567890
FIRST = """query ($board: [ID!]) { boards(ids: $board) { columns { id title }
  items_page(limit: 500) { cursor items { name url group { title } column_values { id text } } } } }"""
NEXT = """query ($cursor: String!) { next_items_page(limit: 500, cursor: $cursor) { cursor
  items { name url group { title } column_values { id 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_trigger
def run(event):
    board = monday(FIRST, board=[BOARD])["boards"][0]
    cols = [c for c in board["columns"] if c["id"] != "name"]
    page, items = board["items_page"], []
    while True:
        items += page["items"]
        if not page["cursor"]:
            break
        page = monday(NEXT, cursor=page["cursor"])["next_items_page"]
    rows = [["Item", "Group"] + [c["title"] for c in cols] + ["Link"]]
    for i in items:
        v = {x["id"]: x["text"] or "" for x in i["column_values"]}
        rows.append([i["name"], i["group"]["title"]] + [v.get(c["id"], "") for c in cols] + [i["url"]])
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    values.clear(spreadsheetId=SHEET_ID, range=f"{TAB}!A:ZZ").execute()
    values.update(spreadsheetId=SHEET_ID, range=f"{TAB}!A1", valueInputOption="RAW", body={"values": rows}).execute()
    return {"items": len(items), "columns": len(cols)}