Smartsheet - Get sheets

Use the Smartsheet - Get sheets action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to retrieve sheets from the Smartsheet account configured in the connection.

For more information about Smartsheet, go to Smartsheet.

Configure the Smartsheet - Get sheets action

1. Add the action to the workflow and open the action configuration panel. For more information, see Add an action to the workflow.

2. Select a Connection. If you do not have a connection, see Add a connection.

3. Enter paging options if needed.

4. Create or select a variable for the output.

Smartsheet - Get sheets action fields and settings

Section	Field	Description	Variable types
(Unlabeled)	Connection Credentials and other settings that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.	The Smartsheet connection to use to retrieve the list of sheets. To refresh the available connections, click .	(n/a)
	Include all results	Enable or disable paging options.	Boolean
	Page	The page number to retrieve, if Include all results is false. 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.	Decimal, Integer
	Items per page	The number of sheets per page, if Include all results is false.	Decimal, Integer
	Modified since	Retrieves only those sheets that have been modified since the date selected.	Text, Integer, DateTime
Output	Row	Stores the result of the action as an object. The following values are returned: Page number: (Integer) The current page in the full result set that the data array represents. When a page number greater than Total Pages is requested, the last page is instead returned. Total pages: (Integer) The total number of pages in the full result set. Sheets: (Collection) ID: (Integer) The unique identity number for the Smartsheet. Name: (Text) The name of the Smartsheet. Version: (Text) A number that is incremented every time a sheet is modified. Created date: (DateTime) The time that the sheet was created. Modified date: (DateTime) The last time that the sheet was modified. Permalink: (Text) URL that represents a direct link to the sheet in Smartsheet. Access level: (Text) User's permissions on the sheet. Source: (Text) A source object indicating the dashboard, report, sheet, or template from which this sheet was created, if any.	Object