Smartsheet - Download Sheet to Workflows
Overview
Allows for quick and seamless download of a Smartsheet Sheet to Workflows. Results can either be downloaded to an Excel or CSV file.
Variables
Name | Reference | Type | Required | Default | Options | Description |
---|---|---|---|---|---|---|
Access Token | SMARTSHEET_ACCESS_TOKEN | Password | ✅ | - | - | The access token for the Smartsheet API |
Sheet ID | SMARTSHEET_SHEET_ID | Alphanumeric | ✅ | - | - | The ID of the sheet to download |
Destination Folder Name | SMARTSHEET_DESTINATION_FOLDER_NAME | Alphanumeric | ➖ | - | - | The optional folder to store the downloaded file in |
Destination File Name | SMARTSHEET_DESTINATION_FILE_NAME | Alphanumeric | ✅ | - | - | The name of the downloaded file |
File Type | SMARTSHEET_FILE_TYPE | Select | ✅ | csv | CSV: csv XLSX: xlsx | The file type to download. This can be either a CSV or an Excel file |
YAML
Below is the YAML template
source:
template: Smartsheet - Download Sheet to Workflows
inputs:
SMARTSHEET_ACCESS_TOKEN:
SMARTSHEET_SHEET_ID:
SMARTSHEET_DESTINATION_FOLDER_NAME:
SMARTSHEET_DESTINATION_FILE_NAME:
SMARTSHEET_FILE_TYPE: csv
type: TEMPLATE
guardrails:
retry_count: 1
retry_wait: 0h0m0s
runtime_cutoff: 1h0m0s
exclude_exit_code_ranges:
- 200
- 201
- 202
- 203
- 204
- 205
- 206
- 220
- 249