Get warned about likely no-shows for tomorrow

from datetime import datetime, timedelta, timezone
from googleapiclient.discovery import build
from google.oauth2.credentials import Credentials
from clickruntime import on_trigger, credentials, notify

SHEET_ID, LIMIT = "your-spreadsheet-id", 2

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    day = (datetime.now(timezone.utc) + timedelta(days=1)).replace(hour=0, minute=0, second=0)
    events = build("calendar", "v3", credentials=creds, cache_discovery=False).events().list(calendarId="primary",
             timeMin=day.isoformat(), timeMax=(day + timedelta(days=1)).isoformat(), singleEvents=True).execute()["items"]
    rows = build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().get(
        spreadsheetId=SHEET_ID, range="History!A2:B").execute().get("values", [])
    misses = {r[0].lower(): int(r[1]) for r in rows if len(r) > 1}
    risky = []
    for e in events:
        for a in e.get("attendees", []):
            n = misses.get(a["email"].lower(), 0)
            if n >= LIMIT:
                risky.append(f"{e['start'].get('dateTime', '')[11:16]} {e.get('summary')} ({a['email']}, {n} no-shows)")
    notify.email_me("Tomorrow's no-show risks", "\n".join(risky) or "No high-risk appointments tomorrow.")
    return {"appointments": len(events), "risky": len(risky)}