GSheet - Gantt Chart was developed to offer a Gantt Chart template with simple automation to send alerts and reminders. 

There are two mandatory steps which are to update the email address of the project manager (only one) and the task owners.

Using the template, you can find the following fields:

Image Added

• Updating the start date and duration will trigger the refresh on the gantt chart. This process will take a while.

Note : Image Removedif the project manager and task owner email are not updated, there would be no possible notification sent by email