Sheets macro manifest resource

Stay organized with collections Save and categorize content based on your preferences.

The configuration that is used to define Sheets macros. Manifests that define macros must have all the fields marked as Required.

Sheets

The top-level of the Sheets macro manifest configuration. This is only used to define Sheets macros.

JSON representation
{
  "macros": [
    {
      object (Macro)
    }
  ]
}
Fields
macros[]

object (Macro)

Required. A list of defined macros and their associated properties.

Macro

The configuration for a single macro. The definition must have all the fields marked as Required.

JSON representation
{
  "defaultShortcut": string,
  "functionName": string,
  "menuName": string
}
Fields
defaultShortcut

string

Defines the keyboard shortcut that executes the macro. This must be of the form Ctrl+Alt+Shift+Number, where Number is a single-digit. Macros without shortcuts can only be executed from the Tools > Macros menu.
functionName

string

Required. The name of the Apps Script function that executes the macro. By default this matches the menuName for functions automatically created, but this is not a requirement.
menuName

string

Required. The name of the macro as it appears in the Google Sheets UI.