Smartsheet: Create Sheet In Folder

Description

This step creates a new sheet in your Smartsheet account. You provide the sheet name and column definitions. The step returns the sheet ID. Use this step in workflows that set up new project sheets, create data collection sheets for teams, or provision output destinations for processed data.

Reference:

API Documentation: https://smartsheet.redoc.ly/tag/sheets/#operation/create-sheet-in-folder

Configurations

No.	Field Name	Description
1	Step Name	Name of the step. This name has to be unique in a single workflow.
	Connection:
1	Accept value as variable/static	Leave checkbox unchecked to accept Access Token value from a field in the previous steps of the stream using a drop-down list. Else, enable the checkbox for the Access Token field to appear as a text box.
2	Access Token	Retrieve access token from OAuth token API call. This field is mandatory.
3	Test Connection	Click to verify whether the connection is established or not. Note: Test Connection will only work with static (hardcoded) values and environment variables. It will not work for the previous step fields.

Input Tab

No.	Field Name	Description
1	Folder ID	Specify the ID of the folder in which you want to create the sheet. This field is mandatory. Note: To get the folder ID: Access your Smartsheet account and select the folder in which you want to create the sheet. Right-click on the selected folder, and click Properties. In the properties dialog, copy the ID from the Folder ID field.
2	Include	Specify the additional parameters to create a sheet from a template. The parameters are specified as a comma-separated list of elements that you can copy from the template. This field is optional. Allowed values: Attachments cellLinks data discussions filters forms ruleRecipients rule OR All Note: If you specify All, then you cannot specify any other parameter. Therefore, specify appropriate parameter(s), as required.
3	Template Type	Specify or select the template type. This field is mandatory.
4	Get	Click to fetch and populate the list of available template types.
5	Sheet Name	Specify the name of the sheet to be created in Smartsheet. This field is mandatory.

Output Tab:

No.	Field Name	Description
	Output Fields:
1	Smartsheet ID	Output field to hold the result of the successful plugin execution. Default value: Smrtsheet ID