Auto-sync between Google sheets and Calendar

Hi! I’ve read your brief and can see that you’d like to create a Google based calendar sync. I have 5 years experience designing and developing systems using Google Office. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio. Regards, George

Hi there! I will be happy to help you with that. I have checked your attached file. We will use on edit trigger to synchronize any change happens on the sheet with your calendar, when you add, modify or delete an entry for room 1 for example, the change will be reflected on the respective calendar of room 1. I assume that you use all day events to mark room bookings on your Google calendar. To synchronize the sheet with the calendar, we will have to use time driven trigger as the calendar doesn't have any on edit or on create triggers. Unfortunately, the synchronization won't be immediate. If you want the changes on the calendar to be reflected on the sheets, we have a turnaround for this, but I will have to change my quote. I will be happy to address any of your questions! Cheers, Mohamed

Hi, I am having experience of 6 years in writing Google Script and also did same work in past i.e. syncing Google sheet with the calendar so I am sure that I will accomplish this task. Thank you for sharing a document, I have a very clear vision of your requirements and excited to be a part of this super cool project. I look forward to having healthy and fruitful business relationship with you. Thanks, Chitram