What would be best way to create Google calendar events from a Google sheet in my case?

See more:

Javascript

Google

MS-Excel

VBA

Im working on a home cleaning service booking sheet.

https://docs.google.com/spreadsheets/d/1A82Pvm5f4z4mMZzOLIfgmsN_Xz4Xb6Otqgpjb0Zr3p8/edit#gid=0

In it the vacation home rental owners can schedule the check in and check out dates for each property. So far so good..
Now I need to be able to send the check in and check out time and date with the name of the corresponding property to a Google Calendar.

I would be able to use Google’s CalendarAPP API to create the calendar entries with google sheet script editor.

https://www.youtube.com/watch?v=w4oUjDC9L6A&list=PLv9Pf9aNgemv62NNC5bXLR0CzeaIj5bcw&index=11

But heres where im stuck. Should I try to create a table from the existing one that formats the values (check in/out time) to a simpler table to use as an array that I can use with the API to create calendar events?

What I have tried:

Ive created calender events using google sheets API, but it was from a simple table unlike the one im using for booking the houses.