Moderate Facebook comments and log their sentiment

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai, state, notify, report_fetched

PAGE_ID, SHEET_ID = "1234567890", "your-spreadsheet-id"
G, FAQ = "https://graph.facebook.com/v21.0", "Open Tue-Sun 12-22. Book at northwind-kitchen.example/book."

@on_trigger
def run(event):
    t, seen, rows = {"access_token": credentials.connection("facebook", "work")}, set(state.get("seen") or []), []
    posts = http.get(f"{G}/{PAGE_ID}/posts", params={**t, "limit": 10}).json()["data"]
    new = [c for p in posts for c in http.get(f"{G}/{p['id']}/comments", params=t).json()["data"] if c["id"] not in seen]
    report_fetched(len(new))
    if not new:
        return {"summary": "No new comments"}
    for c in new:
        r = ai.generate(f"Facts: {FAQ}\nComment: {c['message'][:500]}", max_output_tokens=150, json_schema={"type": "object",
                        "properties": {"label": {"enum": ["spam", "question", "positive", "neutral", "negative"]}, "reply": {"type": "string"}}}).json
        if r["label"] == "spam":
            http.post(f"{G}/{c['id']}", data={**t, "is_hidden": "true"})
        elif r["label"] == "question" and r.get("reply"):
            http.post(f"{G}/{c['id']}/comments", data={**t, "message": r["reply"]})
        elif r["label"] == "negative":
            notify.email_me("Negative comment on your Page", c["message"])
        rows.append([c["created_time"], c["message"], r["label"]])
        seen.add(c["id"])
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Comments!A:C", valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    state.set("seen", list(seen)[-2000:])
    return {"handled": len(new)}