Get a daily email of overdue and upcoming cards

from datetime import datetime, timedelta, timezone
from clickruntime import on_trigger, http, credentials, notify

def trello(method, path, **params):
    params.update(key=credentials.secret("TRELLO_API_KEY"), token=credentials.secret("TRELLO_TOKEN"))
    r = http.request(method, f"https://api.trello.com/1{path}", params=params)
    r.raise_for_status()
    return r.json()

@on_trigger
def run(event):
    now = datetime.now(timezone.utc)
    week = now + timedelta(days=7)
    lines = []
    for board in trello("GET", "/members/me/boards", filter="open", fields="name"):
        for c in trello("GET", f"/boards/{board['id']}/cards", fields="name,due,dueComplete,shortUrl"):
            if not c["due"] or c["dueComplete"]:
                continue
            due = datetime.fromisoformat(c["due"].replace("Z", "+00:00"))
            if due < now:
                lines.append(f"{board['name']} · OVERDUE {due:%b %d} · {c['name']} {c['shortUrl']}")
            elif due <= week:
                lines.append(f"{board['name']} · due {due:%a %b %d} · {c['name']} {c['shortUrl']}")
    notify.email_me(f"Trello: {len(lines)} cards overdue or due this week", "\n".join(sorted(lines)) or "All clear.")
    return {"cards": len(lines)}