Custom menu named Activate / Deactivate notifications will be added on the menu bar with 3 actions : 




Authorize email 


By clicking on authorize email, you allow Google to send you emails


Activate notifications : 

By activating this notification, email notifications will be sent to the task owner and project manager in the following conditions : 


The daily  function trigger ( everyday 9 AM ) will send automated emails 





Deactivate notifications

With this function, there will be no notification emails


Column I has been Protected because it has information on the Mails that is been sent to the manager. Since the request had criteria to send mail to manager on task completing only once, we had to store the data in some place, and yet not to be tampered by the users. 

As a solution for the above issue, we have given permission only for the owners to make changes to column I. We Hidden this column, so that user will not have the knowledge of this column existence.