Reminder emails

A daily email listing overdue deadlines and deadlines inside their reminder window, grouped by grant.

Turn it on

1. In the sidebar, open the bell icon.
2. Tick Send a daily email when deadlines are close.
3. Pick the hour (in the spreadsheet's time zone) and enter the addresses, separated by commas. A Google group counts as one address.
4. Optional: tick Also email each owner their own deadlines. Add owners' emails on the Lists tab first.
5. Click Save, then Send a test now to see what it looks like.

What the email contains

• Overdue open deadlines, and open deadlines within their reminder window (the row's Remind days before, or the default).
• Grouped by grant, with the type, due date, owner and days left.
• A button that opens the tracker.

Nothing is sent on days with nothing to report.

Good to know

• The email is sent from the Google account of the person who saved the settings, and runs even when the spreadsheet is closed. If someone else saves the settings later, the schedule moves to their account.
• Google limits how many emails a script can send each day: 100 recipients a day on personal Gmail accounts, more on Google Workspace. Grant Tracker allows up to 20 addresses on the list.
• Reminder emails need a license after the 14-day trial.