Feishu Node

Overview

This node provides an operation to replace cell contents within a specified range in an electronic spreadsheet. It is useful for automating bulk text replacements inside spreadsheets, such as updating outdated terms, correcting typos, or applying consistent formatting changes across multiple cells.

Practical examples include:

• Replacing all occurrences of a product name with a new one in a sales report.
• Updating status labels (e.g., changing "Pending" to "Completed") in a project tracking sheet.
• Correcting misspelled words or phrases throughout a data table.

Properties

Name	Meaning
电子表格 Token	The token string used to authenticate and access the target spreadsheet.
工作表 ID	The identifier of the specific worksheet within the spreadsheet where replacements will occur.
查找范围	The cell range to search within, formatted as <sheetId>!<startCell>:<endCell>.
查找字符串	The string to find within the specified range.
替换字符串	The string that will replace each found occurrence of the 查找字符串.
是否忽略查找字符串的大小写	Boolean flag indicating whether the search should ignore case differences (true = ignore case).
字符串是否需要完全匹配整个单元格	Boolean flag indicating if the 查找字符串 must match the entire cell content exactly (true = full match).
是否使用正则表达式查找	Boolean flag specifying whether the 查找字符串 should be treated as a regular expression pattern.
是否仅搜索单元格公式	Boolean flag indicating if the search should be limited to cell formulas only (true = formulas only).

Output

The node outputs JSON data representing the result of the replacement operation. This typically includes information about which cells were modified or the updated content after replacements. If binary data is involved (not indicated here), it would represent the spreadsheet file or related attachments.

Dependencies

• Requires an API token credential to authenticate access to the electronic spreadsheet service.
• The node depends on the external spreadsheet platform's API to perform read and write operations on sheets.
• Proper configuration of authentication credentials in n8n is necessary before use.

Troubleshooting

• Common issues:
  • Invalid or expired token causing authentication failures.
  • Incorrect sheet ID or range format leading to no matches or errors.
  • Using regex patterns without proper syntax may cause search failures.
  • Case sensitivity flags not set correctly might lead to unexpected results.
• Error messages:
  • Errors related to "未实现方法" (unimplemented method) indicate unsupported resource-operation combinations.
  • Authentication errors suggest checking the provided token and permissions.
  • Range parsing errors require verifying the format <sheetId>!<startCell>:<endCell>.

Links and References

• Refer to your spreadsheet platform’s API documentation for details on token generation and sheet/range formats.
• Regular expression syntax guides if using regex-based search.
• n8n documentation on setting up credentials and using custom nodes.