Get alerted on low quiz scores

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

FORM_ID = "1FAIpQLSdQuizFormId"  # Onboarding Quiz
MAX_SCORE = 20
NAME_QUESTION_ID = "1a2b3c4d"

@on_trigger
def run(event):
    since = state.get("since") or "2026-01-01T00:00:00Z"
    resp = http.get(f"https://forms.googleapis.com/v1/forms/{FORM_ID}/responses",
                    params={"filter": f"timestamp > {since}"},
                    headers={"Authorization": f"Bearer {credentials.connection('google', 'work')}"})
    resp.raise_for_status()
    responses = resp.json().get("responses", [])
    report_fetched(len(responses))
    if not responses:
        return {"new": 0}
    low = []
    for r in responses:
        score = r.get("totalScore", 0) / MAX_SCORE
        if score < 0.5:
            name = r["answers"].get(NAME_QUESTION_ID, {}).get("textAnswers", {}).get("answers", [{}])[0].get("value")
            low.append(f"{name or r.get('respondentEmail', 'unknown')}: {score:.0%}")
    if low:
        notify.email_me(f"{len(low)} quiz scores under 50%", "\n".join(low))
    state.set("since", max(r["lastSubmittedTime"] for r in responses))
    return {"new": len(responses), "low": len(low)}