Create Worksheet

Create a new worksheet in a spreadsheet of your choice.

Options

Field Definition Type Required

Field	Definition	Type	Required
Use Spreadsheet ID?	Option to specify a Google Sheets spreadsheet by ID. If you select `No`, select a spreadsheet from the Spreadsheet dropdown and ignore the Spreadsheet ID field. If you select `Yes`, the list of spreadsheets from your account in the Spreadsheet dropdown will be depopulated; select `-- Enter Spreadsheet ID --` from the Spreadsheet dropdown and enter an ID in the Spreadsheet ID field. The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL `https://docs.google.com/spreadsheets/d/1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps/edit#gid=0`, the spreadsheet ID is `1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps`.	Dropdown	TRUE
Spreadsheet	List of spreadsheets in your Google Sheets account. CAUTION: 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.	Text	FALSE

Use Spreadsheet ID?

Option to specify a Google Sheets spreadsheet by ID.

If you select No, select a spreadsheet from the Spreadsheet dropdown and ignore the Spreadsheet ID field.

If you select Yes, the list of spreadsheets from your account in the Spreadsheet dropdown will be depopulated; select -- Enter Spreadsheet ID -- from the Spreadsheet dropdown and enter an ID in the Spreadsheet ID field.

The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL https://docs.google.com/spreadsheets/d/1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps/edit#gid=0, the spreadsheet ID is 1qpyC0XzvTcKT6EISywvqESX3A0MwQoFDE8p-Bll4hps.

Dropdown

TRUE

Spreadsheet

List of spreadsheets in your Google Sheets account.

CAUTION:

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.

Text

FALSE

Input

Field	Definition	Type	Required
Worksheet
Title	Name of the new worksheet	Text	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	Text
New Worksheet ID	ID of the new worksheet	Text
New Worksheet Name	Name of the new worksheet	Text
Worksheet URL	URL of the new worksheet	Text