Text appointment reminders and follow-ups from Airtable

from clickruntime import on_trigger, credentials, http, report_fetched

BASE_ID, FROM, BOOKING = "appXXXXXXXXXXXXXX", "+447700900000", "https://example.com/book"
FOLLOW_UP = "AND({Status}='Lead', {Followed up}=BLANK(), IS_BEFORE({Enquired}, DATEADD(TODAY(), -2, 'days')))"
REMIND = "AND({Status}='Booked', {Reminded}=BLANK(), IS_SAME({Appointment}, DATEADD(TODAY(), 1, 'days'), 'day'))"

def sms(to, body):
    sid = credentials.secret("TWILIO_ACCOUNT_SID")
    return http.post(f"https://api.twilio.com/2010-04-01/Accounts/{sid}/Messages.json",
                     auth=(sid, credentials.secret("TWILIO_AUTH_TOKEN")), data={"From": FROM, "To": to, "Body": body})

@on_trigger
def run(event):
    api = f"https://api.airtable.com/v0/{BASE_ID}/Clients"
    headers = {"Authorization": f"Bearer {credentials.connection('airtable', 'work')}"}
    leads = http.get(api, headers=headers, params={"filterByFormula": FOLLOW_UP}).json()["records"]
    booked = http.get(api, headers=headers, params={"filterByFormula": REMIND}).json()["records"]
    report_fetched(len(leads) + len(booked))
    if not leads and not booked:
        return {"sent": 0}
    for rec, kind in [(r, "lead") for r in leads] + [(r, "booked") for r in booked]:
        f = rec["fields"]
        if kind == "lead":
            body, field = f"Hi {f.get('First name', '')}, thanks for getting in touch. Book a time here: {BOOKING}", "Followed up"
        else:
            body, field = f"Hi {f.get('First name', '')}, a reminder of your appointment tomorrow at {f.get('Time', '')}.", "Reminded"
        sms(f["Phone"], body).raise_for_status()
        http.patch(api, headers=headers, json={"records": [{"id": rec["id"], "fields": {field: event.get("scheduled_time", "")[:10] or None}}]})
    return {"leads": len(leads), "reminders": len(booked)}