Google Apps ScriptTag Archive

Google Apps Script

This is an update the last tutorial about Google Apps Script and shows you how to use App First, you need to update your Advanced Google services. Open an empty google document text or spreadsheet and using the main menu to open the Script editor from the menu Tools. You… Continue Reading Google Apps Script – get tasks – part 026.

Open a new spreadsheet with a Sheet named Sheet3, then a new script. This will require a new project. Also, you can run it with an old project. Use this function to add a blue color on each empty cell selected by your mouse in the Sheet3. You can see… Continue Reading Google Apps Script – get tasks – part 027.

This tutorial solves this issue about how to parse a text document open by an Id and put the output into a Spreadsheet. The input text from the text document must have four signed number delimited with a comma like as regular expression variable named r from source code:

JavaScript
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
function write() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var doc = DocumentApp.openById('123xyzTimp\oOBb|hH...');
  var text = doc.getBody().getText();
  var result = [];
  var r = /[+-]?\d+,[+-]?\d+,[+-]?\d+,[+-]?\d+/g
  while ((res = r.exec(text)) !== null) {
    //result.push([res[0]].toString());
    result.push([res[0]].toString().split(","));
    Logger.log(result);
    }
 
  //ss.getRange(row, column, numRows, numColumns)
  ss.getRange(ss.getLastRow() + 1, 1, result.length, 4).setValues(result);
}

This simple example uses Advanced Google services with Task API version 1. You can enable this API from menu Resources – Advanced Google services into your Google Apps Script project. The script is simple, takes title and id of your tasks, and is put on logs system. You can view… Continue Reading Google Apps Script – get tasks – part 025.

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 – 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.

JavaScript
1
2
3
4
5
6
7
function get_calendars() {
  var calendars = CalendarApp.getAllCalendars();
  for (var i = 0; i < calendars.length; i++) {
    var calendar = calendars[i];
    Logger.log(calendar.getName());
  }
}

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:

1
function addBookmark_()