Sheet - Team L.C.L Excavation icon

Sheet - Team L.C.L Excavation

Read, update, write and delete data from Smartsheet API

Overview

This node operation allows you to copy a folder within Smartsheet from one workspace and folder location to another. It is useful when you want to duplicate an existing folder structure, including its contents such as attachments, discussions, filters, forms, rules, shares, and more, into a different workspace or folder without manually recreating it.

Common scenarios:

  • Backing up a project folder before making major changes.
  • Creating a template folder that can be copied and reused across different teams or workspaces.
  • Migrating folder contents between workspaces while preserving all associated data.

Example:
You have a folder named "Q1 Reports" in Workspace A and want to create a copy of this folder in Workspace B under a specific destination folder with a new name "Q1 Reports Copy". This operation will perform the copy including all sheets and metadata inside the folder.


Properties

Name Meaning
Source Workspace Name or ID Select or specify the workspace where the source folder currently resides.
Source Folder Name or ID Select or specify the folder to be copied from the source workspace.
Destination Workspace Name or ID Select or specify the workspace where the folder copy should be placed.
Destination Folder Name or ID Select or specify the target folder inside the destination workspace where the copied folder will be placed.
Folder Name The new name for the copied folder. Must be a string up to 50 characters.
Destination Type The type of destination where the folder will be copied. Options are:
- Folder
- Home (root folder)
- Workspace (top-level workspace folder)

Output

The output JSON contains the response from the Smartsheet API after copying the folder. This typically includes details about the newly created folder such as its ID, name, and metadata. The exact structure depends on the Smartsheet API's response but generally confirms the successful creation and properties of the copied folder.

No binary data output is involved in this operation.


Dependencies

  • Requires an active connection to the Smartsheet API using an API key credential configured in n8n.
  • The node uses Smartsheet API endpoints to list workspaces, folders, and perform the copy operation.
  • Proper permissions on both source and destination workspaces/folders are necessary to read and write folders.

Troubleshooting

  • Common issues:

    • Invalid or missing workspace or folder IDs: Ensure the selected source and destination workspaces and folders exist and are accessible.
    • Insufficient permissions: The API key must have rights to read from the source and write to the destination.
    • Folder name too long: The new folder name is trimmed to 50 characters; ensure your input respects this limit.
  • Error messages:

    • "No rows specified" or similar errors are unrelated here but may appear if other operations are mixed; focus on folder-related parameters.
    • API errors indicating permission denied or not found usually mean incorrect workspace/folder IDs or insufficient access rights.
  • Resolution tips:

    • Use the load options dropdowns to select valid workspaces and folders to avoid manual ID entry errors.
    • Verify API credentials and permissions in Smartsheet.
    • Check the new folder name length and format.

Links and References

Discussion