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 integrates with the Smartsheet API to manage sheets and folders, enabling users to perform various operations such as adding, updating, deleting rows, renaming sheets, managing columns, and finding rows or columns based on criteria. Specifically, the Update Row (Using Column Name) operation allows updating a specific row in a Smartsheet by specifying the row ID and providing column name-value pairs for the update.

Common scenarios where this node is beneficial include:

  • Automating updates to project management sheets by modifying row data dynamically.
  • Synchronizing external data sources with Smartsheet rows by updating values based on column names.
  • Managing inventory or task lists where row details need frequent updates without manually editing the sheet.

Practical example:

  • You have a Smartsheet tracking sales leads. When a lead's status changes in your CRM, you use this node to update the corresponding row in Smartsheet by specifying the row ID and the new status value keyed by the column name "Status".

Properties

Name Meaning
Sheet Name or ID Select the target Smartsheet by name or specify its ID.
Row ID The unique identifier of the row to update within the selected sheet.
Columns (Name and Value Pair) A JSON string representing an object where keys are column names and values are the new cell values to set in the specified row.

Example of the Columns property value:

{
  "Status": "Completed",
  "Priority": "High"
}

Output

The node outputs JSON data representing the updated row as returned by the Smartsheet API. The structure includes at least the row ID and the updated cells with their respective column IDs and values.

If multiple items are processed, the output is an array of such updated row objects, each corresponding to one input item.

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 Smartsheet REST API v2 endpoint https://api.smartsheet.com/2.0.
  • Proper permissions on the Smartsheet account to read sheet metadata and update rows.

Troubleshooting

  • Error: Column - [ColumnName] not found
    This occurs if the provided column name in the JSON string does not exist in the target sheet. Verify that the column names exactly match those in the Smartsheet, including case and spacing.

  • Invalid JSON in Columns property
    The Columns field expects a valid JSON string. Ensure the input is properly formatted JSON representing an object with column name keys.

  • Row ID not found or invalid
    Confirm that the row ID exists in the specified sheet. You can retrieve row IDs using other node operations like "Get Sheet" or "Find Rows".

  • API authentication errors
    Check that the API key credential is correctly configured and has sufficient permissions.

  • Empty or missing Sheet ID
    The sheet must be specified either by selecting from the dropdown or providing a valid sheet ID expression.

Links and References

Discussion