The integration is designed to synchronize data between OnePlan and Smartsheet. Transforming Sheets in Smartsheet into Plans in OnePlan. Each row within Smartsheet will seamlessly translate into Schedule items within the OnePlan Work Plan. Conversely, the reverse process is also facilitated, allowing Plans within OnePlan to convert into sheets in Smartsheet, with any Scheduled items in the OnePlan Work Plan seamlessly becoming row items in Smartsheet.
To complete the OnePlan setup, you need to be an admin (user with Owner permissions) in OnePlan.
Required Authentication Key Permissions: Smartsheet Integration
Create an authentication key for this integration in OnePlan. For the steps to create a key, see How to Create and Rotate Authentication Keys in OnePlan. When you create the key, select the following settings.
Global Scopes — None required. Leave OData and Backup cleared.
| Data Type | Permissions |
|---|---|
| Configuration | Read |
| Plans | Read, Create, Update |
| Workplan | All (Read, Create, Update, Delete) |
| Resources | Read, Create |
| Integrations | Read, Create, Delete |
Note: Selecting Update or Delete also selects Read. The Integrations permissions allow OneConnect to add and remove the integration in OnePlan when it is installed or uninstalled. Grant only the permissions listed so the key has the minimum access the integration needs.
After you create the key, save the OnePlan group name and the authentication key in a secure location. You enter both in OneConnect during setup. The key cannot be viewed again after you leave the page.
Note: It is recommended to generate a new authentication key for every integration and to give each key a descriptive name that identifies its integration. This practice enhances security, simplifies management, and makes tracking and troubleshooting easier.
Note
To generate an API Access Token account must have either Pro, Business, or Enterprise Plans.
- Log into Smartsheet.
- Go to Account > Apps & Integrations.
- Click on API Access.
- Click Generate new access token. A window will appear.
- Enter an API Access Token Name. Click Ok.
- The API Access Token will be generated on the next page.
Note
To find the Template ID, a Template must be made in Smartsheet.
- Click on the Browse (folder) Icon.
- Locate the Template that will be used, right click on the template name to expand options.
- Click on Properties... The Template ID will be in the last field at the bottom of the window.
OneConnect Setup Process
To complete the OneConnect setup, you need have Administrator or Editor privileges in the OneConnect group you wish to set the integration up in.
- Go to https://my.oneconnect.ai (or https://eu.oneconnect.ai for European customers utilizing eu.oneplan.ai)
- Click on the Add Integration button.
- Locate the OnePlan to Smartsheet integration.
- Click on the tile.
OnePlan Connector
-
Group Name
- Input the name of the OnePlan Group name you intend to integrate with.
-
Authentication Key
- Paste the generated OnePlan Authentication Key obtained from OnePlan.
- Paste the generated OnePlan Authentication Key obtained from OnePlan.
-
Additional Options
- Expand the section for additional configuration options.
-
(Optional) Alternate OnePlan Environment URL
- If using an environment other than the default (https://my.oneplan.ai), select the appropriate URL from the available options:
-
Test Connection
- Click Test to verify the correctness of the connection settings to OnePlan.
- A notification indicating Connected Successfully should appear in the top-right corner of the browser upon successful testing.
-
Save Changes
- After verifying the connection, click Save to retain the configured settings.
Smartsheet Connector
-
Username
- Enter the designated email used for accessing the Smartsheet environment.
- Note: It's recommended to use a service account for Smartsheet access.
-
API Token
- Input the API Token associated with the Smartsheet environment intended for integration with OnePlan. See Generate a Smartsheet API Access Token for instructions.
-
Additional Options
- Expand the section for additional configuration options.
-
(Optional) Template ID
- Specify the Template ID to be utilized during the import and export of Sheets. See Locate a Smartsheet Template Id for instructions
-
(Optional - Checkbox) Use Template
- If checked, a valid Template ID must be entered.
-
Test Connection
- Click Test to verify the correctness of the connection settings to Smartsheet.
- A notification indicating Connected Successfully should appear in the top-right corner of the browser upon successful testing.
-
Save Changes
- After verifying the connection, click Save to retain the configured settings.
Comments
0 comments
Article is closed for comments.