Post new form responses in Slack

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

FORM_ID = "1FAIpQLSdExampleFormId"  # Event Signup
API = f"https://forms.googleapis.com/v1/forms/{FORM_ID}"

@on_trigger
def run(event):
    headers = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    since = state.get("since") or "2026-01-01T00:00:00Z"
    responses = http.get(f"{API}/responses", headers=headers,
                         params={"filter": f"timestamp > {since}"}).json().get("responses", [])
    report_fetched(len(responses))
    if not responses:
        return {"new": 0}
    form = http.get(API, headers=headers).json()
    titles = {i["questionItem"]["question"]["questionId"]: i["title"] for i in form["items"] if "questionItem" in i}
    for r in sorted(responses, key=lambda r: r["lastSubmittedTime"]):
        lines = [f"*{titles.get(q, q)}*: {', '.join(x.get('value', '') for x in a['textAnswers']['answers'])}"
                 for q, a in r.get("answers", {}).items() if "textAnswers" in a]
        notify.slack("New Event Signup response\n" + "\n".join(lines), channel="#events")
    state.set("since", max(r["lastSubmittedTime"] for r in responses))
    return {"new": len(responses)}