Google Apps Script – addon example – part 006.

By | 26/02/2018

Today I will show you how to make a SideBar addon with Google Apps Script.
This tutorial is very simple.
Open one sheet into your google drive account.
Go to ToolsScript editor … and that will open a new tab into your browser with the script editor.
Save your sheet and your project from script editor.
You need to add this source code into your Code.gs file:

The next step is to add a html file named : openSideBar.html.
Go to FileNewHtml file and add new html file with this source code:

You now run the Google Apps script.
The Google want to have your permission to run this into Google applications area :
Display and run third-party web content in prompts and sidebars inside Google applications
This allow you to run the addon and result will be a sidebar html file, see:

Leave a Reply

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