Welcome back

Sr. Mary Joseph Kileo

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
Elizabeth Mosha

Sapiens — A Brief History of Humankind

Yuval Noah Harari

18 Mar 202635d
Margaret Kagaruki

Born a Crime

Trevor Noah

14 Mar 202639d