See the week's due dates grouped by owner

from collections import defaultdict
from datetime import date, timedelta
from clickruntime import on_trigger, notify, http, credentials

BOARD_ID = 1234567890  # your Client Work board
QUERY = """query ($board: [ID!]) { boards(ids: $board) { items_page(limit: 500) { items {
  name url column_values(ids: ["status", "date", "person"]) { id text } } } } }"""

@on_trigger
def run(event):
    data = http.post("https://api.monday.com/v2", headers={"Authorization": credentials.secret("MONDAY_API_TOKEN"), "API-Version": "2024-10"},
                     json={"query": QUERY, "variables": {"board": [BOARD_ID]}}).json()
    today, until = date.today().isoformat(), (date.today() + timedelta(days=7)).isoformat()
    by_owner = defaultdict(list)
    for item in data["data"]["boards"][0]["items_page"]["items"]:
        cols = {c["id"]: c["text"] for c in item["column_values"]}
        if cols.get("date") and today <= cols["date"] <= until and cols.get("status") != "Done":
            by_owner[cols.get("person") or "Unassigned"].append(f"  {cols['date']}  {item['name']}\n  {item['url']}")
    body = "\n\n".join(f"{owner}\n" + "\n".join(items) for owner, items in sorted(by_owner.items()))
    notify.email_me("Due in the next 7 days", body or "Nothing due in the next 7 days.")
    return {"owners": len(by_owner)}