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

Where to find the template ? 

Here is the link to the template of GanttChart 

To be able to edit the Gantt chart template, you will need to make a copy to your Drive.

Once you click on “Make a Copy” a new sheet will be created and can be renamed as per your requirement.

Using this template allows to automate the following actions : 

1. Send automated emails to task owner of incomplete task which is due

2. Send automated email to project manager to inform him about task completion or task overdue