Monitor websites from a sheet with email alerts

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, rows = state.get("status") or {}, []
    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.email_me(f"{url} is {'back up' if up else 'DOWN'}", f"Checked at {datetime.now(timezone.utc):%H:%M} UTC.")
            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)}