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

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

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.

%d