Tag Archives: Google Apps Script

Google Apps Script

Google Apps Script – read old emails from gmail category – part 018.

This tutorial shows you how to read old emails from category Forums by a number of days. The script is simple and has just one function. I started like any project with one document and one new script with authorization of Gmail.’ You can read these steps with my old tutorials. Let’s see the script:… Read More »

Google Apps Script – add bookmark – part 017.

This simple script will add a bookmark into your page and will insert a text into the document project. The script needs to have the fix_cursor() add into the scripting area to avoid the crash cursor. The fix_cursor() source code can be found on my previews tutorial. Let’s see the script:

1
2
3
4
5
6
7
8
9
function addBookmark() {
var doc = DocumentApp.getActiveDocument();
var cursor = doc.getCursor();
fix_cursor()
var element = cursor.getElement();
var bookmark = doc.addBookmark(cursor);
var element = cursor.insertText('ಠ‿ಠ');
Logger.log(bookmark.getId());
}

Google Apps Script – fix cursor – part 016.

This function will fix the crash of the cursor when you try to insert elements or add bookmarks.

JavaScript
1
2
3
4
5
6
7
8
9
function fix_cursor(){
// get the cursor position stored by onCursorMove()
var properties = PropertiesService.getScriptProperties();
var position = properties.getProperty("position");
if (position !== null){
    // set cursor to last-stored position
    doc.setCursor(doc.newPosition(text, position));
  }
}

Google Apps Script – show all connections with People A.P.I. – part 015.

This tutorial is about Google Apps Script with People A.P.I. You need to create a new document into Google Driver to create a project script for Google Apps Script. Use Tools – Script editor on this document. Into the new tab go to Resources – Advanced Google Services and activate People API v1. Take a look… Read More »