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 the script editor.
You need to add this source code into your Code.gs file:

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

You now run the Google Apps Script.
Google wants 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 allows 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.

Translate »