Get a Telegram message when a Google Sheet gets a new row

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

SHEET_ID, TAB, CHAT_ID = "your-sheet-id", "Orders", "123456789"
COLUMNS = ["Name", "Product", "Amount", "Phone"]

def tg(method, **params):
    r = http.post(f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/{method}", json=params)
    r.raise_for_status()
    return r.json()["result"]

@on_trigger
def run(event):
    rows = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values().get(
        spreadsheetId=SHEET_ID, range=f"{TAB}!A:Z").execute().get("values", [])
    if not rows:
        return {"new": 0}
    header, data = rows[0], rows[1:]
    seen = state.get("rows")
    if seen is None:  # first run: start from now
        state.set("rows", len(data))
        return {"new": 0}
    new = data[seen:]
    for row in new:
        rec = dict(zip(header, row + [""] * (len(header) - len(row))))
        lines = [f"{c}: {rec.get(c, '')}" for c in COLUMNS if rec.get(c)]
        tg("sendMessage", chat_id=CHAT_ID, text=f"🆕 New row in {TAB}\n" + "\n".join(lines))
    state.set("rows", len(data))
    return {"new": len(new)}