| Active |
|---|
| This application does not need additional settings. So you can make connectionUnique, active service acces point to a network. There are different types of connections (API key, Oauth…). only by using your login credentials or by following the instructions below . |
With Smartsheet modulesa module is an application or tool designed to handle specific business functions, such as CRM, project management, or inventory. The system's modular architecture allows you to activate only the modules you need, enabling customization and scalability as your business requirements evolve. in Boost.spaceA platform that centralizes and synchronizes company data from internal and external sources, offering a suite of modules and addons for project management, CRM, data visualization, and more. Has many features to optimize your workflow! IntegratorPart of the Boost.space system, where you can create your connections and automate your processes., you can manage the folders, sheets, rows, and workspaces in your Smartsheet account.
To use the Smartsheet modules, you must have a Smartsheet account. You can create an account at smartsheet.com.
Refer to the Smartsheet API documentation for a list of available endpoints.
![[Note]](https://docs.boost.space/wp-content/themes/bsdocs/docs-parser/HTML/css/image/note.png) |
Note |
|---|---|
|
Smartsheet connections are limited to Smartsheet’s default/global regions, which does not encompass the EU. It is not possible to connect to a Smartsheet account with an EU domain at this time. |
To establish the connection in Boost.space Integrator:
https://integrator.boost.space/oauth/cb/smartsheet
https://auth.redirect.celonis.cloud/oauth/cb/smartsheet
-
Log in to your Boost.space Integrator account, add a Smartsheet modulea module is an application or tool designed to handle specific business functions, such as CRM, project management, or inventory. The system's modular architecture allows you to activate only the modules you need, enabling customization and scalability as your business requirements evolve. to your scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive., and click Create a connection.
-
Optional: In the Connection name field, enter a name for the connection.
-
Optional: Click Show advanced settings and manually add scopes and/or enter your custom appCreate your own custom apps to be used in the integrator engine and share them with users in your organization. client credentials. For more information, refer to the Smartsheet OAuth Walkthrough documentation.
If requested, use the following Redirect URI when creating your custom app:
-
Click Save.
-
If prompted, authenticate your account and confirm access.
You have successfully established the connection. You can now edit your scenario and add more Smartsheet modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.
Build Smartsheet ScenariosA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive.
After connecting the app, you can perform the following actions:
TriggersThe initial event that starts a scenario. It can be an action, a scheduled time, or a custom event, and is essential to define at the beginning of each scenario.
-
New Event
Required Permissions: ADMIN_WEBHOOKS
-
Watch Rows
Required Permissions: READ_SHEETS
Actions
-
Copy a Folder
Required Permissions: ADMIN_WORKSPACES
-
Copy a Sheet
Required Permissions: CREATE_SHEETS
-
Copy a Workspace
Required Permissions: ADMIN_WORKSPACES
-
Create a Comment
Required Permissions: WRITE_SHEETS
-
Create a Folder
Required Permissions: ADMIN_WORKSPACES
-
Create a Row
Required Permissions: WRITE_SHEETS
-
Create a Row (mappable)
Required Permissions: WRITE_SHEETS
-
Create a Sheet
Required Permissions:CREATE_SHEETS
-
Create a UserCan use the system on a limited basis based on the rights assigned by the admin.
Required Permissions: ADMIN_USERS
-
Create a Workspace
Required Permissions: ADMIN_WORKSPACES
-
Delete a Folder
Required Permissions: ADMIN_WORKSPACES
-
Delete a Row
Required Permissions: WRITE_SHEETS
-
Delete a Sheet
Required Permissions: DELETE_SHEETS
-
Delete a Workspace
Required Permissions: ADMIN_WORKSPACES
-
Download a Sheet
Required Permissions: READ_SHEETS
-
Get a Folder
Required Permissions: READ_SHEETS
-
Get a Row
Note: For information regarding mappingMapping links the modules in your scenario. When you map an item, you connected the data retrieved by one module to another module to perform the desired action. For example, you can map the email address and subject lines from the Email > Watch emails module to Google Sheets > Add a row and create a spreadsheet of email addresses... cells from this module, see the Mapping Cells From the Get a Row Module section.
Required Permissions: READ_SHEETS
-
Get a Sheet
Required Permissions: READ_SHEETS
-
Get a Workspace
Required Permissions: READ_SHEETS
-
Get My Info
Required Permissions: READ_USERS
-
Make an API Call
-
Move a Folder
Required Permissions:ADMIN_WORKSPACES
-
Move a Sheet
Required Permissions: CREATE_SHEETS
-
More Rows to Another Sheet
Required Permissions:WRITE_SHEETS
-
Update a Folder
Required Permissions: ADMIN_WORKSPACES
-
Update a Row
Required Permissions: WRITE_SHEETS
-
Update a Row (mappable)
Required Permissions: WRITE_SHEETS
-
Update a Summary Field
Required Permissions: ADMIN_SHEETS
-
Update a Workspace
Required Permissions: ADMIN_WORKSPACES
-
Update Cells
Required Permissions: WRITE_SHEETS
-
Upload an Attachment
Required Permissions: WRITE_SHEETS
Searches
-
Search Everything
Required Permissions: READ_SHEETS
-
Search Rows
Required Permissions: READ_SHEETS
-
Search Sheets
Required Permissions: READ_SHEETS
When the Sheet field has been mapped, then Cells (array) must be used for mapping the cells from the Get a Row module. Do not use Cells (collection)!
This is due to the Sheetfield being dynamic, without a static value. This means it is not possible to load values during scenario creation. Cells (collection) will be different for every Sheet ID, therefore it cannot be used for mapping.