Email reminders for Airtable records due today

import base64
from email.message import EmailMessage
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http

def send(gmail, to, subject, text):
    msg = EmailMessage()
    msg["To"], msg["Subject"] = to, subject
    msg.set_content(text)
    gmail.users().messages().send(userId="me", body={"raw": base64.urlsafe_b64encode(msg.as_bytes()).decode()}).execute()

@on_trigger
def run(event):
    url = "https://api.airtable.com/v0/appYourBaseId/Contacts"
    headers = {"Authorization": f"Bearer {credentials.secret('AIRTABLE_API_KEY')}"}
    records = http.get(url, headers=headers, params={
        "filterByFormula": "AND(IS_SAME({Next action date}, TODAY(), 'day'), NOT({Reminded}))"}).json()["records"]
    if not records:
        return {"due": 0}
    lines = [f"- {r['fields'].get('Name')}: {r['fields'].get('Next action')}" for r in records]
    gmail = build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    send(gmail, "me", f"{len(records)} actions due today", "\n".join(lines))
    for i in range(0, len(records), 10):
        http.patch(url, headers=headers, json={"records": [{"id": r["id"], "fields": {"Reminded": True}} for r in records[i:i + 10]]})
    return {"due": len(records)}