Smartsheet is a cloud-based platform for work management and collaboration, enabling users to track projects, automate workflows, and visualise tasks in customizable sheets and dashboards. It combines spreadsheet functionality with powerful project management tools to streamline team coordination and productivity.
Connecting your application to Smartsheet enables integration for project management and collaboration features.
Authentication
Before you begin, make sure you have the following information:
Connection Name
: Choose a meaningful name for your connection. This name helps you identify the connection within your application or integration settings. It could be something descriptive like "MyAppSmartsheetIntegration"Authentication Type
:Select the type of authentication for connecting to your Smartsheet account:Auth Token
OAuth
Token Based Authentication
Log in to the Smartsheet Account.
Click on the user icon at the bottom left corner.
Select the Apps & integrations.
In Personal Settings, navigate to API Access to verify the existing token. You can also refer to Apps for managing and viewing your tokens.
In API Access choose Generate new access token .
Once the Generate New Access Token option is selected, the user will be prompted to enter a name for the access token.
Afterward, you will receive a popup displaying the access token. Copy this token and treat it with high confidentiality, as it allows access to your smartsheet account.
OAuth Based Authentication
Create a New OAuth Application: After selecting Create New App, enter the necessary details for your application:
App Name
App Description
App URL
App Contact/Support Information
App Redirect URL (for OAuth authentication)
Optionally, select the checkbox to Publish App if you want to make the app available publicly.
Retrieve Client ID and Client Secret: Once the application is created, Smartsheet will provide a Client ID and Client Secret for your OAuth application. Keep these credentials secure, as they are required to authenticate users through OAuth.
Actions
Action | Description |
| Create a new row in smartsheet |
| Gets a report from smartsheet |
| Gets a row from smartsheet |
| Gets a sheet summary in smartsheet |
| List folders in smartsheet |
| Lists public templates in smartsheet |
| List reports from smartsheet |
| Lists home contents in smartsheet |
| List users in smartsheet |
| Searches a sheet for the specified text in smartsheet |
| Update a row in a sheet in smartsheet |
Triggers
Trigger | Description |
| Triggers on a new row in smartsheet |
| Triggers on a new or updated report row in smartsheet |
| Triggers on a new or updated row in a sheet in smartsheet |