Get a weekly CSV of your responses

import csv, io
from datetime import datetime, timedelta, timezone
from clickruntime import on_trigger, http, credentials, notify

FORM_ID = "EVENT_REGISTRATION_FORM_ID"

def typeform(method, path, **kw):
    r = http.request(method, f"https://api.typeform.com{path}",
                     headers={"Authorization": f"Bearer {credentials.secret('TYPEFORM_TOKEN')}"}, **kw)
    r.raise_for_status()
    return r.json() if r.content else None

@on_trigger
def run(event):
    fields = typeform("GET", f"/forms/{FORM_ID}")["fields"]
    since = (datetime.now(timezone.utc) - timedelta(days=7)).strftime("%Y-%m-%dT%H:%M:%SZ")
    items = typeform("GET", f"/forms/{FORM_ID}/responses", params={"since": since, "page_size": 1000})["items"]
    out = io.StringIO()
    w = csv.writer(out)
    w.writerow(["submitted_at"] + [f["title"] for f in fields])
    for r in items:
        vals = {}
        for a in r.get("answers") or []:
            v = a.get(a["type"])
            vals[a["field"]["id"]] = v.get("label") if isinstance(v, dict) else v
        w.writerow([r["submitted_at"]] + [vals.get(f["id"], "") for f in fields])
    notify.email_me(f"Event registration: {len(items)} responses this week", out.getvalue())
    return {"responses": len(items)}