Custom menus for Editor add-ons

  • Published Editor Add-ons can create custom menu items under the Extensions menu using Ui.createAddonMenu() and Menu.addItem(), typically within the add-on's onOpen(e) method.

  • While unpublished add-ons can create top-level menus, it's recommended to use Ui.createAddonMenu() for published add-ons to ensure consistent user experience.

  • Add-ons must create an initial menu before user authorization and adjust menu items dynamically based on the authorization mode (ScriptApp.AuthMode) to avoid errors.

  • The provided example demonstrates building a dynamic add-on menu that adapts to different authorization modes, using ScriptApp.AuthMode.NONE to control actions requiring authorization.

Published Editor add-ons can create custom menu items under their editor's Extensions menu. You can insert an add-on menu by using the Ui.createAddonMenu() method and add items to it using the Menu.addItem() method. Menus are usually created in the add-on's onOpen(e) method.

You can create dynamic menus that change based on user interactions or add-on state. However, add-ons must create an initial menu before the add-on is authorized by the user. Because of this, you must check the add-on's authorization mode prior to constructing menus in onOpen(e). Do not attempt to take any action that requires authorization (such as checking the script Properties) while the add-on is in ScriptApp.AuthMode.NONE. See the authorization lifecycle for more details on the authorization modes and lifecycle.

The following example shows how to build a dynamic add-on menu for different authorization modes:

function onOpen(e) {
  var menu = SpreadsheetApp.getUi().createAddonMenu(); // Or DocumentApp or SlidesApp or FormApp.
  if (e && e.authMode == ScriptApp.AuthMode.NONE) {
    // Add a normal menu item (works in all authorization modes).
    menu.addItem('Start workflow', 'startWorkflow');
  } else {
    // Add a menu item based on properties (doesn't work in AuthMode.NONE).
    var properties = PropertiesService.getDocumentProperties();
    var workflowStarted = properties.getProperty('workflowStarted');
    if (workflowStarted) {
      menu.addItem('Check workflow status', 'checkWorkflow');
    } else {
      menu.addItem('Start workflow', 'startWorkflow');
    }
    // Record analytics.
    UrlFetchApp.fetch('http://www.example.com/analytics?event=open');
  }
  menu.addToUi();
}