Hello World! Google App Script






In this tutorial I show you how to make a “hello world” using spreadsheets in google app script.

Step 1: Make a spreadsheet


We enter “google drive” and create a new spreadsheet:
google app script

Step 2: Open Script Editor


We go the menu > tools > script editor
google app script

Step 3: Create the onOpen function


onOpen() is a function that will run every time we open our spreadsheet
function onopen

In this feature, we’ll do the equivalent of an “alert” in javascript:

Browser.msgBox("Hello World");

function onopen

Step 4: Save the code


We select the save icon save icon google and give it a name:

tutorial google app script

Step 5: Try our function


We close the editor and refresh the spreadsheet:
hello world app script google




 
Leave a Comment
Your comment: