Check a list of domains from a sheet and open Jira tickets for problems

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

JIRA, SITE = "https://api.atlassian.com/ex/jira/your-cloud-id", "https://acme.atlassian.net/browse/"
adf = lambda text: {"type": "doc", "version": 1, "content": [{"type": "paragraph", "content": [{"type": "text", "text": text}]}]}

def jira(method, path, **kw):
    resp = http.request(method, JIRA + path, headers={"Authorization": f"Bearer {credentials.connection('jira', 'work')}", "Accept": "application/json"}, **kw)
    return resp.raise_for_status() or (resp.json() if resp.content else None)

SHEET_ID = "your-spreadsheet-id"

def check(domain):
    resp = http.get(f"https://{domain}", stream=True, timeout=10)
    exp = datetime.strptime(resp.raw.connection.sock.getpeercert()["notAfter"], "%b %d %H:%M:%S %Y %Z").replace(tzinfo=timezone.utc)
    resp.close()
    return resp.status_code < 500, (exp - datetime.now(timezone.utc)).days

@on_trigger
def run(event):
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    domains = [r[0] for r in values.get(spreadsheetId=SHEET_ID, range="Domains!A2:A").execute().get("values", []) if r]
    known, results, new = state.get("known") or {}, [], []
    for d in domains:
        try:
            up, days = check(d)
            problem = None if up and days >= 21 else ("site error" if not up else f"certificate expires in {days} days")
        except Exception:
            days, problem = "", "not reachable"
        results.append([problem or "OK", days, str(date.today())])
        if problem and d not in known:
            known[d] = jira("POST", "/rest/api/3/issue", json={"fields": {"project": {"key": "OPS"}, "issuetype": {"name": "Task"}, "summary": f"{d}: {problem}"}})["key"]
            new.append(f"{known[d]} {d}: {problem}")
        elif not problem:
            known.pop(d, None)
    values.update(spreadsheetId=SHEET_ID, range="Domains!B2", valueInputOption="RAW", body={"values": results}).execute()
    if new:
        notify.slack("New site problems\n" + "\n".join(new), channel="#ops")
    state.set("known", known)
    return {"checked": len(domains), "new": len(new)}