Save email attachments to OneDrive and log them in Excel

GRAPH = "https://graph.microsoft.com/v1.0"
import base64
from clickruntime import on_trigger, credentials, http, state, report_fetched

LOG = "/me/drive/root:/Attachments/log.xlsx:/workbook/tables/Files/rows/add"

@on_trigger
def run(event):
    h = {"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"}
    since = state.get("since") or "2026-01-01T00:00:00Z"
    msgs = http.get(f"{GRAPH}/me/messages", headers=h, params={"$filter": f"hasAttachments eq true and receivedDateTime gt {since}",
                    "$orderby": "receivedDateTime", "$select": "id,subject,from,receivedDateTime"}).json()["value"]
    report_fetched(len(msgs))
    if not msgs:
        return {"summary": "Nothing new"}
    rows = []
    for m in msgs:
        for a in http.get(f"{GRAPH}/me/messages/{m['id']}/attachments", headers=h).json()["value"]:
            if a.get("isInline") or "contentBytes" not in a:
                continue
            item = http.put(f"{GRAPH}/me/drive/root:/Attachments/{m['receivedDateTime'][:10]} {a['name']}:/content",
                            headers=h, data=base64.b64decode(a["contentBytes"])).json()
            rows.append([m["receivedDateTime"][:16], m["from"]["emailAddress"]["address"], m["subject"], a["name"], item.get("webUrl", "")])
    if rows:
        http.post(f"{GRAPH}{LOG}", headers=h, json={"values": rows}).raise_for_status()
    state.set("since", msgs[-1]["receivedDateTime"])
    return {"saved": len(rows)}