Google Apps Script: Create an Add-On

Google Apps Script: Create an Add-On

Create an add on (1)

Create an Add-On Menu

For most of my scripts I have written you access the script through the Add-On menu. In my group maker script you create a copy of the template and then go to the Add-On menu to locate “Group Maker.” You can create your own Add-On for your scripts you create.
2015-11-24_14-43-20

The scripts are attached to the document, meaning the Add-on you create is not available by searching the Add-on marketplace. For others to access your script, you need to provide them a copy of the document.

Add-On Menu Template

I created a template of the Google Apps Script code to copy and paste into your own document.

tinyurl.com/addonmenu

Directions

Start a new Google Doc or Google Sheet. Go to the tools menu and choose “Script editor.”
Script Editor

Copy and paste the code from the above template into the script editor. Use Control A to select all and delete the default text before pasting.

Google Doc

The sample code is for creating an Add-On menu for a Google Sheets spreadsheet. If you want to create an Add-On for a Google Doc, change the 2 places in the code that says “SpreadsheetApp” to “DocumentApp.”

Add HTML

From the File menu choose “New” and create a new “Html” file.
HTML file

Name the file sidebar.
Sidebar

From the template document above, go to the sidebar html file and copy and paste the sample text.

Button

The sidebar menu has some code to create a button that runs your function from the code page. If you change the default function name from “myFunction” you will need to edit that in the sidebar menu. You can also add instructions in the sidebar html page for how to use the script.
myFunction

Save

Save the files. You will need to click on save for the code page and for the sidebar page. You will be prompted to name the script file. Whatever you name the file will be the name of your Add-On in the menu.

Run on Install

After saving the sidebar and code pages you will want to run the “onInstall” function. The dropdown menu in the toolbar allows you to choose “onInstall.”
onInstall

Click on the run icon which resembles a sideways triangle. This will add your script to the Add-On menu.

2 thoughts on “Google Apps Script: Create an Add-On

Leave a Reply

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Discount applies until you cancel!! 
Normally $12 a month, save 58%!! 

Monthly installments of only $4.99 a month.

Exclusive Teacher Tech Content! 
Exclusive Online Courses
Premium Add-ons for Google Workspace
Office Hours with Alice
Weekly Check In Support
Exclusive Webinars
And more! 

Exit this pop up by pressing escape or clicking anywhere off the pop up.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

Exit this pop up by pressing escape or clicking anywhere off the pop up.