Get Telegram alerts when a site in your sheet goes down

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

SHEET_ID = "your-spreadsheet-id"
CHAT_ID = "your-telegram-chat-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    urls = [r[0] for r in sheets.values().get(spreadsheetId=SHEET_ID, range="Sites!A2:A").execute().get("values", []) if r]
    status, column, changes = state.get("status") or {}, [], 0
    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:
            token = credentials.secret("TELEGRAM_BOT_TOKEN")
            http.post(f"https://api.telegram.org/bot{token}/sendMessage",
                      json={"chat_id": CHAT_ID, "text": f"{'✅ Back up' if up else '🔴 DOWN'}: {url}"})
            changes += 1
        status[url] = up
        column.append(["up" if up else "down"])
    sheets.values().update(spreadsheetId=SHEET_ID, range=f"Sites!B2:B{len(urls) + 1}", valueInputOption="RAW", body={"values": column}).execute()
    state.set("status", status)
    return {"checked": len(urls), "changes": changes}