Skip to main content
Dependencies:
  • ProphecyWebAppPython 0.1.2+
Use the Smartsheet gem to read from or write to Smartsheet directly within your Spark pipeline. This gem connects to Smartsheet using the official API and lets you integrate spreadsheet-style data into your workflows. Before you start, make sure your Spark cluster has the required Python dependencies installed. Then, configure the parameters below to authenticate and specify the Smartsheet you want to access.

​
Prerequisites

Install the following Python packages on your Spark cluster:

​
Parameters

ParameterTabDescription
API TokenLocationSmartsheet API token to authenticate the connection.
Smartsheet Name (Path)LocationPath to the sheet that you would like to read from or write to.