Get an Outlook email when a new row is added in Excel

from clickruntime import on_trigger, report_fetched, http, credentials, ai, state

def graph(method, path, **kw):
    r = http.request(method, "https://graph.microsoft.com/v1.0" + path, headers={"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}, **kw)
    return r.raise_for_status() or (r.json() if r.content else None)

def send_mail(to, subject, text):
    graph("POST", "/me/sendMail", json={"message": {"subject": subject, "body": {"contentType": "Text", "content": text},
          "toRecipients": [{"emailAddress": {"address": a}} for a in to.split(",")]}})

BOOK = "/me/drive/items/your-workbook-id/workbook"

@on_trigger
def run(event):
    table = graph("GET", f"{BOOK}/tables/Requests")
    header = graph("GET", f"{BOOK}/tables/Requests/headerRowRange")["values"][0]
    rows = [r["values"][0] for r in graph("GET", f"{BOOK}/tables/Requests/rows")["value"]]
    seen = state.get("count")
    new = rows[seen:] if seen is not None and seen <= len(rows) else []
    report_fetched(len(new))
    if not new:
        if seen != len(rows):
            state.set("count", len(rows))
        return {"summary": "No new rows"}
    body = "\n\n".join("\n".join(f"{h}: {v}" for h, v in zip(header, r)) for r in new)
    if len(new) > 2:
        try:
            body = ai.generate(body, system="Summarise these new requests in one line.", max_output_tokens=60).text + "\n\n" + body
        except ai.AIError:
            pass
    send_mail("you@example.com", f"{len(new)} new rows in {table['name']}", body)
    state.set("count", len(rows))
    return {"new": len(new)}