Import Google Calendar events as rows to the current spreadsheet, with one sheet per day and one row per event. Great for Admins.
Convert your Google Calendar entries to spreadsheet form. Admin Calendar to Spreadsheet pulls in upcoming events from the Google Calendar you select for your desired date range into the current spreadsheet, one event per row. You can either create a new sheet for each day, or put all events into the current sheet. You can add custom columns for adding notes and other details to events. Simply re-run the script to pull in new events or changes to existing events; your custom columns will remain untouched. However if an event has been deleted from the calendar it will be deleted from the spreadsheet as well.