Log every review to a sheet and send bad ones to Trello

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

SHEET_ID = "your-spreadsheet-id"
LIST_ID = "your-trello-list-id"
FEED_URL = "https://api.example-store.com/reviews"
SCHEMA = {"type": "object", "properties": {"sentiment": {"type": "string", "enum": ["positive", "neutral", "negative"]}, "topic": {"type": "string"}}}

@on_trigger
def run(event):
    seen = set(state.get("seen") or [])
    data = http.get(FEED_URL, headers={"Authorization": credentials.secret("REVIEWS_API_KEY")}).json()
    reviews = [r for r in data["reviews"] if str(r["id"]) not in seen]
    report_fetched(len(reviews))
    if not reviews:
        return {"summary": "Nothing new"}
    rows, auth = [], {"key": credentials.secret("TRELLO_KEY"), "token": credentials.secret("TRELLO_TOKEN")}
    for r in reviews:
        out = ai.generate(f"Classify this review.\nRating: {r['rating']}\n{r['text'][:1500]}", max_output_tokens=40, json_schema=SCHEMA).json
        rows.append([r["created_at"], r["author"], r["rating"], out["sentiment"], out["topic"], r["text"]])
        if out["sentiment"] == "negative":
            http.post("https://api.trello.com/1/cards", params={**auth, "idList": LIST_ID,
                      "name": f"{r['rating']}* {out['topic']}: {r['author']}", "desc": r["text"]})
        seen.add(str(r["id"]))
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Reviews!A:F", valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    state.set("seen", sorted(seen)[-2000:])
    return {"summary": f"{len(rows)} reviews logged"}