Follow up unhappy customers on WhatsApp

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

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

def wa_template(to, name, params):
    body = {"messaging_product": "whatsapp", "to": to, "type": "template", "template": {"name": name, "language": {"code": "en"},
            "components": [{"type": "body", "parameters": [{"type": "text", "text": str(p)} for p in params]}]}}
    return http.post(WA, headers={"Authorization": f"Bearer {credentials.secret('WHATSAPP_TOKEN')}"}, json=body).json()

@on_event
def handle(event):
    f = event.json or {}
    comment = (f.get("comments") or "")[:1500]
    mood = ai.generate(f"Rating {f.get('rating')}: {comment}", system="Reply with one word: positive, neutral or negative.",
                       max_output_tokens=5).text.strip().lower()
    row = [datetime.now(timezone.utc).isoformat(timespec="minutes"), f.get("name", ""), f.get("phone", ""), f.get("rating", ""), comment, mood]
    build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values() \
        .append(spreadsheetId=SHEET_ID, range="Feedback!A:F", valueInputOption="RAW", body={"values": [row]}).execute()
    if mood == "negative" and f.get("phone"):
        wa_template(f["phone"], "feedback_followup", [f.get("name") or "there"])
    return {"sentiment": mood}