Create Worksheet
Create a new worksheet in a spreadsheet of your choice.
Options
Field | Definition | Type | Required |
---|---|---|---|
Use Spreadsheet ID? |
Option to specify a Google Sheets spreadsheet by ID.
If you select If you select The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL |
Dropdown | TRUE |
Spreadsheet |
List of spreadsheets in your Google Sheets account.
![]() Due to an API limitation, a maximum of 100 spreadsheets are returned in a search. To search for a specific spreadsheet, use the Enter Spreadsheet ID option. |
Dropdown | TRUE |
Spreadsheet ID | Unique identifier for your selected spreadsheet. | String | FALSE |
Input
Field | Definition | Type | Required |
---|---|---|---|
Worksheet | |||
Title | Name of the new worksheet | String | FALSE |
Row Count | Initial number of rows for the new worksheet (leaving this value at 0 will generate 1000 rows) |
Number | FALSE |
Column Count | Initial number of columns for the new worksheet (leaving this value at 0 will generate 26 columns, one for each letter of the English alphabet) |
Number | FALSE |
Output
Field | Definition | Type |
---|---|---|
Spreadsheet ID | ID of the spreadsheet in which the new worksheet was created | String |
New Worksheet ID | ID of the new worksheet | String |
New Worksheet Name | Name of the new worksheet | String |
Worksheet URL | URL of the new worksheet | String |