Monitor endpoints from a sheet with WhatsApp alerts

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

SHEET_ID = "your-spreadsheet-id"
MY_PHONE = "447700900123"
WA = "https://graph.facebook.com/v20.0/your-phone-number-id/messages"

def wa(to, text):
    http.post(WA, headers={"Authorization": f"Bearer {credentials.secret('WHATSAPP_TOKEN')}"},
              json={"messaging_product": "whatsapp", "to": to, "type": "text", "text": {"body": text}}).raise_for_status()

@on_trigger
def run(event):
    vals = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    urls = [r[0] for r in vals.get(spreadsheetId=SHEET_ID, range="Endpoints!A2:A").execute().get("values", []) if r]
    last, now, out = state.get("status") or {}, {}, []
    stamp = datetime.now(timezone.utc).strftime("%Y-%m-%d %H:%M")
    for url in urls:
        try:
            now[url] = http.get(url, timeout=10).status_code < 500
        except Exception:
            now[url] = False
        if url in last and last[url] != now[url]:
            wa(MY_PHONE, f"{'✅' if now[url] else '🔴'} {url} is {'back up' if now[url] else 'DOWN'}")
        out.append(["up" if now[url] else "down", stamp])
    vals.update(spreadsheetId=SHEET_ID, range=f"Endpoints!B2:C{len(urls) + 1}", valueInputOption="RAW", body={"values": out}).execute()
    state.set("status", now)
    return {"checked": len(urls)}