Log expenses from Telegram messages to Google Sheets

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

SHEET_ID, OWNER = "your-sheet-id", 123456789
CATS = {"Food": ["lunch", "dinner", "coffee", "grocer"], "Transport": ["fuel", "taxi", "uber", "train", "parking"],
        "Home": ["rent", "power", "internet"], "Fun": ["cinema", "concert", "game"]}

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_event
def handle(event):
    msg = (event.json or {}).get("message", {})
    chat, text = msg.get("chat", {}).get("id"), (msg.get("text") or "").strip()
    m = re.match(r"^(\d+(?:[.,]\d{1,2})?)\s+(.+)$", text)
    if chat != OWNER or not m:
        if chat == OWNER:
            tg("sendMessage", chat_id=chat, text="Send an amount then a note, e.g. 12.50 lunch")
        return {"skipped": True}
    amount, note = float(m[1].replace(",", ".")), m[2]
    cat = next((c for c, words in CATS.items() if any(w in note.lower() for w in words)), "Other")
    day = datetime.fromtimestamp(msg["date"], timezone.utc).strftime("%Y-%m-%d")
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    values.append(spreadsheetId=SHEET_ID, range="Expenses!A:D", valueInputOption="USER_ENTERED",
                  body={"values": [[day, amount, cat, note]]}).execute()
    rows = values.get(spreadsheetId=SHEET_ID, range="Expenses!A2:B").execute().get("values", [])
    total = sum(float(r[1]) for r in rows if len(r) > 1 and r[0][:7] == day[:7])
    tg("sendMessage", chat_id=chat, text=f"Added {amount:.2f} · {cat} · {note}\n{datetime.strptime(day, '%Y-%m-%d'):%B} so far: {total:,.2f}")
    return {"amount": amount, "category": cat}