Answer support questions from Supabase and log each one in a sheet

from datetime import datetime, timezone
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_event, credentials, http, ai

SHEET_ID = "your-spreadsheet-id"
SUPABASE = "https://your-project.supabase.co/rest/v1"

def sb(method, path, **kw):
    key = credentials.secret("SUPABASE_KEY")
    r = http.request(method, f"{SUPABASE}/{path}", **kw, headers={"apikey": key, "Authorization": f"Bearer {key}", "Prefer": "return=representation,resolution=merge-duplicates"})
    return r.raise_for_status() or (r.json() if r.content else None)

@on_event
def handle(event):
    question = (event.json or {}).get("question", "").strip()
    if not question:
        return {"error": "no question"}
    docs = sb("POST", "rpc/match_documents", json={"query_text": question, "match_count": 4})
    confidence = round(max((d.get("similarity", 0) for d in docs), default=0), 2)
    answer = ai.generate("Answer using only these passages; if they don't cover it, say so and suggest contacting support.\n"
                         + "\n---\n".join(d["content"][:1500] for d in docs) + f"\n\nQuestion: {question}", max_output_tokens=500).text
    build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Support Log!A:D", valueInputOption="RAW",
        body={"values": [[datetime.now(timezone.utc).isoformat(timespec="minutes"), question, answer, confidence]]}).execute()
    return {"answer": answer, "confidence": confidence}