Smartsheet
Smartsheet is a powerful work management and collaboration tool that lets you easily track and manage your work so you and your team can be more productive than ever. Use it to collaborate with others, track progress on any project, automate processes, and better structure your work.
This connector is available in the following products and regions:
Service | Class | Regions |
---|---|---|
Logic Apps | Standard | All Logic Apps regions except the following: - Azure China regions - US Department of Defense (DoD) |
Power Automate | Standard | All Power Automate regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
Power Apps | Standard | All Power Apps regions except the following: - US Government (GCC High) - China Cloud operated by 21Vianet - US Department of Defense (DoD) |
Contact | |
---|---|
Name | Microsoft |
URL | Microsoft LogicApps Support Microsoft Power Automate Support Microsoft Power Apps Support |
Connector Metadata | |
---|---|
Publisher | Microsoft |
Website | https://www.smartsheet.com/ |
Privacy policy | https://www.smartsheet.com/legal/privacy |
To use this integration, you will need access to a Smartsheet account. To make a connection, select Sign In. You will be prompted to provide your Smartsheet account information, follow the remainder of the screens to create a connection.
You're now ready to start using this integration.
Throttling Limits
Name | Calls | Renewal Period |
---|---|---|
Frequency of trigger polls | 1 | 15 seconds |
Actions
Add a comment to a discussion |
Add a comment to an existing discussion. |
Add a discussion to a row |
Add a discussion to a specific row in a sheet. |
Add a discussion to a sheet |
Add a discussion to a sheet |
Get a discussion |
Get a specific discussion. |
Get a sheet |
Get a specific sheet. |
Get a sheet data (dynamic schema) |
Get a specific sheet data. |
Get discussions for a sheet |
Get the discussions for a specific sheet. |
Get subfolders of a folder |
Get subfolders of a specific folder. |
Get the columns of a sheet |
Get the columns of a specific sheet. |
Get the columns of a sheet (dynamic schema) |
Get the columns of a specific sheet in dynamic schema format. |
Insert row |
Insert a row into a specific sheet. |
List the sheets |
Get a list of the sheets. |
Add a comment to a discussion
Add a comment to an existing discussion.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Discussion
|
discussionId | True | string |
The discussion to add the comment to. |
Text
|
text | string |
The text of the comment. |
Returns
Response object for Creating a Comment.
Add a discussion to a row
Add a discussion to a specific row in a sheet.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet
|
sheetId | True | string |
The unique id of the sheet. |
Row Id
|
rowId | True | string |
The unique id of the row. |
Title
|
title | string |
The title for the discussion. |
|
Text
|
text | string |
The text of the comment. |
Returns
Response object for Create Discussion.
- Body
- DiscussionResponse
Add a discussion to a sheet
Add a discussion to a sheet
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
Sheet to add a discussion to |
Title
|
title | string |
The title for the discussion. |
|
Text
|
text | string |
The text of the comment. |
Returns
Response object for Create Discussion.
- Body
- DiscussionResponse
Get a discussion
Get a specific discussion.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Discussion Id
|
discussionId | True | string |
The unique id of the discussion on the specified sheet. |
Returns
Data relevant to the discussion created.
- Body
- DiscussionData
Get a sheet
Get a specific sheet.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Comma separated columns to return
|
columns | string |
The list of columns to return |
Returns
A Smartsheet sheet with rows.
- Body
- SheetWithRows
Get a sheet data (dynamic schema)
Get a specific sheet data.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Comma separated columns to return
|
columns | string |
The list of columns to return |
Returns
Get discussions for a sheet
Get the discussions for a specific sheet.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Returns
A common pattern for requesting collections from Smartsheet.
Get subfolders of a folder
Get subfolders of a specific folder.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Folder Id
|
id | True | string |
The id of the folder. |
Returns
A common pattern for requesting collections from Smartsheet.
Get the columns of a sheet
Get the columns of a specific sheet.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Returns
A common pattern for requesting collections from Smartsheet.
Get the columns of a sheet (dynamic schema)
Get the columns of a specific sheet in dynamic schema format.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Returns
Insert row
Insert a row into a specific sheet.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Row
|
row | True | dynamic |
The row to insert. |
Returns
Response to InsertRow operation.
- Body
- InsertRowResponse
List the sheets
Get a list of the sheets.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Folder Id (defaults to all)
|
optionalFolderId | string |
The unique id of the folder containing the sheets. If not specified, will default to all. |
Returns
A common pattern for requesting collections from Smartsheet.
Triggers
When a comment is added to a discussion |
Triggers when a comment is added to a specific discussion. |
When a comment is added to a sheet |
Triggers when a comment is added to a specific sheet. |
When a discussion is added to a sheet |
Triggers when a discussion is added to a sheet. |
When a new row is created |
Triggers when a new row is created in a specific sheet. |
When a new sheet is created |
Triggers when a new sheet is created. |
When a sheet is updated |
Triggers when a specific sheet is updated. |
When any sheet is updated |
Triggers when any sheet is updated. |
When a comment is added to a discussion
Triggers when a comment is added to a specific discussion.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Discussion Id
|
discussionId | True | string |
The unique id of the discussion. |
Returns
Response object for Comment.
- Body
- CommentResponse
When a comment is added to a sheet
Triggers when a comment is added to a specific sheet.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Returns
A common pattern for requesting collections from Smartsheet.
When a discussion is added to a sheet
Triggers when a discussion is added to a sheet.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Returns
A common pattern for requesting collections from Smartsheet.
When a new row is created
Triggers when a new row is created in a specific sheet.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Columns
|
columns | string |
The comma separated list of columns. |
Returns
Response object for OnRowCreated.
- Body
- RowResponse
When a new sheet is created
Triggers when a new sheet is created.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Folder Id (defaults to all)
|
optionalFolderId | string |
The unique id of the folder containing the sheets. If not specified, will default to all. |
Returns
A common pattern for requesting collections from Smartsheet.
When a sheet is updated
Triggers when a specific sheet is updated.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Sheet Id
|
sheetId | True | string |
The unique id of the sheet. |
Columns to Return
|
columns | string |
The comma separateed list of columns to return. |
Returns
A common pattern for requesting collections from Smartsheet.
When any sheet is updated
Triggers when any sheet is updated.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Folder (defaults to all)
|
optionalFolderId | string |
The unique id of the folder containing the sheets. If not specified, will default to all. |
Returns
A common pattern for requesting collections from Smartsheet.
Definitions
SmartsheetCollection[Sheet]
A common pattern for requesting collections from Smartsheet.
Name | Path | Type | Description |
---|---|---|---|
Data
|
data | array of Sheet |
Collection of Smartsheet models. |
Sheet
A Smartsheet sheet.
Name | Path | Type | Description |
---|---|---|---|
Access Level
|
accessLevel | string |
The access level of the sheet. |
Id
|
id | integer |
The unique identifier for the sheet. |
Name
|
name | string |
The name of the sheet. |
Url
|
permalink | string |
The url for the sheet. |
Created At
|
createdAt | date-time |
The datetime when the sheet was created. |
Modified At
|
modifiedAt | date-time |
The datetime the sheet was modified. |
SmartsheetCollection[DiscussionComment]
A common pattern for requesting collections from Smartsheet.
Name | Path | Type | Description |
---|---|---|---|
Data
|
data | array of DiscussionComment |
Collection of Smartsheet models. |
DiscussionComment
A comment on a discussion.
Name | Path | Type | Description |
---|---|---|---|
Comment Text
|
text | string |
The text of the comment. |
Comment Id
|
id | integer |
The id for the comment. |
createdBy
|
createdBy | DiscussionCommentUser |
The user who created the comment. |
Created At
|
createdAt | date-time |
The datetime the comment was created. |
Modified At
|
modifiedAt | date-time |
The datetime the comment was modified. |
DiscussionCommentUser
The user who created the comment.
Name | Path | Type | Description |
---|---|---|---|
Created By (Name)
|
name | string |
The name of the user who created a comment. |
Created By (Email)
|
string |
The email of the user who created a comment. |
SheetWithRows
A Smartsheet sheet with rows.
Name | Path | Type | Description |
---|---|---|---|
Sheet HTML
|
rowHTML | string |
An HTML table representation of the sheet. |
Access Level
|
accessLevel | string |
The access level of the sheet. |
Id
|
id | integer |
The unique identifier for the sheet. |
Name
|
name | string |
The name of the sheet. |
Url
|
permalink | string |
The url for the sheet. |
Created At
|
createdAt | date-time |
The datetime the sheet was created. |
Modified At
|
modifiedAt | date-time |
The datetime the sheet was modified. |
Columns
|
columns | array of Column |
Array of columns. |
Rows
|
rows | array of RowData |
Array of rows. |
SmartsheetCollection[Column]
A common pattern for requesting collections from Smartsheet.
Name | Path | Type | Description |
---|---|---|---|
Data
|
data | array of Column |
Collection of Smartsheet models |
Column
A Smartsheet column.
Name | Path | Type | Description |
---|---|---|---|
Column Id
|
id | integer |
The unique id of the column. |
Column Index
|
index | integer |
The ordinal position of the column. |
Title
|
title | string |
The title of the column. |
Data Type
|
type | string |
The data type of the column (such as text_number or datetime). |
Is Primary
|
primary | boolean |
A boolean value (true, false) determining whether or not the column is the primary column. |
Width
|
width | integer |
The width in pixels of the column, |
InsertRowResponse
Response to InsertRow operation.
Name | Path | Type | Description |
---|---|---|---|
result
|
result | InsertRowResponseResult |
InsertRowResponseResult
Name | Path | Type | Description |
---|---|---|---|
Sheet Id
|
sheetId | integer |
The Id of the sheet that was modified. |
Row Number
|
rowNumber | integer |
The row number of the newly inserted row. |
Created At
|
createdAt | date-time |
The datetime the sheet was created. |
Modified At
|
modifiedAt | date-time |
The datetime the sheet was modified. |
SmartsheetCollection[SheetWithRows]
A common pattern for requesting collections from Smartsheet.
Name | Path | Type | Description |
---|---|---|---|
Data
|
data | array of SheetWithRows |
Collection of Smartsheet models. |
SmartsheetCollection[Folder]
A common pattern for requesting collections from Smartsheet.
Name | Path | Type | Description |
---|---|---|---|
Data
|
data | array of Folder |
Collection of Smartsheet models. |
Folder
A Smartsheet folder.
Name | Path | Type | Description |
---|---|---|---|
Id
|
id | integer |
The unique id of the folder. |
Name
|
name | string |
The name of the folder. |
Url
|
permalink | string |
The url for the folder. |
DiscussionResponse
Response object for Create Discussion.
Name | Path | Type | Description |
---|---|---|---|
result
|
result | DiscussionData |
Data relevant to the discussion created. |
DiscussionData
Data relevant to the discussion created.
Name | Path | Type | Description |
---|---|---|---|
Id of Discussion
|
id | integer |
The id for the discussion. |
Discussion title
|
title | string |
The title for the discussion. |
Comments
|
comments | array of DiscussionComment |
The comments in the discussion. |
createdBy
|
createdBy | DiscussionUser |
The user who created the discussion. |
DiscussionUser
The user who created the discussion.
Name | Path | Type | Description |
---|---|---|---|
Created By (Name)
|
name | string |
The name of the user who created the discussion. |
Created By (Email)
|
string |
The email of the user who created the discussion. |
SmartsheetCollection[GetDiscussionResponse]
A common pattern for requesting collections from Smartsheet.
Name | Path | Type | Description |
---|---|---|---|
Data
|
data | array of GetDiscussionResponse |
Collection of Smartsheet models. |
GetDiscussionResponse
Response object for Get Discussions.
Name | Path | Type | Description |
---|---|---|---|
Discussion Id
|
id | integer |
The unique id of the discussion. |
Discussion Title
|
title | string |
The title for the discussion. |
createdBy
|
createdBy | DiscussionUser |
The user who created the discussion. |
Access Level
|
accessLevel | string |
The access Level for the discussion. |
Parent Type
|
parentType | string |
The parent type for the discussion. |
Is Read-Only
|
readOnly | boolean |
A boolean value (true, false) determining whether or not this discussion is read-only. |
Last Commented At
|
lastCommentedAt | date-time |
The datetime of the most recent comment |
RowResponse
Response object for OnRowCreated.
Name | Path | Type | Description |
---|---|---|---|
Rows
|
rows | array of RowData |
The content of the row that was created. |
RowData
A row
Name | Path | Type | Description |
---|---|---|---|
Row Id
|
id | integer |
The unique id for the row. |
Sheet Id
|
sheetId | integer |
The id of the sheet the row was added to. |
Url
|
permalink | string |
The url for the sheet the row was added to. |
Created At
|
createdAt | date-time |
The datetime the row was created. |
Modified At
|
modifiedAt | date-time |
The datetime the row was modified. |
Row Number
|
rowNumber | integer |
The number of the row. |
Cells
|
cells | array of RowCell |
The cell detail in the row. |
Row HTML
|
rowHTML | string |
An HTML table representation of the new row. |
RowCell
A cell in a row
Name | Path | Type | Description |
---|---|---|---|
Column Id
|
columnId | integer |
The id of column for this cell. |
Cell Value
|
value |
The value of the cell. |
|
Cell Display Value
|
displayValue | string |
The display value of the cell. |
CreateCommentResponse
Response object for Creating a Comment.
Name | Path | Type | Description |
---|---|---|---|
result
|
result | DiscussionComment |
A comment on a discussion. |
CommentResponse
Response object for Comment.
Name | Path | Type | Description |
---|---|---|---|
Comments
|
comments | array of DiscussionComment |
Comments in this discussion. |