google apps script | Rainnic in the Clouds

google apps script

How to alternate colours when changes day

Submitted by Nicola Rainiero on 2018-07-02 (last updated on 2018-07-03)
How to alternate colours when changes day

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.


5 steps to auto-transfer your Calendar entries into a spreadsheet

Submitted by Nicola Rainiero on 2018-06-03 (last updated on 2018-06-10)
Instructions to generate a Google sheet from your Calendar entries

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.


An example on transfer entries from Calendar to Sheet through Google Apps Script

Submitted by Nicola Rainiero on 2018-04-22 (last updated on 2018-05-29)
An example on transfer entries from Calendar to Sheet through Google Apps Script

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.