Automate Calendar entries to fill out excel sheet and email completed sheet
Project detail
Events in Google Calendar automatically fill out a shift activity form (see excel sheet attached below) with the relevant information (Shift worked, event number, time, event number…. with the) for each calendar date with an entry into the calendar.
The completed form is then emailed to a specifc email address. This script would be run bi-weekly