Skip to main content
Skip table of contents

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

NameReferenceTypeRequiredDefaultOptionsDescription
Access TokenSMARTSHEET_ACCESS_TOKENPassword--The access token for the Smartsheet API
Sheet IDSMARTSHEET_SHEET_IDAlphanumeric--The ID of the sheet to write to. This is only necessary if you are modifying an existing sheet
Sheet NameSMARTSHEET_SHEET_NAMEAlphanumeric--The name of the sheet to be created. Only necessary if creating a new sheet
Source Folder NameSMARTSHEET_SOURCE_FOLDER_NAMEAlphanumeric--The optional location of the file to be uploaded
Source File NameSMARTSHEET_SOURCE_FILE_NAMEAlphanumeric--The name of the file to upload
File TypeSMARTSHEET_FILE_TYPESelectcsvCSV: csv

XLSX: xlsx
The file type to upload (either XLSX or CSV)
Insert MethodSMARTSHEET_INSERT_METHODSelectreplaceAppend: 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

YAML

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

      
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.