This is a good tutorial on manipulating a Google Sheet into a Gantt Chart.
Google Sheet - Gantt Chart Template