Send each person their due Airtable tasks in Slack every morning

from datetime import date
from slack_sdk import WebClient
from clickruntime import on_trigger, credentials, http

BASE, TABLE = "appXXXXXXXXXXXXXX", "Tasks"

@on_trigger
def run(event):
    key = credentials.secret("AIRTABLE_API_KEY")
    formula = "AND({Status} != 'Done', IS_BEFORE({Due}, DATEADD(TODAY(), 1, 'days')))"
    recs = http.get(f"https://api.airtable.com/v0/{BASE}/{TABLE}", headers={"Authorization": f"Bearer {key}"},
                    params={"filterByFormula": formula}).json()["records"]
    by_person = {}
    for r in recs:
        f = r["fields"]
        if f.get("Assignee email"):
            by_person.setdefault(f["Assignee email"], []).append(f"• {f.get('Name')} (due {f.get('Due')})")
    slack = WebClient(token=credentials.connection("slack", "work"))
    sent, missing = 0, []
    for email, lines in by_person.items():
        try:
            uid = slack.users_lookupByEmail(email=email)["user"]["id"]
        except Exception:
            missing.append(email)
            continue
        slack.chat_postMessage(channel=uid, text=f"Your tasks for {date.today():%A}:\n" + "\n".join(lines))
        sent += 1
    return {"sent": sent, "no_slack_match": missing}