AI-generated Key Takeaways
-
To define Sheets macros, you must use a specific configuration within a manifest, ensuring all required fields are included.
-
The top-level Sheets configuration in the manifest is exclusively used for defining Sheets macros and contains a required list of macro objects.
-
Each individual Macro object within the manifest configuration requires defining a function name and a menu name.
-
Macros can optionally have a unique default keyboard shortcut defined using the format "Ctrl+Alt+Shift+Number".
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[]
|
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
|
Ctrl+Alt+Shift+ Number
,
where Number
is a single-digit. Macros without
shortcuts can only be executed from the Tools > Macros
menu.
|
functionName
|
menuName
for
functions automatically created, but this is not a requirement. |
menuName
|
|

