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 their data. Specifically, the Add Rows (Using Column Label) operation allows users to add multiple rows to a specified Smartsheet by referencing columns via their labels or IDs. This is useful for automating data entry into Smartsheet from other systems or workflows.

Common scenarios include:

  • Importing bulk data from external sources into a Smartsheet.
  • Automating row additions based on triggers in other applications.
  • Synchronizing data updates where new rows need to be appended dynamically.

For example, you might use this node to add sales records collected from a form directly into a Smartsheet tracking sales performance, specifying each column by its label and providing corresponding values.

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 A collection of rows to add. Each row contains fields where you specify the column (by label or ID) and the value to insert. Multiple rows can be added at once.

The Row property supports multiple entries, allowing batch insertion of rows. For each field within a row, you select the column and provide the value to insert.

Output

The output JSON contains the result of the API call to add rows. It typically includes details about the newly added rows such as their IDs and any metadata returned by Smartsheet.

Example structure (simplified):

{
  "result": [
    {
      "id": 123456789,
      "cells": [
        {"columnId": 111, "value": "Example Value"},
        ...
      ],
      ...
    },
    ...
  ]
}

If the operation succeeds, the output provides confirmation and details of the rows added. There is no binary data output for this operation.

Dependencies

  • Requires an active Smartsheet API credential configured in n8n with appropriate permissions to read sheets and add rows.
  • The node uses the Smartsheet REST API v2 endpoint: https://api.smartsheet.com/2.0.
  • Network access to Smartsheet's API must be available.

Troubleshooting

  • No rows specified error: If you attempt to add rows without specifying any row data, the node will throw an error. Ensure that the "Row" property has at least one row with valid fields.
  • Invalid Sheet ID or Name: If the sheet cannot be found or accessed, verify that the Sheet Name or ID is correct and that the API credentials have access rights.
  • Column not found: When specifying fields, ensure the column labels or IDs exist in the target sheet. Mismatches will cause errors.
  • API rate limits or connectivity issues: Network problems or hitting Smartsheet API limits may cause failures. Check network connectivity and consider retry logic if needed.
  • Data type mismatches: Some columns expect specific data types (e.g., numbers). Providing incompatible values may cause errors or unexpected behavior.

Links and References

This summary focuses on the Manage Smartsheet resource and the Add Rows (Using Column Label) operation as requested.

Discussion