Google is committed to advancing racial equity for Black communities. See how.

Sheets manifest resource

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 manifest configuration. This is currently 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.