Free Task Reminder with Email Alerts – Google Apps Script

A task reminder app that emails you before a deadline rather than showing you a list you forgot to open. Reminders go out three times — six days, three days and one day before — which is the part that makes it useful: a task list only works if it reaches you without being visited.

What it does

Tasks are created, edited and deleted from a web dashboard backed by Google Sheets. Each one carries a deadline, and the system sends automatic email notifications at six, three and one day out. The dashboard shows live counts of total, active and expired reminders, and every row is colour-coded by status — safe, warning or expired — so the things about to go wrong are visible at a glance rather than found by reading dates. Any list exports to CSV, Excel or PDF.

Highlights

• Create, edit and delete reminders
• Automatic emails at 6, 3 and 1 day before the deadline
• Live dashboard: total, active and expired
• Colour-coded status highlighting
• One-click export to CSV, Excel and PDF
• Google Sheets as the central task list

Who it is for

Anyone tracking dated obligations — renewals, licences, contracts, follow-ups, deliverables and personal deadlines — where missing the date has a cost and nobody is going to check a spreadsheet every morning.