Program a google spreadsheet to send an automated email

I use google docs for managing workflow at my company. I have a google spreadsheet template that I use to create a workflow spreadsheet for each project. There are certain due dates located in cells in the spreadsheet. These due dates occasionally change during a project. I would like to be able to have a canned email be sent as a reminder sent one week prior to the due date and one day prior to the due date. It would be sent to the address or addresses found in another cell on the spreadsheet. I have another cell that already exists in the spreadsheet that indicates whether the action item has been completed. I would like another canned email to be sent if the deadline has passed and the task has not been completed. I would assume that this would be set up in a way which would easily allow me to make a copy of the template for each project and the functionality mentioned above to exist on each new spreadsheet.

Evner: Google App Engine, Javascript, Windows Skrivebord

Se mere: google spreadsheet send email, google spreadsheet email reminder, use google spreadsheet send automated reminder, automated email google spreadsheet, sent email google spreadsheet change cell, workflow one, spreadsheet javascript, spreadsheet in javascript, google. docs, docs. google, c program template, google spreadsheet deadline reminder, google spreadsheet change reminder, send reminder google spreadsheet, due date email google spreadsheet, send email google spreadsheet, email send program google, spreadsheet google, google google docs, docs.google.docs, email spreadsheet, create spreadsheet, change deadline, automated email, create google spreadsheet

Om arbejdsgiveren:
( 2 bedømmelser ) Austin, United States

Projekt ID: #967635

Tildelt til:


Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Flere

$200 USD in 20 dage
(18 bedømmelser)

3 freelancere byder i gennemsnit $217 på dette job


Hello, I'm Google Apps Script developer and I've developed several projects like that even others larger, please check my PM

$250 USD in 5 dage
(4 bedømmelser)

I develop Google Docs Scripts for business. I am located in Charlotte NC and can complete this for you quickly.

$200 USD in 5 dage
(0 bedømmelser)