Number of Events Counter per Time Slot on a Public Google Calendar

Job ID: 30763733

Budget: $30 – $250 USD

I need a simple count of number of scheduled events listed on a Google Calender. The start time and the stop time must be counted as events.

The calendar lists bookings on the hour and 1/2 hour. I need to be able to view a calendar layout showing timeslots with the number of events that have been scheduled.

Example:

The following events are scheduled for 7/31/21

10am - 2pm Event 1
10am - 12pm Event 2
10.30am - 12.30pm Event 3
11am - 2pm Event 4

I need a report that shows this:

9am 0 events
9.30am 0 events
10am 2 events
10.30am 1 event
11am 1 event
11.30am 0 events
12pm 1 event
12.30pm 1 event
1pm 0 events
1.30pm 0 events
2pm 2 events

I need to see this posted onto another Google Calendar on a Real Time basis.
Related categories: PHP JavaScript HTML Google Sheets Google APIs