Get an email when a product drops below your target price

import re
from datetime import datetime, timezone
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, state, 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()
    items = sheets.values().get(spreadsheetId=SHEET_ID, range="Watch list!A2:C").execute().get("values", [])
    below = state.get("below") or {}
    log_rows, now = [], datetime.now(timezone.utc).isoformat(timespec="minutes")
    for name, url, target in (r for r in items if len(r) == 3):
        html = http.get(url, headers={"User-Agent": "Mozilla/5.0"}).text
        m = re.search(r'"price"\s*:\s*"?([0-9]+(?:\.[0-9]+)?)', html)
        if not m:
            continue
        price = float(m.group(1))
        log_rows.append([now, name, price])
        is_below = price < float(target)
        if is_below and not below.get(url):
            notify.email_me(f"Price drop: {name} now {price}", f"{name} is {price}, below your target of {target}.\n{url}")
        below[url] = is_below
    if log_rows:
        sheets.values().append(spreadsheetId=SHEET_ID, range="Price log!A:C", valueInputOption="USER_ENTERED", body={"values": log_rows}).execute()
    state.set("below", below)
    return {"checked": len(items), "logged": len(log_rows)}