Moderate a Discord channel against rules in a Google Sheet

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"
GUILD_ID, CHANNEL_ID, MODS_ID = "your-server-id", "your-general-channel-id", "your-mods-channel-id"
API = "https://discord.com/api/v10/channels"

@on_trigger
def run(event):
    auth = {"Authorization": f"Bot {credentials.secret('DISCORD_BOT_TOKEN')}"}
    after = state.get("after")
    msgs = http.get(f"{API}/{CHANNEL_ID}/messages", headers=auth, params={"limit": 100, **({"after": after} if after else {})}).json()
    report_fetched(len(msgs))
    if not msgs:
        return {"summary": "Nothing new"}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    rules = [r[0] for r in sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Rules!A2:A").execute().get("values", []) if r]
    numbered = "\n".join(f"{i + 1}. {m['author']['username']}: {m['content'][:500]}" for i, m in enumerate(msgs))
    verdicts = ai.generate([f"Rules:\n" + "\n".join(rules), f"Messages:\n{numbered}",
                            "For each message number that breaks a rule, write 'number | rule'. Write NONE if none do."], max_output_tokens=300).text
    rows = []
    for line in verdicts.splitlines():
        if "|" in line and line.split("|")[0].strip().isdigit():
            m, rule = msgs[int(line.split("|")[0]) - 1], line.split("|", 1)[1].strip()
            rows.append([m["timestamp"], m["author"]["username"], m["content"][:500], rule])
            http.post(f"{API}/{MODS_ID}/messages", headers=auth, json={"content": f"Possible violation by {m['author']['username']} ({rule}): https://discord.com/channels/{GUILD_ID}/{CHANNEL_ID}/{m['id']}"})
    if rows:
        sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Violations!A:D", valueInputOption="RAW", body={"values": rows}).execute()
    state.set("after", max(msgs, key=lambda m: int(m["id"]))["id"])
    return {"checked": len(msgs), "flagged": len(rows)}