Setting up Google Apps Script
The first thing that needs to be done is to Install the Google Apps Script web app from the Chrome Store, using the web app for Apps Script will prevent you from losing the bookmark in your bookmarks folder in Chrome and will make it easier to open Google Apps Script when you’re using Chrome OS as you’ll be able to pin it to the Chrome OS Shelf.
The Google Apps Script IDE
The Google Apps Script may look lightweight and simple when you first open it, but from reading what Apps Script can do on the Google Developers Apps Script tutorial site it looks like a very powerful scripting language.
Creating a first Script
The first script in the tutorials
The first script in the tutorials is a simple one, but when I tried it I keep getting an error saying TypeError: Cannot find function getbody in object Document. (line 6, file “Code”)
But yet if I copy and past the code into the Apps Script editor it works without any problems what so ever.
Extending Google Sheets
The second example in the tutorials is a simple case of downloading a sample Google Sheets Spreadsheet into your Google Drive library and copying the sample code into the Apps Script editor and following the tutorial instructions for running the script. it doesn’t teach you much in the way of coding the particular Script but you can always look through the code that you’ve copied at your leisure, but the tutorial shows you some of the advanced scripts & customization that you can do with Apps Script.
In the next part I’ll go through another two maybe three of the tutorials from the Google Developers website.