Skip to content

Smartsheet Connection

Smartsheet application on Connect iPaaS uses OAuth authorization and API Key authorization. By linking your Smartsheet account with Connect iPaaS using OAuth, you can authorize RoboMQ to have a delegated access on your behalf. RoboMQ needs the following permissions on your account to provide a seamless integration experience:

Object Permission
Sheet Row Object Read and Write Permission on sheets (READ_SHEETS, WRITE_SHEETS)
Sheet Object Permission to create sheet (CREATE_SHEETS)
Webhooks Admin Permission on managing Webhooks (ADMIN_WEBHOOKS)
Users Permission to read users (READ_USERS)

Please refer here to learn more about Smartsheet OAuth permissions used by Connect iPaaS.

Using the API Key connection mechanism, you can authorize Connect iPaaS to have the same level of access as the user principal of the account that generated the API key. These permissions may be more permissive than what could be achieved by using OAuth. For security considerations, we recommend using OAuth wherever available.

We at RoboMQ pay utmost attention to keep your account secure. See our Security and Privacy Policies to learn more about how RoboMQ handles your account access.

Create an OAuth 2.0 Connection

To link your Smartsheet account using OAuth, you just have to click on the link account button.

Create a Smartsheet Connection

Figure 1: Create Smartsheet Connection

When you click on the Link Account button, you will be redirected to the Smartsheet Authentication screen and then to the application page where you can check permissions and allow RoboMQ to access your account.

Smartsheet account authorization screen

Figure 2: Smartsheet Account Authorization

Smartsheet account authorization screen

Figure 3: Connect iPaaS Smartsheet Application

By allowing access, you are authorizing RoboMQ to access your Smartsheet account.

Create an API Key Connection

You need to generate API Key to authenticate your Smartsheet account on Connect iPaaS.

How to get API Key in Smartsheet?

  1. Login to your Smartsheet account.

  2. Click on the Account button in the upper-right corner of the Smartsheet screen, and then click Personal Settings. Smartsheet's Setup Button

    Figure 1: Smartsheet API Key Generation

  3. Click the API Access tab.

    Smartsheet's API Access Window

    Figure 2: Smartsheet API Key Generation

  4. Click the Generate new access token button to obtain an access token. And then choose API Access Token Name on the create an API key screen.

    Smartsheet's API Generation Window

    Figure 3: Smartsheet API Key Generation

  5. Copy the API KEY generated.

How to create a Smartsheet connection on Connect iPaaS using API Key?

Now you have your API key, you can now use your account in Connect iPaaS. Choose the connection type APIKey and paste the API Key value you saved earlier.

Connection screen for API Key

Figure 4: Smartsheet API Key Authnetication