Send Reminders from a To Do List in Google Spreadsheet

Send Reminders from a To Do List in Google Spreadsheet

Cancelled

Job Description

I'm working with a team of 7 people and we are using a google spreadsheet to track our team "to do" list.

I have one column that shows who the task is assigned to, the task, and then another column that has the date for when the task is due.

At the minimum, I would love a script that could email "John Smith" a day before the task is due as a reminder.

Here is an example of something similar I found: http://www.gadgetsappshacks.com/2011/09/creating-reminder-service-with-google.html

If you can think of other scripts that would make the to do list even better, I am open to hearing them.