Get a Telegram message when an Excel sheet changes

GRAPH = "https://graph.microsoft.com/v1.0"
TG = "https://api.telegram.org"
from clickruntime import on_trigger, credentials, http, state

SHEET = "/me/drive/root:/Shared/orders.xlsx:/workbook/worksheets/Orders/usedRange"
CHAT_ID = 123456789

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}
    values = http.get(f"{GRAPH}{SHEET}", headers=h, params={"$select": "values"}).json()["values"]
    now = {str(r[0]): [str(c) for c in r] for r in values[1:] if r and r[0] != ""}
    before = state.get("rows")
    state.set("rows", now)
    if before is None:
        return {"summary": "First snapshot saved"}
    lines = [f"➕ {' | '.join(now[k])}" for k in now if k not in before]
    lines += [f"✏️ {k}: {' | '.join(before[k])} → {' | '.join(now[k])}" for k in now if k in before and now[k] != before[k]]
    lines += [f"➖ {' | '.join(before[k])}" for k in before if k not in now]
    if lines:
        text = "Orders sheet changed:\n" + "\n".join(lines[:30])
        http.post(f"{TG}/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/sendMessage", json={"chat_id": CHAT_ID, "text": text})
    return {"changes": len(lines)}