AddSheet
Add a worksheet to an existing Google spreadsheet.
Input
| Name | Type | Description |
| SpreadsheetId | String | The ID of the spreadsheet. |
| SheetId | String | The ID of the sheet. Must be non-negative. This field cannot be changed once set. |
| Title | String | The name of the sheet. |
| Index | String | The index of the sheet within the spreadsheet. |
| SheetType | String | The type of sheet. Defaults to GRID. This field cannot be changed once set.
The allowed values are GRID, OBJECT. The default value is GRID. |
| RowCount | String | The number of rows in the grid. |
| ColumnCount | String | The number of columns in the grid. |
| HeaderNames | String | A comma-separated list of column headers to be added as the first row in the new sheet. These headers can be used later for inserting or updating data. If a column name contains special characters, enclose it in double quotes. |
| FrozenRowCount | String | The number of rows that are frozen in the grid. |
| FrozenColumnCount | String | The number of columns that are frozen in the grid. |
| HideGridlines | Boolean | True if the grid is not showing gridlines in the UI. |
| Hidden | Boolean | True if the sheet is hidden in the UI, false if it is visible. |
| RightToLeft | Boolean | True if the sheet is an RTL sheet instead of an LTR sheet. |
Result Set Columns
| Name | Type | Description |
| Success | String | This value shows whether the operation was successful or not. |