Log meals and macros by messaging a Telegram bot

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

SHEET_ID = "your-spreadsheet-id"
SCHEMA = {"type": "object", "properties": {k: {"type": "number"} for k in ["kcal", "protein", "carbs", "fat"]}}

@on_event
def handle(event):
    msg = (event.json or {}).get("message") or {}
    meal, chat = msg.get("text"), msg.get("chat", {}).get("id")
    if not meal:
        return {"skipped": True}
    n = ai.generate(f"Estimate nutrition for this meal: {meal}", json_schema=SCHEMA, max_output_tokens=80).json
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    today = date.today().isoformat()
    v = sheets.spreadsheets().values()
    v.append(spreadsheetId=SHEET_ID, range="Nutrition!A:F", valueInputOption="USER_ENTERED",
             body={"values": [[today, meal, n["kcal"], n["protein"], n["carbs"], n["fat"]]]}).execute()
    rows = [r for r in v.get(spreadsheetId=SHEET_ID, range="Nutrition!A:F").execute().get("values", []) if r and r[0] == today]
    tot = [sum(float(r[i]) for r in rows) for i in range(2, 6)]
    text = f"Logged. Today: {tot[0]:.0f} kcal, P {tot[1]:.0f}g, C {tot[2]:.0f}g, F {tot[3]:.0f}g"
    http.post(f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/sendMessage", json={"chat_id": chat, "text": text})
    return {"logged": meal}