Smartsheet Reader

This node downloads data from Smartsheet for further processing and analysis within KNIME. It allows you to integrate Smartsheet data with other data sources, calculate KPIs, and visualize results in various ways, including writing data back to Smartsheet using the Smartsheet Writer node.

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

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

   To find the ID in Smartsheet:

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

2. Indicate Report (Optional): Check the "Report" checkbox if you are reading data from a Smartsheet report.

3. 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)