It’ll change the default white screen to a dark screen with better highlight and folder options for your projects.This setup is much more akin to other professional code editors like Sublime Text.GAS is by no means confined to Sheets only, and is equally applicable in the Docs environment. Google will recognize the script is not yet authorized and ask you if you want to continue. Since this the first run of the script, Google Docs asks you to authorize the script (I called my script “test” which you can see below):11. The log files can be accessed after the program has finished running, by going to and you should see: I’ve only scratched the surface of the outermost epidermis, not even millimeters deep, of what’s possible using GAS to extend the Google Apps experience.Here’s a quick example of a script that inserts a specific symbol or text string into your Doc wherever your cursor is: We do this using Google App Scripts as follows:1. Here’s a couple of interesting projects I’m working on:1) A Sheets/web-app consisting of a custom web form that feeds data into a Google Sheet (including uploading images to Drive and showing thumbnails in the spreadsheet), then creates a PDF copy of the data in the spreadsheet and automatically emails it to the users.This is a set of boilerplate scripts describing the normalized script pattern that Git Hub uses in its projects.
The main function, See here for a full step-by-step guide to creating and running this script. Use the Logger class to output text messages to the log files, to help debug code. It’s a cloud based scripting language for extending the functionality of Google Apps and building lightweight web-based applications.It means you can do cool stuff like automating repetitive tasks, creating, modifying and emailing documents to people, and linking up your Google Sheets to other data sources.bang up-to-date as of April 2016) book covering the entire GAS ecosystem, with a specific focus on making the transition from Office/VBA into Google Apps/GAS.Even if you don’t use Office or VBA much or at all, it’s still a very useful resource.