Get a daily email of Wix form submissions

from collections import defaultdict
from datetime import datetime, timezone, timedelta
from clickruntime import on_trigger, credentials, http, notify, report_fetched

SITE_ID = "your-site-id"
FIELDS = ["first_name", "last_name", "email", "phone", "message"]

@on_trigger
def run(event):
    since = (datetime.now(timezone.utc) - timedelta(days=1)).isoformat()
    resp = http.post("https://www.wixapis.com/form-submission-service/v4/submissions/query",
                     headers={"Authorization": credentials.secret("WIX_API_KEY"), "wix-site-id": SITE_ID},
                     json={"query": {"filter": {"namespace": "wix.form_app.form", "_createdDate": {"$gt": since}},
                                     "sort": [{"fieldName": "_createdDate", "order": "ASC"}], "cursorPaging": {"limit": 100}}})
    resp.raise_for_status()
    subs = resp.json().get("submissions", [])
    report_fetched(len(subs))
    forms = {f["id"]: f["name"] for f in http.post("https://www.wixapis.com/form-schema-service/v4/forms/query",
             headers={"Authorization": credentials.secret("WIX_API_KEY"), "wix-site-id": SITE_ID},
             json={"query": {}, "namespace": "wix.form_app.form"}).json().get("forms", [])}
    groups = defaultdict(list)
    for s in subs:
        f = s["submissions"]
        name = f"{f.get('first_name', '')} {f.get('last_name', '')}".strip() or "No name"
        phone = f", {f['phone']}" if f.get("phone") else ""
        extra = "; ".join(f"{k}: {v}" for k, v in f.items() if k not in FIELDS and v)
        groups[forms.get(s["formId"], "Form")].append(
            f"- {name} <{f.get('email', 'no email')}>{phone}: {str(f.get('message', ''))[:300]} {extra}".rstrip())
    body = "\n\n".join(f"{form} ({len(rows)})\n" + "\n".join(rows) for form, rows in groups.items())
    notify.email_me(f"{len(subs)} Wix form submissions yesterday", body or "No form submissions in the last 24 hours.")
    return {"submissions": len(subs)}