google apps script
It's time to update my Google Apps Script that exports calendar events into a spreadsheet. I use it to comparison my worked hours with the month payroll, so putting all my shifts on Google Calendar I have in automatic a sheet with all the shifts data. I added how to extract night and holiday hours and count the worked days in a range of dates.
This is the third article on the topic and if you want to know more I suggest you to read the previous posts:
I am continuing the development of my script to auto-transfer Calendar entries into a spreadsheet. In this article I show you a convenient function to change the colour of the row when changes the day of the event, useful when for example you have more than one shifts and you want to improve the readability of the table.
In the article and more accurately described in the video, I explain you how to export your calendar events into a spreadsheet using the Google Apps Script. Besides I show you the use of triggers to automate the update of the sheet when you change, add or remove an event.
I want to introduce you with a video, that show how fast and efficient is the use of Google Apps Script to automate the export of Google Calendar data into Google Sheet. Besides it is possible to instruct the code to make some calculation, change the style and do everything you want.