Answer product questions by text from a sheet catalogue

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"
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 {}
    question = (f.get("Body") or "").strip()
    if not question:
        return {"skipped": "empty"}
    rows = sheets().get(spreadsheetId=SHEET_ID, range="Catalogue!A:D").execute().get("values", [])
    catalogue = "\n".join(" | ".join(r) for r in rows)[:12000]
    answer = ai.generate(question[:500], max_output_tokens=120,
                         system=f"Answer in under 300 characters using only this catalogue. If not listed, say we'll check and reply.\n{catalogue}").text
    Client(credentials.secret("TWILIO_ACCOUNT_SID"), credentials.secret("TWILIO_AUTH_TOKEN")).messages.create(
        to=f["From"], from_=f["To"], body=answer.strip())
    return {"answered": True}