Reminder emails sent twice for the same task
Task Reminder Emailer · Medium · Reported Aug 30, 2026, 2:52 AM
Description
When the Tasks sheet is edited twice on the due date (e.g. someone edits an unrelated cell), sendReminderEmails() re-sends the reminder for every task due that day, not just new ones.
Steps to reproduce
1. Add a task due today with a valid email. 2. Run sendReminderEmails() (or wait for the form-submit trigger). 3. Edit any cell in the Tasks sheet. 4. Run sendReminderEmails() again.
Expected behavior
Only one reminder email is sent per task per day.
Actual behavior
A second, duplicate reminder email is sent for every task still due today.