Smartsheet is a software as a service offering for collaboration and work management, developed and marketed by Smartsheet Inc. It is used to assign tasks, track project progress, manage calendars, share documents, and manage other work, using a tabular user interface.
Changelog
7 versions
v2.3.0
Latest
- Added MakeApiCall component for performing arbitrary authorized API calls to the Smartsheet API.
v2.2.0
- Added test() (Flow Test Mode) to the WatchRows trigger.
v2.1.1
- Added output examples to component schemas.
v2.1.0
- Implemented multiselect input normalization for include and skipRemap fields in CopyFolder, CopySheet, GetFolder, GetWorkspace, and MoveRows components.
v2.0.5
- Breaking change: Updated the input ports of AddRowsToSheet to fix the display of correct columns to input value in the inspector
- Breaking change: Bug fix in input fields of Copyfolder and MoveFolder
- Breaking change: Updated the input ports of UpdateRow to fix the display of correct columns to input value in the inspector
- Bug fix: Fixed the MoveRow component
v2.0.1
- BugFix: Update of path to ListHomeFolders in multiple component's inspectors.
- Breaking: Added input fields of isAdmin and licensedSheetCreator in AddUser as they are required fields from the API.
- Cleanup of descriptions of all components.
- Breaking: Updated input field of GetFolders to have multiselect instead of single select.
- BugFix: Fixed GetSheet.
v1.0.1
- Smartsheet
Authentication
| Type | Details |
|---|---|
| OAuth 2 |
Authentication Hub
Verified
This connector is globally authenticated and verified by Appmixer and is ready to use without registering your own OAuth application with the provider. Appmixer's Authentication Hub acts as an authentication proxy, so all OAuth-based connectors work out of the box. You can still use your own OAuth credentials (clientId and clientSecret) for enhanced customization or compliance — see the Connector Configuration section of the documentation. The Authentication Hub is enabled for all hosted Appmixer tenants; on self-managed installations it has to be explicitly set.
Auth URL:
https://app.smartsheet.com/b/authorize
Scopes:
ADMIN_SHEETS
ADMIN_SIGHTS
ADMIN_USERS
ADMIN_WEBHOOKS
ADMIN_WORKSPACES
CREATE_SHEETS
CREATE_SIGHTS
DELETE_SHEETS
DELETE_SIGHTS
READ_CONTACTS
READ_EVENTS
READ_SHEETS
READ_SIGHTS
READ_USERS
SHARE_SHEETS
SHARE_SIGHTS
WRITE_SHEETS
|
Triggers
1Actions
31
Add User
Adds a user to the organization account. This action is available only to system administrators. If User Auto Provisioning (UAP) is enabled and the user matches UAP rules, they are automatically added to the organization. Otherwise, the user receives an invitation and must accept to join. Note that in some cases, attributes like firstName and lastName may be ignored, particularly if inviting an existing Smartsheet user who has not yet accepted a previous invitation.
Get Current User
Retrieves details of the current user. For system administrators, the response includes additional attributes like customWelcomeScreenViewed (only if an Enterprise user has viewed the Custom Welcome Screen), lastLogin (if the user has logged in), and sheetCount (if the user’s status is ACTIVE).
Get User
Retrieves details of the specified user. For system administrators, additional UserProfile attributes in the response include admin, customWelcomeScreenViewed (only if an Enterprise user has viewed the Custom Welcome Screen), groupAdmin, lastLogin (if the user has logged in), licensedSheetCreator, resourceViewer, sheetCount (if the user’s status is ACTIVE), and status.
List Folders
Gets a list of folders in a given folder. The list contains an abbreviated Folder object for each folder.
List Home Contents
Gets a nested list of all Home objects, including dashboards, folders, reports, sheets, templates, and workspaces, as shown on the "Home" tab.
List Search
Searches all sheets that the user can access, for the specified text. If you have not used the public API in a while, we will need to provision your data. This could take up to 24 hours so please check back later!
List Search Sheet
Gets a list of the user's search results in a sheet based on query. The list contains an abbreviated row object for each search result in a sheet. If you have not used the public API in a while, we will need to provision your data. This could take up to 24 hours so please check back later! Newly created or recently updated data may not be immediately discoverable via search.
List Sheets
Gets a list of all sheets that the user has access to. The list contains an abbreviated Sheet object for each sheet.
List Webhooks
Gets the list of all webhooks that the user owns (if a user-generated token was used to make the request) or the list of all webhooks associated with the third-party app (if a third-party app made the request). Items in the response are ordered by API cient name > webhook name > creation date.
List Workspaces
Gets a list of workspaces that the user has access to. The list contains an abbreviated Workspace object for each workspace.
Move Sheet
Moves the specified sheet to a new location.
When a sheet that is shared to one or more users and/or groups is moved into or out of a workspace, those sheet-level shares are preserved.
Update Column
Modifies column properties, moves, or renames it. Note: You cannot change the type of a Primary column. With dependencies enabled, special calendar/Gantt columns cannot have their type changed. Changing the column type converts all cells and clears validation. Type is optional for moving or renaming but required when changing type or dropdown values.
Update Rows
Updates cell values, expands or collapses rows, or modifies the position of specified rows (including indenting/outdenting). For details on changing row positions, see location-specifier attributes.