Skip to main content

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 manages tasks, projects, and workflows using a spreadsheet-like interface that can contain rows, columns, and cell data. Prophecy uses the Smartsheet API to establish the connection.

​
Prerequisites

Prophecy connects to Smartsheet using an API access token associated with your Smartsheet account. All operations—such as reading from or writing to sheets—are performed using the permissions granted to your user. To use a Smartsheet connection effectively, you must have the appropriate sharing permissions on the sheets you want to access. For example:
  • Viewer permission allows you to read sheet data but not modify it.
  • Editor permission is required to update or write data using a Target gem.
Before setting up the connection, ensure your account has the necessary access to all relevant sheets. For more details, visit Sharing permission levels.

​
Feature support

The table below outlines whether the connection supports certain Prophecy features.
FeatureSupported
Read data with a Source gemYes
Write data with a Target gemYes
Browse data in the Environment browserYes
Index files in the Knowledge GraphNo

​
Limitations

Keep in mind the following limitations when using the Smartsheet connection.
  • Smartsheet defines capacity limits in the Limitations documentation.
  • Smartsheet allows users to create sheets with the same name in the same file location. Prophecy handles this situation in the following ways:
    • Writing to Smartsheet when there are duplicate files. In this case, the pipeline run will fail in Prophecy. Prophecy will not choose which file to overwrite with the Target gem.
    • Reading from Smartsheet when there are duplicate files. In this case, Prophecy appends a (n) to the duplicate files for differentiation in Prophecy.
    Duplicate Smartsheet file in Prophecy file browser

​
Connection parameters

To create a connection with Smartsheet, enter the following parameters:
ParameterDescription
Connection NameUnique name for the connection
Access Token (Secret required)Your Smartsheet API access token

​
Sharing connections within teams

Connections in Prophecy are stored within fabrics, which are assigned to specific teams. Once a Smartsheet connection is added to a fabric, all team members who have access to the fabric can use the connection in their projects. No additional authentication is required—team members automatically inherit the access and permissions of the stored connection credentials.
Be mindful of the access level granted by the stored credentials. Anyone on the team will have the same permissions—including access to sensitive data if allowed.To manage this securely, consider creating a dedicated fabric and team for high-sensitivity connections. This way, only approved users have access to those credentials.