Smartsheet: Get Sheet
Description
This step retrieves the data from a sheet in your Smartsheet account. You provide the sheet ID, and the step returns the sheet content including rows and columns. Use this step in workflows that read Smartsheet data for processing, pull project data for reporting, or collect input data from sheets for downstream operations.
References: https://smartsheet.redoc.ly/#operation/getSheet
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection: | ||
| 2 | Access Token | Generate the access token in your Smartsheet account. The 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 |
|---|---|---|
| Input Fields: | ||
| 1 | Smartsheet ID* | Provide the Smartsheet ID that uniquely identifies the Smartsheet Subscription. This field is mandatory. |
Output Tab:
| No. | Field Name | Description |
|---|---|---|
| Output Fields: | ||
| 1 | Field Name | On clicking in the input table, fields associated with the Column name will populate. |
| 2 | Output Field Name | Specify the Value of the respective field associated with the field name. |
| 3 | Get Fields | Click Get Fields to get all fields from the Smartsheet instance. |