Feishu Node

Overview

This node, named "Feishu Node," provides integration with a spreadsheet service to perform various operations on spreadsheets. Specifically, the "合并单元格" (Merge Cells) operation allows users to merge a range of cells within a specified sheet. This is useful for formatting spreadsheets by combining multiple adjacent cells into one, which can improve readability or create headers spanning multiple columns or rows.

Practical examples include:

• Merging header cells across several columns to create a unified title.
• Combining cells in a row or column to group related data visually.
• Formatting reports or dashboards where merged cells enhance layout clarity.

Properties

Name	Meaning
电子表格 Token	The token string used to authenticate and access the spreadsheet.
单元格范围	The range of cells to merge, formatted as <sheetId>!<startPosition>:<endPosition>.
合并类型	Specifies how to merge cells. Options are:
	- 合并所有单元格 (MERGE_ALL): Merge all selected cells into one cell.
	- 按行合并 (MERGE_ROWS): Merge cells row-wise within the range.
	- 按列合并 (MERGE_COLUMNS): Merge cells column-wise within the range.

Output

The node outputs JSON data representing the result of the merge operation. Each output item corresponds to an input item processed. The exact structure of the JSON output depends on the underlying API response but generally includes confirmation of the merge action or details about the updated spreadsheet state.

No binary data output is indicated.

Dependencies

• Requires an API token ("电子表格 Token") to authenticate requests to the spreadsheet service.
• The node depends on an external spreadsheet API accessible via this token.
• Proper configuration of credentials in n8n is necessary to provide this token securely.

Troubleshooting

• Common issues:
  • Invalid or expired token leading to authentication failures.
  • Incorrectly formatted cell range strings causing errors in specifying the target cells.
  • Attempting to merge non-adjacent or invalid cell ranges.
• Error messages:
  • Errors indicating unimplemented methods if the resource-operation pair is not supported.
  • API errors returned from the spreadsheet service, such as permission denied or invalid range.
• Resolutions:
  • Verify the token is valid and has sufficient permissions.
  • Ensure the cell range follows the required format and references existing sheets and cells.
  • Use the correct merge type option matching the intended merge behavior.

Links and References

• Refer to the spreadsheet service's official API documentation for details on cell merging and range formats.
• Consult n8n documentation on credential management and custom node development for secure token handling.