Get a monthly report on your monday.com leads

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

BOARD_ID = 1234567890  # your Leads board
QUERY = """query ($board: [ID!]) { boards(ids: $board) { items_page(limit: 500) { items {
  created_at column_values(ids: ["status", "text"]) { id text } } } } }"""

@on_trigger
def run(event):
    end = date.today().replace(day=1)
    start = (end - timedelta(days=1)).replace(day=1)
    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()
    items = [i for i in data["data"]["boards"][0]["items_page"]["items"] if start.isoformat() <= i["created_at"][:10] < end.isoformat()]
    status, source = Counter(), Counter()
    for item in items:
        cols = {c["id"]: c["text"] or "(blank)" for c in item["column_values"]}
        status[cols["status"]] += 1
        source[cols["text"]] += 1
    counts = f"New leads: {len(items)}\nBy status: {dict(status)}\nBy source: {dict(source)}"
    summary = ai.generate(f"Write a short summary (4 sentences) of last month's leads.\n\n{counts}", max_output_tokens=200).text
    notify.email_me(f"Leads for {start:%B}", f"{summary}\n\n{counts}")
    return {"leads": len(items)}