Welcome back

Joyce Mwangi

Library recovery

2 pupils due a return notice, 1 due to enter recovery, and 2 cases already open.

Single-payload recovery

Both manual ("Issue notice") and scheduled ("Sweep") triggers below build the same canonical payload — one row per overdue loan — and POST each to one thin n8n webhook (SMTP + sheet append only). No merge step, no shared agent invocation, no chance of an empty input. This replaces the previous design where a 7-day schedule + manual webhook merged into a single agent call and produced inconsistent emails when only one input fired.

Loans 30–59 days overdue. Send a return notice to the parent.

PupilBookDueOverdueAction
Emanuel Mwakasege

Sapiens — A Brief History of Humankind

Yuval Noah Harari

18 Mar 202635d
Maryam Ngowi

Born a Crime

Trevor Noah

14 Mar 202639d