Post new and changed sheet rows to Discord

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

SHEET_ID = "your-spreadsheet-id"
CHANNEL_ID = "your-discord-channel-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    rows = sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Requests!A1:Z").execute().get("values", [])
    head, hashes = rows[0], state.get("hashes") or {}
    changed = []
    for r in rows[1:]:
        if not r:
            continue
        h = hashlib.sha1(json.dumps(r).encode()).hexdigest()
        if hashes.get(r[0]) != h:
            changed.append((r, r[0] in hashes))
            hashes[r[0]] = h
    report_fetched(len(changed))
    if not changed:
        return {"summary": "Nothing new"}
    bot = {"Authorization": f"Bot {credentials.secret('DISCORD_BOT_TOKEN')}"}
    for r, updated in changed:
        fields = [{"name": k, "value": v or "-", "inline": True} for k, v in zip(head, r)]
        http.post(f"https://discord.com/api/v10/channels/{CHANNEL_ID}/messages", headers=bot,
                  json={"embeds": [{"title": ("Updated: " if updated else "New: ") + r[0], "fields": fields[:25]}]})
    state.set("hashes", hashes)
    return {"summary": f"{len(changed)} rows posted"}