Smartsheet Writer

This node writes the input data into a Smartsheet grid which can then be used by other Smartsheet applications, dashboards and potentially access all other features in Smartsheet. Data can be appended to a blank sheet or synchronized with a populated sheet. Synchronization is based on the Reference (Index) column in the Writer node.

It allows you to connect any external data source to Smartsheet, calculate complex KPIs within KNIME and much more. It also allows you to read from Smartsheet using the Smartsheet Reader node, process data and prepare KPIs and dashboards.

The node can upload a new dataset on an empty Smartsheet grid. To do so, check the "Clear sheet first" option.

To set up the Smartsheet Writer Node, follow these steps:

1. Specify the Sheet ID: Enter the target Smartsheet ID in the "Sheet" field.

   To find the Target Smartsheet ID in Smartsheet, you can:

   • Right-click on the sheet name and select "Properties."
   • Alternatively, go to "File" -> "Properties" within the sheet.
   • Copy the Sheet ID.

2. Define the Reference Column: Enter the column name that contains the unique key for synchronization in the "Ref column" field. Note that this column is case-sensitive.

3. Optional: Clear Existing Data: Check "Clear sheet first" if you want to empty the Smartsheet completely before uploading the new dataset. Caution: This will permanently delete the original data in the Smartsheet.

4. Optional: Append New Rows: Check "Add new" (append) if you wish to add new rows in case their "Ref Column" content does not exist in the target Smartsheet.

5. Configure Credentials:

   • Via Knime "Credentials Configuration" node:

     • Add the "Credentials Configuration" node to your workflow.
     • Connect the variable port of the "Credentials Configuration" node to the upper left variable port of the Smartsheet Writer node.

     • In the "Credentials Configuration" node:

       1. Enter "SMARTSHEET_ACCESS_TOKEN" in the "Parameter/Variable Name" field.
       2. Enter your Smartsheet access token in the "Password" field.

       Note: If your Smartsheet token is for European or Government Smartsheet server, you need to prefix your Smartsheet token with the region (eu, gov). (eg: "eu:<SMARTSHEET_ACCESS_TOKEN>")

   • Alternatively, using environment variables:

     • Set your Smartsheet access token in "SMARTSHEET_ACCESS_TOKEN" env variable.
     • Optional: Set your Smartsheet region (eu, gov) in "SMARTSHEET_REGION" env variable.

   Note: If the region is unspecified, it will use by default US Smartsheet services (smartsheet.com)

Important Note: Synchronization requires unique values in the "Ref Column" of both the dataset to be imported and the target Smartsheet. Presence of duplicate values in either will result in an error.