Text people on their birthday from a sheet

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from twilio.rest import Client
from datetime import date
from clickruntime import on_trigger, credentials, http, ai

SHEET_ID = "your-spreadsheet-id"
FROM = "+15005550006"

def sms(to, body):
    return Client(credentials.secret("TWILIO_ACCOUNT_SID"), credentials.secret("TWILIO_AUTH_TOKEN")).messages.create(to=to, from_=FROM, body=body)
sheets = lambda: build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()

@on_trigger
def run(event):
    rows = sheets().get(spreadsheetId=SHEET_ID, range="Customers!A2:E").execute().get("values", [])
    today, sent = date.today(), 0
    for i, r in enumerate(rows, start=2):
        name, phone, when, kind, last = (r + [""] * 5)[:5]
        if when[5:] != today.strftime("%m-%d") or last.startswith(str(today.year)):
            continue
        try:
            text = ai.generate(f"{kind or 'birthday'} for {name}", system="Write a warm one-sentence text from a local salon. No emojis.",
                               max_output_tokens=50).text.strip()
        except ai.AIError:
            text = f"Happy {kind or 'birthday'}, {name}! Wishing you a lovely day from all of us."
        sms(phone, text)
        sheets().update(spreadsheetId=SHEET_ID, range=f"Customers!E{i}", valueInputOption="RAW", body={"values": [[today.isoformat()]]}).execute()
        sent += 1
    return {"sent": sent}