Category Archives: javascript

Google Apps Script – set colors – part 024.

This tutorial will show you how to alternate the colors by row. The first part will select by variables the active Spreadsheet, the sheet named Sheet1 and the range area. The for loop will parse all rows by modulo and set a variable named range_input. The color are changed by the setBackgrounds.

This is… Read More »

Google Apps Script – calendar example – part 022.

This is another example with Google Apps Script and Calendar A.P.I. The A.P.I. reference calendar can be found at the official webpage. This simple example gets all your calendars and put into Logger.

The output can be seen on Logger from the main menu of script.google.com with View – Logs or pressing Ctrl +… Read More »