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… Continue Reading Google Apps Script – set colors by row – part 024.

This Google Apps Script tutorial will show you how to search for videos from YouTube. First, you need to run this script with and YouTube Data A.P.I. and one Spreadsheet. The script will get the title and id of the first 50 videos info and the result is put into… Continue Reading Google Apps Script – search videos by channel – part 023.

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 –… Continue Reading Google Apps Script – calendar example – part 022.

If you want to hide a function for the run area in Select function, then you can use in the end of declaration the underscore character _: This example will hide the addBookmark_ function from Select function area:

This simple apps script can get an image from the web , save it and return the URL from Google Drive.

This type of new redirect link to the new project is a new way to write permissions to google apps script. This new way comes when you use the steps: – create a document; – write source code; – try to have permission to google account; This can be fixed… Continue Reading Security – Insecure redirect new project by Google Apps Script.

We apologize for missing items or if some are still incomplete. The free-tutorials.org website has been targeting attacks in the past. Most of them resulted in language changes and the deletion of the source code. The attacker targeted specifically java source code for Android and malicious language to English. The… Continue Reading The free-tutorials.org website has been attacked.

Translate »