Text back missed callers and log them in a sheet

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from twilio.rest import Client
from datetime import datetime, timezone
from clickruntime import on_event, credentials, http, notify

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_event
def handle(event):
    f = event.json or {}
    if f.get("CallStatus") not in ("no-answer", "busy"):
        return {"skipped": f.get("CallStatus")}
    caller = f.get("From", "")
    texted = "yes"
    try:
        sms(caller, "Sorry we missed your call! We'll call you back shortly. — Northwind Plumbing")
    except Exception:
        texted = "no"
    stamp = datetime.now(timezone.utc).isoformat(timespec="minutes")
    sheets().append(spreadsheetId=SHEET_ID, range="Missed Calls!A:C", valueInputOption="RAW", body={"values": [[stamp, caller, texted]]}).execute()
    notify.email_me(f"Missed call from {caller}", f"At {stamp}. Text sent: {texted}.")
    return {"caller": caller}