I have a google spreadsheet with all sorts of personal information and a deadline when a project needs to be completed by.
I need a script that will start sending email reminders 5 days before the person's project is due and sends email reminders each subsequent day until the deadline is reached. After the deadline no more emails required.
The email needs to have a subject line, greeting to the person, telling how many days left until completion and my email address will have to bcc-ed.
Link to spreadsheet:
Hi Your task looks very simple, but still interesting since I'm new to this freelancer platform. I'll deliver the script within 2 hours since project start. Andrey Romashev