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.
Specify the Sheet ID: Enter the target Smartsheet ID in the "Sheet" field.
To find the Target Smartsheet ID in Smartsheet, you can:
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.
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.
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.
Configure Credentials:
Via Knime "Credentials Configuration" node:
In the "Credentials Configuration" node:
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:
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.
The Smartsheet sheet to be written
The name of the column to be used as reference
Remove all rows before writing
Add new (no match with output) references
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.
To use this node in KNIME, install the extension Smartsheet extension for KNIME from the below update site following our NodePit Product and Node Installation Guide:
A zipped version of the software site can be downloaded here.
Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.