Log a daily snapshot of your monday.com board

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

SHEET_ID, BOARD = "your-spreadsheet-id", 1234567890
ITEMS = """query ($board: [ID!]) { boards(ids: $board) { items_page(limit: 200) { items {
  id name url 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"]

def sheets():
    return build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()

@on_trigger
def run(event):
    items = monday(ITEMS, board=[BOARD])["boards"][0]["items_page"]["items"]
    today = date.today().isoformat()
    rows = []
    for i in items:
        c = {v["id"]: v["text"] for v in i["column_values"]}
        rows.append([today, i["name"], c.get("status") or "", c.get("person") or "", c.get("date") or ""])
    if rows:
        sheets().append(spreadsheetId=SHEET_ID, range="History!A:E", valueInputOption="RAW", body={"values": rows}).execute()
    return {"items": len(rows)}