Monitor a list of websites from a sheet

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)
    urls = [r[0] for r in sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Sites!A2:A")
            .execute().get("values", []) if r]
    status = state.get("status") or {}
    rows = []
    for url in urls:
        try:
            up = http.get(url, timeout=10).status_code < 500
        except Exception:
            up = False
        if url in status and status[url] != up:
            notify.slack(f"{'✅' if up else '🔴'} {url} is {'back up' if up else 'DOWN'}", channel="#ops")
            rows.append([datetime.now(timezone.utc).isoformat(timespec="minutes"), url, "up" if up else "down"])
        status[url] = up
    if rows:
        sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Outages!A:C",
                                              valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    state.set("status", status)
    return {"checked": len(urls), "changes": len(rows)}