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: