Skip to main content

Smartsheet gem

Use a Source and Target gem to read from or write to Smartsheet locations in Prophecy pipelines. This page covers supported file formats, how to create the gem, and how to configure connection details and paths for both Source and Target gems.

Supported file formats​

FormatReadWrite
XLSXYesYes

Create a Smartsheet gem​

To create a Smartsheet Source or Target gem in your pipeline:

  1. Set up your Smartsheet connection.

  2. Add a new Source or Target gem to your pipeline canvas and open the configuration.

  3. In the Type tab, select Smartsheet.

  4. In the Location tab, choose your file format and location.

    info

    For more information on how to configure this screen, jump to Location.

  5. In the Properties tab, set the file properties. These vary based on the file type that you are working with.

    info

    See the list of properties per file type.

  6. (Source only) In the Preview tab, load a sample of the data and verify that it looks correct.

Location​

ParameterDescription
Format typeType of file to read or write, such as csv or json.
Select or create connectionSelect an existing Smartsheet connection or create a new one.
FilepathPath to the file in Smartsheet.
Example: /Projects/ProjectName/file.csv