raul flores jr rudimusmaximus

How To Get Started In Google Apps Script

Initially intended to extend G Suite apps, I like to think of Google Apps Script as a gateway to more kinds of development. Think of it as workflow glue and the power of programming that can interract with Google Apps and external APIs too!

Purpose

Provide a living document for whenever someone asks, " so, how do i get started with Google Apps Script?".

Working Outline

Just the orgainizing principles and some key links.

1 Starting point: Good Things to Keep in Mind

Scripts are 'bound' to a container like sheets, docs, slides or forms. These can be accessed from the containing doc and opened say in sheets by going to the menu Tools > Script editor. Scripts can also be standalone for addons or web apps. Your script home page is a dashboard found here script.google.com. The help link there will get you to an explanation of the dashboard.

	/**
	* Example use of a single pair of toast messages
	*/
	function doSomethingExample() {
	//toast(msg, title, timeoutSeconds)
	SpreadsheetApp.getActive().toast("Working...", "Doing x", 30);//message 1 longer than you need

	Utilities.sleep(8000); //8 seconds simulating work

	SpreadsheetApp.getActive().toast("Finished!","OK", 2);//message 2 interrupts message 1

	/****
	* 'SEED' THE NAMESPACES
	*****/
	var NAME$PACE1 = (function(ns) {
	ns.author = "Raul Flores, Jr";
	ns.description = "This is an example 4 level namespace."
	ns.value = "some value";
	ns.Enums = {
	ZERO: 0,
	ONE: 1,

	/**
	* quickly test our function
	*/
	function test(){
	var result = queryASpreadsheet('1sPevvtTMSd9LUptX8qdsw4VJf07nOal_1qn9JLwO4fQ',
	'Example Data',
	'A1:C',
	'SELECT A,B,C WHERE B < 7');

	var rows = result.length;//7