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.
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
.
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?¶
-
Login to your Smartsheet account.
-
Click on the
Account
button in the upper-right corner of the Smartsheet screen, and then clickPersonal Settings
.Figure 1: Smartsheet API Key Generation- Click the
API Access
tab.
Figure 2: Smartsheet API Key Generation - Click the
-
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.Figure 3: Smartsheet API Key Generation- Copy the
API KEY
generated.
- Copy the
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.