Definition and Usage
Use this command to write data into a specific column of a Lark Sheets object. You select the target sheet, choose the column by index or letter, and provide the content to be written. The command fills the specified column with the given data.
Parameter Values
Input Parameters
Parameter Name | Description | Possible Values | Required | Options / Notes |
Lark Sheets | Target Lark Sheets object where data will be written. | Any accessible Lark spreadsheet | Yes | Ensure you have access permissions; the sheet must exist and be reachable. |
Column | Column identifier to receive the data. | Numeric index starting at 1; letter like A | Yes | Index starts at 1; letters follow standard spreadsheet notation (A, B, ...). |
Content to write | The data to write into the selected column. | Any text/value | Yes | Provide content compatible with your sheet’s expected format; large datasets may take longer. |
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 doesn't produce any variables.
Using Variables in Conditions
You can pass dynamic values from earlier steps into this command by using variables for the Lark Sheets selection, the Column, and the Content to write fields. If the UI marks fields with {x}, it indicates those fields support variables. Common patterns include:
Referencing a sheet object captured in a previous step.
Calculating the target column index or letter based on prior logic.
Supplying content generated or transformed earlier in the workflow.
Notes
Confirm the target Lark Sheets document is available and you have edit permissions.
Verify the column reference: use 1-based index or a valid column letter; avoid mixing formats (e.g., “1A”).
Ensure the content format matches downstream formulas or validations in the sheet to prevent write failures.
Writing to a protected or locked column will fail; adjust permissions or target a different column.
Large writes may be slower; consider batching content if supported by your workflow design.