Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

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.

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.



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.”


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

Name the file sidebar.

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


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.


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.”

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

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

© 2024 All Rights Reserved.

❤️ Become a Premium Teacher Tech Member

Regular price is $249. Save $150 and pay only $99 for the 2024/2025 school year!

Monthly installments is only $12 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.