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.Documentation Index
Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
Use this file to discover all available pages before exploring further.
Prerequisites
Install the following Python packages on your Spark cluster:Parameters
| Parameter | Tab | Description |
|---|---|---|
| API Token | Location | Smartsheet API token to authenticate the connection. |
| Smartsheet Name (Path) | Location | Path to the sheet that you would like to read from or write to. |