Text new leads instantly and log them in a sheet

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

SHEET_ID = "your-spreadsheet-id"
MY_PHONE = "+447700900123"
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 "Body" in f:
        rows = sheets().get(spreadsheetId=SHEET_ID, range="Leads!A2:B").execute().get("values", [])
        row = next((i for i, r in enumerate(rows, start=2) if len(r) > 1 and r[1] == f["From"]), None)
        if row is None:
            return {"skipped": "unknown number"}
        rating = ai.generate(f["Body"][:500], system="Rate this lead's reply: hot, warm or cold. One word.", max_output_tokens=5).text.strip().lower()
        sheets().update(spreadsheetId=SHEET_ID, range=f"Leads!D{row}:E{row}", valueInputOption="RAW", body={"values": [[f["Body"], rating]]}).execute()
        if rating == "hot":
            sms(MY_PHONE, f"🔥 Hot lead {rows[row - 2][0]} {f['From']}: {f['Body'][:200]}")
        return {"rating": rating}
    sheets().append(spreadsheetId=SHEET_ID, range="Leads!A:C", valueInputOption="RAW",
                    body={"values": [[f.get("name", ""), f.get("phone", ""), f.get("message", "")]]}).execute()
    sms(f["phone"], f"Hi {f.get('name', 'there')}, thanks for your enquiry! When are you hoping to get the work done?")
    return {"lead": f.get("phone")}