​
List Sheets

Gets a list of all sheets that the user has access to. The list contains an abbreviated Sheet object for each sheet.

External Documentation

To learn more, visit the Smartsheet documentation.

​
Parameters

ParameterDescription
IncludeA comma-separated list of optional elements to include in the response:* sheetVersion - current version number of each sheet, should not be combined with pagination.* source - the Source object for any sheet that was created from another sheet, if any.
Include AllCheck to include all results.
Modified SinceWhen specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. If you need to keep track of frequent changes, it may be more useful to use Get Sheet Version.
PageWhich page to return. Defaults to 1 if not specified. If you specify a value greater than the total number of pages, the last page of results is returned.
Page SizeThe maximum number of items to return per page. Unless otherwise stated for a specific endpoint, defaults to 100. If neither pageSize nor page is specified, returns all rows in the sheet. If only page is specified, defaults to a page size of 100.

​
Example Output

{
	"data": [
		{
			"accessLevel": "string",
			"createdAt": "date-time",
			"id": 0,
			"modifiedAt": "date-time",
			"name": "Sheet name.",
			"permalink": "URL that represents a direct link to the sheet in Smartsheet.",
			"source": {
				"id": 0,
				"type": "**report**, **sheet**, **sight** (aka dashboard), or **template**.\n"
			},
			"version": 0
		}
	],
	"pageNumber": 1,
	"pageSize": 50,
	"totalCount": 136,
	"totalPages": 25
}

​
Workflow Library Example

List Sheets with Smartsheet and Send Results Via Email

Preview this Workflow on desktop

Was this page helpful?

List Search SheetSearch Sheets