Sheet - Team L.C.L Excavation icon

Sheet - Team L.C.L Excavation

Read, update, write and delete data from Smartsheet API

Actions13

Overview

This node enables managing Smartsheet data, specifically supporting operations on sheets such as adding rows, deleting rows, renaming sheets, retrieving sheet data, and manipulating columns. The "Delete Rows" operation allows users to delete one or more rows from a specified Smartsheet by providing their row IDs.

Common scenarios for this node include automating data cleanup in Smartsheet, removing outdated or incorrect entries, and integrating Smartsheet row management into broader workflows. For example, after processing certain records externally, you might want to automatically delete corresponding rows in a Smartsheet to keep it up-to-date.

Properties

Name Meaning
Sheet Name or ID Select the target sheet by name or specify its ID. The list is dynamically loaded from your Smartsheet account.
Row IDs (Comma-Separated IDs) Provide one or multiple row IDs separated by commas that you want 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 information about the deletion result, such as which rows were successfully deleted or ignored if not found.

No binary data output is produced by this operation.

Dependencies

  • Requires an active connection to the Smartsheet API via an API key credential configured in n8n.
  • The node uses the official Smartsheet REST API v2 endpoint (https://api.smartsheet.com/2.0).
  • The user must have appropriate permissions on the target Smartsheet to delete rows.

Troubleshooting

  • Error: "No rows specified"
    This error occurs if the "Row IDs" property is empty or missing. Ensure you provide at least one valid row ID to delete.

  • Row IDs Not Found / Ignored
    If some row IDs do not exist in the sheet, the API ignores them without failing the entire request due to the ignoreRowsNotFound flag. Verify that the row IDs are correct and belong to the specified sheet.

  • Permission Errors
    If the API returns permission-related errors, confirm that the API key has sufficient rights to modify the sheet and delete rows.

  • Invalid Sheet ID
    If the sheet ID is invalid or inaccessible, the node will fail. Double-check the sheet selection or ID input.

Links and References

Discussion