Track prices from a watch list

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from datetime import datetime, timezone
from bs4 import BeautifulSoup
from clickruntime import on_trigger, credentials, http, ai, notify

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Watchlist!A2:E").execute().get("values", [])
    now, data, deals = datetime.now(timezone.utc).strftime("%Y-%m-%d %H:%M"), [], []
    for i, row in enumerate(rows, start=2):
        name, url, target = (row + ["", "", ""])[:3]
        text = BeautifulSoup(http.get(url, timeout=15).text, "lxml").get_text(" ", strip=True)[:4000]
        raw = ai.generate(f"What is the current price of the main product on this page? Reply with a number only.\n{text}",
                          max_output_tokens=10).text.strip().replace(",", "")
        try:
            price = float(raw.lstrip("$£€"))
        except ValueError:
            continue
        data.append({"range": f"Watchlist!D{i}:E{i}", "values": [[price, now]]})
        if target and price < float(target):
            deals.append(f"{name}: {price:.2f} (target {target})\n{url}")
    sheets.values().batchUpdate(spreadsheetId=SHEET_ID, body={"valueInputOption": "RAW", "data": data}).execute()
    if deals:
        notify.email_me(f"{len(deals)} prices below target", "\n\n".join(deals))
    return {"checked": len(data), "below_target": len(deals)}