Delen via


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.

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.

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.

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.

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

The outputs of this operation are dynamic.

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.

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.

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.

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)
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)
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.