Sheet - Team L.C.L Excavation

Overview

This node integrates with the Smartsheet API to manage sheets and folders, specifically supporting operations such as adding rows, deleting rows, renaming sheets, retrieving sheet data, and more. The "Add Rows (Line Item Supported)" operation allows users to add multiple rows to a specified Smartsheet by defining fields and their values for each row.

Common scenarios where this node is beneficial include:

• Automating data entry into Smartsheet from other systems or workflows.
• Bulk importing tabular data into a Smartsheet.
• Dynamically updating project management sheets with new task rows.
• Integrating form submissions or database records into Smartsheet rows.

Practical example:

• A project management workflow collects task details via a form and uses this node to append those tasks as new rows in a Smartsheet project tracker.

Properties

The "Rows" property supports multiple entries, allowing batch addition of rows in one execution.

Output

The output JSON contains the result returned by the Smartsheet API after adding rows. This typically includes details about the newly added rows such as their IDs and cell data.

Example structure of output JSON:

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

No binary data output is produced by this operation.

Dependencies

• Requires an active connection to the Smartsheet API using an API key credential configured in n8n.
• The node depends on the Smartsheet REST API v2 endpoint https://api.smartsheet.com/2.0.
• The user must have appropriate permissions on the target Smartsheet to add rows.

Troubleshooting

• Error: No rows specified
  Occurs if the "Rows" input is empty or missing. Ensure at least one row with valid fields and values is provided.

• Invalid Sheet ID or Name
  If the specified sheet does not exist or the ID is incorrect, the API call will fail. Verify the sheet selection or ID.

• Column Not Found
  When specifying fields by ID or name, if a column does not exist in the sheet, the request will error. Use the dynamic dropdowns to select valid columns or verify column IDs.

• API Authentication Errors
  If the API key credential is invalid or expired, requests will fail. Reconfigure the API key credential in n8n.

• Rate Limits or API Quotas
  Large batch additions may hit Smartsheet API rate limits. Consider splitting large row additions into smaller batches.

Links and References

• Smartsheet API Documentation - Rows
• n8n Expressions Documentation
• Smartsheet Developer Portal