Answer support requests from your knowledge base and log every ticket

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

SHEET_ID = "your-spreadsheet-id"
SCHEMA = {"type": "object", "properties": {"answer": {"type": "string"}, "category": {"enum": ["billing", "shipping", "account", "bug", "other"]}}}
HOST, NS = "https://kb-abc123.svc.aped-1234.pinecone.io", "help"  # your index host and namespace
def search(text, k=5):
    r = http.post(f"{HOST}/records/namespaces/{NS}/search", json={"query": {"inputs": {"text": text}, "top_k": k}}, headers={
        "Api-Key": credentials.secret("PINECONE_API_KEY"), "X-Pinecone-API-Version": "2025-04"}).json()
    return [h["fields"] for h in r["result"]["hits"]]

@on_event
def handle(event):
    t = event.json or {}
    text = str(t.get("message", ""))[:2000]
    if not text:
        return {"skipped": "empty"}
    kb = "\n\n".join(h["chunk_text"] for h in search(text, 4))
    out = ai.generate(f"Answer this support request using only the knowledge base, and categorise it.\nKB:\n{kb}\n\n"
                      f"Request: {text}", json_schema=SCHEMA, max_output_tokens=400).json
    notify.slack(f"📩 {t.get('email', 'unknown')} · {out['category']}\n>{text[:300]}\n*Suggested answer:*\n{out['answer']}", channel="#support")
    build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False) \
        .spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Support log!A:E", valueInputOption="RAW",
                                        body={"values": [[event.received_at[:16], t.get("email", ""), text, out["category"], out["answer"]]]}).execute()
    return {"category": out["category"]}