Log trading alert emails to a sheet and Telegram

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

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    gmail = build("gmail", "v1", credentials=creds, cache_discovery=False)
    seen = state.get("seen") or []
    ids = [m["id"] for m in gmail.users().messages().list(userId="me", q="from:noreply@tradingview.com newer_than:1d").execute().get("messages", [])]
    new = [i for i in ids if i not in seen]
    report_fetched(len(new))
    if not new:
        return {"new": 0}
    rows, api = [], f"https://api.telegram.org/bot{credentials.secret('TELEGRAM_BOT_TOKEN')}"
    for mid in new:
        snippet = gmail.users().messages().get(userId="me", id=mid, format="metadata").execute()["snippet"]
        m = re.search(r"(BUY|SELL)\s+(\S+)\s+at\s+([\d.]+)", snippet, re.I)
        action, ticker, price = m.groups() if m else ("?", "?", "?")
        rows.append([event.get("scheduled_time", ""), ticker, action.upper(), price])
        http.post(f"{api}/sendMessage", json={"chat_id": "your-chat-id", "text": f"{action.upper()} {ticker} at {price}"})
    build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Trades!A:D", valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    state.set("seen", (seen + new)[-500:])
    return {"new": len(new)}