LarkInstall

Summary

Searches the specified range in a Lark spreadsheet and replaces matching cell contents with the replacement string.

Inputs

• Authentication — Choose Tenant Access Token or User Access Token credentials.
• 电子表格 ID (required) — Select a spreadsheet from the list or enter its ID.
• 工作表 ID (required) — Select a sheet in the spreadsheet or enter its ID.
• 单元格范围 (required) — Range to search, such as !A1:B2.
• 搜索关键字 (required) — Text or pattern to find in the range.
• Replacement(替换字符串) (required) — String to use in place of each match.
• 选项 — Optionally ignore case, match entire cells, search with a regular expression, or search only cell formulas. All options default to false.

Output shape

A list of items containing the Lark API response for each input item.

The operation updates matching cells in the spreadsheet. The source pack does not show the operation-specific API response fields.

Examples

Example 1: Replace occurrences of “draft” with “final” in !A1:B2 on a selected sheet.

Set the spreadsheet and sheet IDs, range, search keyword, and replacement string; optionally enable case-insensitive or whole-cell matching.

Links

• n8n community nodes installation guide