Email reminders — one-time setup

Reminders are sent by a small Google Apps Script attached to a Google Sheet (same approach as the Finance Dashboard). Once set up, a reminder email goes out every morning listing overdue tasks and tasks due today & tomorrow — even when this site is closed.

1. Create a new Google Sheet (e.g. LU Tasks).
2. Open Extensions → Apps Script, delete the sample code, and paste the script — Copy Script Download Script
3. Deploy → New deployment → Web app — Execute as Me, access Anyone. Copy the /exec URL below.
4. In Apps Script, open Triggers (clock icon) → Add Trigger → function sendReminders → Time-driven → Day timer → 7–8am.