Table of Contents

Smartsheet
- Connect Smartsheet to Boost.space Integrator
- Build Smartsheet Scenarios
  - Mapping Cells From the Get a Row Module

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…). More only by using your login credentials or by following the instructions below .

Smartsheet

	Important
Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice. Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

Important

Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.

Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

With Smartsheet modulesThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More in Boost.spaceCentralization and synchronization platform, where you can organize and manage your data. More IntegratorPart of the Boost.space system, where you can create your connections and automate your processes. More, you can watch, create, update, list, and/or delete folders, sheets, rows, and workspaces in your Smartsheet account.

To get started with Smartsheet, create an account at smartsheet.com.

Refer to the Smartsheet API documentation for a list of available endpoints.

	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.

Connect Smartsheet to Boost.space Integrator

To establish a connection to a Smartsheet account with a default/global region domain (excluding the EU region):

Log in to your Boost.space Integrator account, add a Smartsheet moduleThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More to your scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive. More, 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 and use the following information:

Redirect URI

https://integrator.boost.space/oauth/cb/smartsheet
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. More

After connecting the app, you can perform the following actions:

TriggersEvery scenario has a trigger, an event that starts your scenario. A scenario must have a trigger. There can only be one trigger for each scenario. When you create a new scenario, the first module you choose is your trigger for that scenario. Create a trigger by clicking on the empty module of a newly created scenario or moving the...

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 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 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
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 My Info

Required Permissions: READ_USERS
Get a Workspace

Required Permissions: READ_SHEETS
Move a Folder

Required Permissions:ADMIN_WORKSPACES
Move a Sheet

Required Permissions: CREATE_SHEETS
Update a Folder

Required Permissions: ADMIN_WORKSPACES
Update a Row

Required Permissions: WRITE_SHEETS
Update a Workspace

Required Permissions: ADMIN_WORKSPACES
Move Rows to Another Sheet

Required Permissions:WRITE_SHEETS
Update a Row (mappable)

Required Permissions: WRITE_SHEETS
Update Cells

Required Permissions: WRITE_SHEETS
Update a Webook StatusCreate statuses for each module separately to create an ideal environment for efficient and consistent work. More (internal)
Make an API Call
Create a Comment

Required Permissions: WRITE_SHEETS
Upload an Attachment

Required Permissions: WRITE_SHEETS
Download a Sheet

Required Permissions: READ_SHEETS
Create a UserCan use the system on a limited basis based on the rights assigned by the admin. More

Required Permissions: ADMIN_USERS
Update a Summary Field

Required Permissions: ADMIN_SHEETS

Searches

Search Everything

Required Permissions: READ_SHEETS
Search Sheets

Required Permissions: READ_SHEETS

Mapping Cells From the Get a Row Module

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.