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.