Sheet - Team L.C.L Excavation icon

Sheet - Team L.C.L Excavation

Read, update, write and delete data from Smartsheet API
Join our community

Actions13

Overview

This node enables managing Smartsheet data, specifically supporting operations on sheets and folders within Smartsheet. The "Delete Rows" operation under the "Manage Smartsheet" resource allows users to delete one or more rows from a specified sheet by providing their row IDs.

Common scenarios for this node include automating data cleanup in Smartsheet sheets, removing outdated or irrelevant rows based on workflow logic, or integrating Smartsheet row deletion into larger automation processes.

For example, you might use this node to delete rows that meet certain criteria after processing them elsewhere, such as removing completed tasks from a project sheet or clearing out test data rows automatically.

Properties

Name Meaning
Sheet Name or ID Select the target sheet by name or specify its ID where rows will be deleted.
Row IDs (Comma-Separated IDs) Provide a comma-separated list of row IDs to delete from the selected sheet.

Output

The output JSON contains the response from the Smartsheet API after attempting to delete the specified rows. It typically includes metadata about the deletion operation, such as which rows were successfully deleted or ignored if not found.

No binary data is output by this operation.

Dependencies

  • Requires an active connection to the Smartsheet API via an API key credential.
  • The node uses the Smartsheet REST API v2 endpoint https://api.smartsheet.com/2.0.
  • Proper permissions on the Smartsheet account are necessary to delete rows in the specified sheet.

Troubleshooting

  • No rows specified: If the "Row IDs" property is empty or missing, the node throws an error stating "No rows specified". Ensure you provide valid row IDs.
  • Invalid Sheet ID or Name: If the sheet cannot be found or accessed, the API call will fail. Verify the sheet exists and the API key has access.
  • Row IDs Not Found: The node ignores rows not found during deletion (ignoreRowsNotFound: true), so no error is thrown for non-existent row IDs.
  • API Rate Limits or Permissions: Errors related to API limits or insufficient permissions may occur; check your Smartsheet API quota and user rights.
  • Malformed Row IDs: Ensure the row IDs are correctly formatted as a comma-separated string without extra spaces or invalid characters.

Links and References

Discussion