Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Manage Folder → Get Sheets List
AI-generatedOverview
This node operation retrieves a list of sheets under a specified folder in Smartsheet. It is useful for scenarios where users need to manage or view all sheets contained within a particular folder, such as organizing project sheets or reporting structures. For example, a user can list all sheets in a project folder to display or process them further in an automation workflow.
Use Case Examples
- List all sheets in a folder to generate a summary report.
- Retrieve sheets under a folder to automate backup or synchronization tasks.
Properties
| Name | Meaning |
|---|---|
| Folder ID | The ID of the folder from which to list all sheets. This is a required field to specify the target folder. |
| Return All | Boolean flag to determine whether to return all sheets or limit the number of results. |
| Limit | Maximum number of sheets to return when 'Return All' is false. Must be at least 1. |
| Children Resource Types | Comma-separated list of child resource types to include in the response, such as sheets, reports, sights, or folders. |
| Include | Comma-separated list of optional elements to include in the response, such as source or owner information. |
Output
JSON
folder- The folder object containing metadata about the folder.namedSheets- An object mapping sheet names to their respective IDs within the folder.
Dependencies
- Smartsheet API with an API key credential for authentication
Troubleshooting
- Ensure the Folder ID is correct and accessible with the provided API credentials.
- If no sheets are returned, verify that the folder contains sheets and that the 'Children Resource Types' includes 'sheets'.
- API rate limits or network issues may cause errors; check logs and retry if necessary.