Definition and Usage
Search for specific content in Lark Sheets and return the cell coordinates. You can control how matches are found by:
Ignoring case: Treat uppercase and lowercase as the same.
Matching entire cell contents: Only return cells that exactly equal the search text.
Using regular expressions: Find cells matching a pattern (e.g., ^[A-Z]+).
Parameter Values
Input Parameters
Parameter Name | Description | Possible Values | Required | Options / Notes |
Lark Sheets | Select a Lark spreadsheet to search for specified content. | Any accessible Lark Sheet | Yes | Ensure you have access and the sheet is available; verify the correct sheet if multiple exist. |
Search text | The text or value to find in the Lark Sheet. | Any text; numbers; patterns | Yes | Leave empty only if your RegEx intends to match empty strings; trim unintended spaces. |
Ignore case | Treat uppercase and lowercase as the same when searching. | Enabled, Disabled | No | Enable to find matches regardless of case; commonly used with text searches. |
Match entire cell contents | Only match cells exactly equal to the search text. | Enabled, Disabled | No | Disable to allow partial matches within cells; enable for exact equality checks. |
Match with RegEx | Use a regular expression for matching (e.g., ^[A-Z]+). | Enabled, Disabled | No | When enabled, Search text is treated as a RegEx; validate your pattern to avoid errors. |
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 can produce a list containing all matching cell coordinates from the sheet. Use this list to iterate through results, reference specific cells in later steps, or validate that expected data exists before proceeding.
Using Variables in Conditions
You can pass dynamic values from earlier steps into this command. For example, feed a previously captured keyword into Search text, or choose a sheet selected in a prior step. If the UI marks a field with {x}, that field supports variables. Use variables to adapt your search based on runtime data or user inputs.
Notes
Ensure the target Lark Sheet exists and is accessible before running the command.
When both Match entire cell contents and RegEx are enabled, the RegEx must match the whole cell to succeed.
If RegEx is enabled, invalid patterns can cause errors; test patterns beforehand.
Coordinate format is row:column (e.g., 1:1 means Row 1, Column 1); use this consistently in downstream steps.
Large sheets or broad searches may take longer; narrow the search when possible.