Creating a worksheet that automatically updates from outlook calendar and shared google calendar?

Please help me to create a worksheet that automatically updates from outlook calendar and shared google calendar as its data source.

Situation is that, a member of our team is assigned to create schedules in google calendar. I am tasked to get that data into a worksheet in excel as a means to track every schedule in an excel format.

I have been manually checking and typing the data into excel, is there any way that we can do do this through a formula or macro? Anything that would help the efficiency of this is greatly appreciated.