Definition and Usage
Use this command to write data to a specific row in a Lark Sheets object. You can append to the end, overwrite an existing row, or insert a new row above or below a target row index. Row numbering starts at 1.
Parameter Values
Input Parameters
Parameter Name | Description | Possible Values | Required | Options / Notes |
Lark Sheets | Target Lark spreadsheet to write data into. | Select a Lark Sheets object | Yes | Ensure you have access and the sheet exists; connect/authenticate to Lark if required. |
Write mode | How the command writes data to the sheet. | Append, Overwrite, Insert row | Yes | Append adds at the end; Overwrite replaces content at the specified row; Insert row adds a new row relative to the specified row. |
Insert position | Placement when inserting a row relative to the specified row. | below, above | Conditional | Used only when Write mode = Insert row; ignored for Append/Overwrite. |
Row | The target row index (1-based). | Positive integer (1, 2, 3, ...) | Conditional | Required for Overwrite and Insert row; for Append, it is typically ignored. |
Content | The data to write into the row. | Text, list, or structured row content as supported | Yes | Provide values in the expected row format; align number of items with columns to avoid mismatches. |
Advanced Settings
No advanced settings available.
Error Handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will stop execution. |
Retry command | The action retries the command if an error occurs. |
Ignore error & continue | The action ignores the error and continues workflow execution. |
Variables Produced
This action writes data but does not produce a new variable for downstream steps. If you need to reference the result, consider capturing subsequent sheet reads or using downstream checks.
Using Variables in Conditions
You can pass dynamic values from earlier steps into this command’s fields, such as selecting the target sheet, specifying the row number, or providing content. If the UI marks a field with {x}, it indicates that field supports variables. Use variables to:
Write to different rows based on prior calculations.
Switch write modes conditionally.
Populate row content from extracted or computed data.
Notes
Ensure the target Lark spreadsheet exists and you have permission to edit it.
Row index starts at 1; verify the row exists when using Overwrite.
Insert position applies only when Write mode is Insert row; set it to above or below as needed.
Append generally ignores Row and Insert position; it writes after the last existing row.
Content should match the number and order of columns to prevent partial or misaligned writes.
Large writes or network issues may cause timeouts; consider retries in error handling.