Gantt chart meets google sheets timeline - For interior Design Studio

I am looking for someone to help set up a google sheet template for me that allows me to track and plan out my projects using the timeline feature in google sheets but that has dependancies linked like a traditional gantt chart. I have done some research and I would like to incorporate google sheets timeline feature, but with dependancies so It works like a traditional gantt chart so when I have a delay in a project I just need to change the date or move the card in the timeline view which with the set up dependancies will automatically alter the time line. I would need some dependancies to be fixed ie. deadlines and handovers, but others to be able to move like the stages in the design process. I would love to know how much you think this would cost for you to set up for me. Happy to give you more information on what I need included in greater detail. These are the tutorials I watched to get a gauge on whether sheets could actually do what I want and I don't definitively know that you can use dependancies like a gantt chart whilst also using the timeline feature as I couldn't find a specific tutorial for this. So please let me know if this an un-realistic ask. [login to view URL] [login to view URL] [login to view URL] Or if you have an alternative way you can recommend that will give me the same outcome. I also would love to integrate it with google calendar if that is even a possibility, so it will automatically book out the time in my calendar and my employees calendars based on what is in the spreadsheet. I don't know if this can also be used from both ends - like I move an event in google calendar and it automatically changes the date in google sheets. That is probably asking too much of it but would be unreal if that was a possibility. [login to view URL] I really appreciate you looking at this project for me and look forward to your advice on price, if I have unrealistic expectations and how long you expect it would take to create for me.