> ## 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.

# Smartsheet web app gem

> Use data from Smartsheet in your Spark pipeline

<Panel>
  <Info>
    Dependencies:

    * ProphecyWebAppPython 0.1.2+
  </Info>
</Panel>

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:

* [Smartsheet Python SDK](https://pypi.org/project/smartsheet-python-sdk/)
* [pandas](https://pypi.org/project/pandas/)

## 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. |