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

YAML


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