Creating custom menus in Google Sheets - Quick Revision & Summary

Recall & Review

beginner

What is a custom menu in Google Sheets?

A custom menu is a special menu you add to the Google Sheets toolbar. It lets you run your own scripts easily without opening the script editor.

beginner

Which Google Apps Script function is used to add a custom menu when the spreadsheet opens?

The onOpen() function runs automatically when you open the sheet. Inside it, you add your custom menu using SpreadsheetApp.getUi().createMenu().

beginner

How do you add an item to a custom menu in Google Sheets?

Use the addItem(name, functionName) method on the menu object. The name is what shows in the menu, and functionName is the script function it runs.

beginner

Why do you need to save and reload the spreadsheet after adding a custom menu script?

Because the onOpen() function runs only when the sheet opens. Reloading triggers it to add your new custom menu to the toolbar.

beginner

What is the purpose of the SpreadsheetApp.getUi() method in creating custom menus?

It gets the user interface object for the spreadsheet. This object lets you create menus, dialogs, and sidebars to interact with users.

Which function automatically runs when you open a Google Sheet to add a custom menu?

A onEdit()

B onOpen()

C addMenu()

D startMenu()

The onOpen() function runs automatically when the spreadsheet opens and is used to add custom menus.

What method do you use to create a new custom menu in Google Sheets?

A SpreadsheetApp.getUi().createMenu()

B SpreadsheetApp.createMenu()

C SpreadsheetApp.getMenu()

D SpreadsheetApp.newMenu()

You use SpreadsheetApp.getUi().createMenu() to create a new custom menu.

How do you add an item that runs a script function to your custom menu?

A addItem('Name', 'functionName')

B addMenu('Name', 'functionName')

C addFunction('Name', 'functionName')

D addScript('Name', 'functionName')

The addItem() method adds a menu item that runs the specified function.

After writing the script to add a custom menu, what must you do to see it in your Google Sheet?

A Nothing, it appears automatically

B Close the script editor only

C Run the script manually

D Reload the spreadsheet

You must reload the spreadsheet to trigger onOpen() and see the custom menu.

What does SpreadsheetApp.getUi() return?

A The script editor window

B The spreadsheet data

C The user interface object for the spreadsheet

D The spreadsheet settings

SpreadsheetApp.getUi() returns the user interface object to create menus and dialogs.

Explain how to create and add a custom menu in Google Sheets using Apps Script.

Think about what happens when the sheet opens and how you add menu items.

Why is the onOpen() function important for custom menus in Google Sheets?

Consider when your menu needs to be visible to users.