Text a receipt photo to log it in a sheet

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

SHEET_ID = "your-spreadsheet-id"
SCHEMA = {"type": "object", "properties": {"date": {"type": "string"}, "supplier": {"type": "string"}, "total": {"type": "number"}}, "required": ["date", "supplier", "total"]}
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)

@on_event
def handle(event):
    f = event.json or {}
    if not f.get("MediaUrl0"):
        sms(f.get("From"), "Please send a photo of the receipt.")
        return {"skipped": "no media"}
    img = http.get(f["MediaUrl0"], auth=(credentials.secret("TWILIO_ACCOUNT_SID"), credentials.secret("TWILIO_AUTH_TOKEN"))).content
    r = ai.generate(["Read this receipt: date (YYYY-MM-DD), supplier, total.", base64.b64encode(img).decode()[:30000]],
                    json_schema=SCHEMA, max_output_tokens=80).json
    build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values() \
        .append(spreadsheetId=SHEET_ID, range="Expenses!A:D", valueInputOption="USER_ENTERED",
                body={"values": [[r["date"], r["supplier"], r["total"], f["From"]]]}).execute()
    sms(f["From"], f"Logged {r['supplier']} {r['total']:.2f} on {r['date']}")
    return {"logged": r["supplier"]}