Add rows to an Excel table from Telegram messages

import re
from datetime import date
from clickruntime import on_trigger, credentials, http, state

GRAPH = "https://graph.microsoft.com/v1.0"
TG = "https://api.telegram.org"
TABLE = "/me/drive/root:/Finance/log.xlsx:/workbook/tables/Log/rows"
MY_CHAT = 123456789

def tg(method, **body):
    return http.post(f"{TG}/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/{method}", json=body).json()

@on_trigger
def run(event):
    offset = state.get("offset") or 0
    updates = tg("getUpdates", offset=offset, timeout=0).get("result", [])
    h = {"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}
    added = 0
    for u in updates:
        offset = u["update_id"] + 1
        msg = u.get("message") or {}
        if msg.get("chat", {}).get("id") != MY_CHAT or "text" not in msg:
            continue
        m = re.match(r"^\s*(\d+(?:[.,]\d{1,2})?)\s+(.+)$", msg["text"])
        if not m:
            tg("sendMessage", chat_id=MY_CHAT, text="Send an amount then a note, e.g. 12.50 taxi to airport")
            continue
        amount, note = float(m.group(1).replace(",", ".")), m.group(2).strip()
        http.post(f"{GRAPH}{TABLE}", headers=h, json={"values": [[date.today().isoformat(), amount, note]]}).raise_for_status()
        tg("sendMessage", chat_id=MY_CHAT, text=f"✅ Added to Log: {date.today()} · {amount:.2f} · {note}")
        added += 1
    state.set("offset", offset)
    return {"added": added}