Answer WhatsApp questions from a product sheet

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

SHEET_ID = "your-spreadsheet-id"
WA = "https://graph.facebook.com/v20.0/your-phone-number-id/messages"

def wa(to, text):
    http.post(WA, headers={"Authorization": f"Bearer {credentials.secret('WHATSAPP_TOKEN')}"},
              json={"messaging_product": "whatsapp", "to": to, "type": "text", "text": {"body": text}}).raise_for_status()
def incoming(event):
    changes = [c for e in (event.json or {}).get("entry", []) for c in e.get("changes", [])]
    return [(m["from"], m["text"]["body"]) for c in changes for m in c["value"].get("messages", []) if m.get("type") == "text"]

@on_event
def handle(event):
    rows = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False) \
        .spreadsheets().values().get(spreadsheetId=SHEET_ID, range="FAQ!A:D").execute().get("values", [])
    facts = "\n".join(" | ".join(r) for r in rows)[:12000]
    for phone, text in incoming(event):
        history = state.get(f"h:{phone}") or []
        answer = ai.generate("\n".join(history[-6:] + [f"Customer: {text}"]), max_output_tokens=200,
                             system=f"Answer briefly using only these facts. If unsure, say you'll check with the team.\n{facts}").text.strip()
        wa(phone, answer)
        state.set(f"h:{phone}", (history + [f"Customer: {text}", f"You: {answer}"])[-6:])
    return {"ok": True}