Sync google sheet to google calendar and vise versa using google script

I have a data analysis task and integration from google sheet to calendar and vise versa using script editor of google sheet I need you to make google script in a spreadsheet that can be linked directly to google calendar So whenever i import data to the sheet it will show up in my calendar To be clear watch this you tube video to understand the idea [login to view URL] I need exactly same as the video with some customization like adding specific columns to suit my needs My request is adding the following column - surgery (text) - patient name (text) - contact number ( number ) - medical record number (numbers) - surgeon name (text) - notes ( text ) - done or not ( yes or no column , if yes it will stay in the same calendar , if no it will be shifted to other calendar that I choose in the sheet ) I need all of those data to be shown in calendar under description area ) In addition to archive sheet that record all data entered I’m doctor surgeon and i need that to organize my surgeries waiting list Thanks