Overview

checkReminder script here can be for sending emails when a task is due. This is based on script created agent86ix here - https://www.withoutthesarcasm.com/automating-google-spreadsheets-email-reminders/.

How to use this script

• Create a google spreadsheet from template - "To-do List".
• Open the script editor from "Tools" menu.
• Paste the contents of checkReminder.gs to the script editor. Replace [email protected] with your email(s).
• Save the script.
• Setup "Current Project Trigger's" to run the script daiy.
• Run the script once to test.