Google Apps Script – Creating UI – part 001.

What is the Google Apps Script?

It’s a JavaScript cloud scripting language that extends Google Apps and provides easy ways to automate tasks across Google products and third party services.

So you can deal with all Google products like docs, Gmail, calendar, maps, etc. to make all good for you.

Now it’s three ways users access UI developed in Apps Script :

– Google spreadsheet

– Google sites

– standalone – can be accessed by URL

It’s two types of apps Script UI Objects.


-form panel

-horizontal panel

-vertical panel

-flow panel

-… and more


-text box




-text area

-radio buttons

-… and more

How to using panels in the right way…

First, you need to create the application. See the script:

You can also create one horizontal panel

… or maybe if you want a flow panel

Let’s make one simple script example to show you how to do it.

First, open one new spreadsheet in your google drive account.

Go to Menu – Tools -> Script Editor, see the next image:


Select Blank Project …


You will have one new tab in your browser, this will be the editor to write your script.


Write in this editor this script.

Save the script and try to run button (will see something like one play button in the menu).

First time when you try to run the project will need some authorization. Be agree. apps script authorization
In the tab browser with your spreadsheet will see this:


The next step is to make one function to handle user action.

The handlers are used to wire user response to Apps Script functions.

This it’s the full source script :

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.