Sell with Telegram Stars and log every payment in a sheet

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

SHEET_ID = "your-spreadsheet-id"

@on_event
def handle(event):
    u = event.json or {}
    tg = f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}"
    if "pre_checkout_query" in u:
        http.post(f"{tg}/answerPreCheckoutQuery", json={"pre_checkout_query_id": u["pre_checkout_query"]["id"], "ok": True})
        return {"precheckout": "ok"}
    msg = u.get("message") or {}
    chat, uid, text = msg.get("chat", {}).get("id"), msg.get("from", {}).get("id"), msg.get("text", "")
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    log_row = lambda row: sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Payments!A:E",
        valueInputOption="USER_ENTERED", body={"values": [row]}).execute()
    if text == "/buy":
        http.post(f"{tg}/sendInvoice", json={"chat_id": chat, "title": "Pro access", "description": "30 days of Pro",
            "payload": "pro-30", "currency": "XTR", "prices": [{"label": "Pro", "amount": 100}]})
    elif "successful_payment" in msg:
        p = msg["successful_payment"]
        log_row([event.received_at, uid, p["total_amount"], p["telegram_payment_charge_id"], "paid"])
        http.post(f"{tg}/sendMessage", json={"chat_id": chat, "text": "Payment received, Pro is active."})
    elif text.startswith("/refund "):
        charge = text.split(" ", 1)[1]
        http.post(f"{tg}/refundStarPayment", json={"user_id": uid, "telegram_payment_charge_id": charge})
        log_row([event.received_at, uid, 0, charge, "refunded"])
    return {"handled": True}