Developing APIs using Google Apps Script
Posted on 03-11-2016 by Nadir Latif
How it works
var sheet = SpreadsheetApp.getActiveSheet();
The Google Apps Script documentation provides easy to follow 5 minute tutorials for learning Apps Script. I was able to easily follow this tutorial which allows creating a new Google Document and emailing the link.
Other uses of Apps Script include adding custom functions and user interface features to Google Apps products, interacting with external apis and Google services and connecting with external databases such as MySQL. Google Apps Script also supports triggers which are functions that are executed when certain events occur, such as opening a word document. We can easily create powerful APIs with Google Apps Script. These APIs can be consumed by different applications
Google Apps Script is an excellent platform for interacting with Google Products such as Google Sheets, Google Docs, Google Sites etc. It can also be used to extend the functionality of Google Apps.