Smartsheet

Smartsheet integration (Productivity). Imported from open-connector.

API key5 toolshttps://api.smartsheet.com/2.0

GET

smartsheet_list_sheets

List sheets available to the authenticated Smartsheet access token.

/sheets

4 parameters

Param	Type	Required	Description
includeAll	boolean	optional	Whether Smartsheet should include all matching sheets.
modifiedSince	string	optional	Only return sheets modified on or after this timestamp.
page	integer	optional	The page number to return.
pageSize	integer	optional	The maximum number of items to return per page.

GET

smartsheet_get_sheet

Get a Smartsheet sheet with columns and rows.

/sheets/{sheetId}

12 parameters

Param	Type	Required	Description
sheetId	integer	required	The ID of the sheet to retrieve.
include	string	optional	Comma-separated Smartsheet include flags.
exclude	string	optional	Comma-separated Smartsheet exclude flags.
columnIds	string	optional	Comma-separated column IDs to include.
rowIds	string	optional	Comma-separated row IDs to include.
rowNumbers	string	optional	Comma-separated row numbers to include.
filterId	string	optional	The Smartsheet filter ID to apply.
ifVersionAfter	integer	optional	Only return the full sheet if it changed after this version.
level	integer	optional	The Smartsheet object-value compatibility level.
rowsModifiedSince	string	optional	Only return rows modified on or after this timestamp.
page	integer	optional	The page number to return.
pageSize	integer	optional	The maximum number of items to return per page.

POST

smartsheet_add_rows

Add one or more rows to a Smartsheet sheet.

/sheets/{sheetId}/rows

4 parameters

Param	Type	Required	Description
sheetId	integer	required	The ID of the sheet that receives the rows.
rows	array	required	The rows to add.
allowPartialSuccess	boolean	optional	Whether Smartsheet should allow partial success.
overrideValidation	boolean	optional	Whether Smartsheet should bypass cell validation limits.

PUT

smartsheet_update_rows

Update one or more rows in a Smartsheet sheet.

/sheets/{sheetId}/rows

4 parameters

Param	Type	Required	Description
sheetId	integer	required	The ID of the sheet containing the rows.
rows	array	required	The rows to update. Each row must include an id.
allowPartialSuccess	boolean	optional	Whether Smartsheet should allow partial success.
overrideValidation	boolean	optional	Whether Smartsheet should bypass cell validation limits.

DELETE

smartsheet_delete_rows

Delete one or more rows from a Smartsheet sheet.

/sheets/{sheetId}/rows

3 parameters

Param	Type	Required	Description
sheetId	integer	required	The ID of the sheet containing the rows.
rowIds	array	required	The row IDs to delete.
ignoreRowsNotFound	boolean	optional	Whether Smartsheet should ignore missing row IDs.