Smartsheet - Upload File from Workflows to Smartsheet
Overview
Easily import data from a single CSV or Excel file into a single SmartSheet Sheet. If the the Sheet already exists, the data being uploaded will either be appended or will overwrite the existing data based on the `Insert Method`. ##### Insert Method - If `Append` or `Replace` is selected, then a `Sheet ID` is also required so the existing sheet can be modified - If `Create` is selected, then a `Sheet Name` is recommended, otherwise the newly created Sheet will be named after the file Only one file can be uploaded at a time. **Note:** This Vessel cannot be used to upload a local file from your computer. **Recommended Setup:** 1. A Vessel built with this Blueprint should typically run after a Vessel that either downloads a file to Workflows or generates a file with code.
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 write to. This is only necessary if you are modifying an existing sheet |
Sheet Name | SMARTSHEET_SHEET_NAME | Alphanumeric | ➖ | - | - | The name of the sheet to be created. Only necessary if creating a new sheet |
Source Folder Name | SMARTSHEET_SOURCE_FOLDER_NAME | Alphanumeric | ➖ | - | - | The optional location of the file to be uploaded |
Source File Name | SMARTSHEET_SOURCE_FILE_NAME | Alphanumeric | ✅ | - | - | The name of the file to upload |
File Type | SMARTSHEET_FILE_TYPE | Select | ✅ | csv | CSV: csv XLSX: xlsx | The file type to upload (either XLSX or CSV) |
Insert Method | SMARTSHEET_INSERT_METHOD | Select | ✅ | replace | Append: append Replace: replace Create: create | This determines whether the data being uploaded will append to an existing sheet, overwrite an existing sheet, or create a new one. |
YAML
Below is the YAML template
source:
template: Smartsheet - Upload File from Workflows to Smartsheet
inputs:
SMARTSHEET_ACCESS_TOKEN:
SMARTSHEET_SHEET_ID:
SMARTSHEET_SHEET_NAME:
SMARTSHEET_SOURCE_FOLDER_NAME:
SMARTSHEET_SOURCE_FILE_NAME:
SMARTSHEET_FILE_TYPE: csv
SMARTSHEET_INSERT_METHOD: replace
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