manageSheets
Add, remove, rename, or change visibility of sheets. Operations are executed in order: add → rename → setVisibility → remove.
| Parameter | Type | Description | |
|---|---|---|---|
add | object | optional | Add a new sheet |
add.name | string | required | Name for the new sheet |
remove | object | optional | Remove a sheet |
remove.sheet | string | required | Name of the sheet to remove |
rename | object | optional | Rename a sheet |
rename.sheet | string | required | Current name of the sheet |
rename.name | string | required | New name for the sheet |
setVisibility | object | optional | Set sheet visibility |
setVisibility.sheet | string | required | Name of the sheet |
setVisibility.hidden | "visible" | "hidden" | "veryHidden" | required | visible = normal, hidden = hidden tab, veryHidden = cannot be unhidden from UI |
note | string | required | Description of this operation for version history |