Watch a list in Google Sheets and alert Discord when something changes

from datetime import datetime, timezone
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, state

SHEET_ID = "your-spreadsheet-id"
CHANNEL_ID = "your-discord-channel-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    urls = [r[0] for r in sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Watchlist!A2:A").execute().get("values", []) if r]
    last = state.get("last") or {}
    now = datetime.now(timezone.utc).isoformat(timespec="minutes")
    rows, flips = [], []
    for url in urls:
        try:
            status = "up" if http.get(url, timeout=10).status_code < 500 else "down"
        except Exception:
            status = "down"
        if url in last and last[url] != status:
            flips.append(f"{url} is now {status.upper()}")
        last[url] = status
        rows.append([status, now])
    sheets.spreadsheets().values().update(spreadsheetId=SHEET_ID, range="Watchlist!B2", valueInputOption="RAW", body={"values": rows}).execute()
    if flips:
        http.post(f"https://discord.com/api/v10/channels/{CHANNEL_ID}/messages", headers={"Authorization": f"Bot {credentials.secret('DISCORD_BOT_TOKEN')}"},
                  json={"content": "\n".join(flips)})
    state.set("last", last)
    return {"checked": len(urls), "changes": len(flips)}