Actions13
- Manage Smartsheet Actions
- Manage Folder Actions
Manage Smartsheet → Add Rows (Line Item Supported)
AI-generatedOverview
This node operation allows users to add multiple rows to a specified Smartsheet sheet. It supports adding rows with multiple fields (columns) and their corresponding values, making it suitable for batch data entry or updating Smartsheet sheets programmatically. For example, users can add new project tasks, inventory items, or any tabular data to a Smartsheet sheet by specifying the sheet ID and the rows with their field-value pairs.
Use Case Examples
- Adding multiple rows to a project management sheet to track new tasks.
- Inserting inventory data rows into a Smartsheet sheet for stock management.
Properties
| Name | Meaning |
|---|---|
| Sheet Name or ID | The identifier of the Smartsheet sheet where rows will be added. Users can select from a list or specify an ID using an expression. |
| Rows | A collection of rows to add, where each row contains multiple fields. Each field specifies a column (by name or ID) and the value to set in that column. |
Output
JSON
rowId- The unique identifier of the newly added row in Smartsheet.rowNumber- The position number of the newly added row in the sheet.cells- An array of cell objects representing the columns and their values in the added row.
Dependencies
- Requires Smartsheet API credentials for authentication.
Troubleshooting
- Ensure the specified sheet ID is correct and accessible with the provided credentials.
- Verify that the field names or IDs correspond to existing columns in the sheet.
- Check for API rate limits or connectivity issues if requests fail.
Links
- Smartsheet API Documentation - Official API documentation for Smartsheet, useful for understanding request and response formats.