Record every Telegram bot user in a sheet

from datetime import date
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):
    msg = (event.json or {}).get("message")
    if not msg:
        return {"skipped": True}
    user, today = msg["from"], date.today().isoformat()
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")),
                   cache_discovery=False).spreadsheets().values()
    ids = [r[0] if r else "" for r in values.get(spreadsheetId=SHEET_ID, range="Users!A2:A").execute().get("values", [])]
    if str(user["id"]) in ids:
        row = ids.index(str(user["id"])) + 2
        values.update(spreadsheetId=SHEET_ID, range=f"Users!E{row}", valueInputOption="RAW", body={"values": [[today]]}).execute()
        text = f"Welcome back, {user.get('first_name', '')}!"
    else:
        values.append(spreadsheetId=SHEET_ID, range="Users!A:E", valueInputOption="RAW", body={"values": [[
            str(user["id"]), user.get("first_name", ""), user.get("username", ""), today, today]]}).execute()
        text = f"Hi {user.get('first_name', '')}, thanks for getting in touch!"
    http.post(f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}/sendMessage",
              json={"chat_id": msg["chat"]["id"], "text": text})
    return {"new": str(user["id"]) not in ids}