How it works
To use Google Apps Script you need to sign in to Google App Scripts with your Google Account. This will open a page that introduces Apps Script. Click on start scripting to continue to the script editor.
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.