Log TradingView alert emails to a Google Sheet

import re
from datetime import datetime, timezone
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, state, report_fetched
SHEET_ID = "your-spreadsheet-id"
PATTERN = re.compile(r"\b([A-Z]{1,6})\b.*?\b(buy|sell)\b.*?([0-9]+(?:\.[0-9]+)?)", re.I | re.S)

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    gmail = build("gmail", "v1", credentials=creds, cache_discovery=False)
    after = state.get("after") or 0
    msgs = gmail.users().messages().list(userId="me", q=f"from:noreply@tradingview.com after:{after}").execute().get("messages", [])
    msgs = [gmail.users().messages().get(userId="me", id=m["id"]).execute() for m in msgs]
    msgs = [m for m in msgs if int(m["internalDate"]) // 1000 > after]
    report_fetched(len(msgs))
    if not msgs:
        return {"logged": 0}
    rows = []
    for m in sorted(msgs, key=lambda m: int(m["internalDate"])):
        hit = PATTERN.search(m["snippet"])
        if hit:
            ts = datetime.fromtimestamp(int(m["internalDate"]) / 1000, timezone.utc).isoformat(timespec="minutes")
            rows.append([ts, hit.group(1).upper(), hit.group(2).lower(), hit.group(3)])
    if rows:
        build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(
            spreadsheetId=SHEET_ID, range="Signals!A:D", valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    state.set("after", max(int(m["internalDate"]) // 1000 for m in msgs))
    return {"logged": len(rows)}