Feishu Node icon

Feishu Node

Feishu Node

Actions106

Overview

This node, named "Feishu Node," provides integration with Feishu's services, specifically supporting operations on various resources. For the resource "电子表格" (Spreadsheet), it supports an operation called "拆分单元格" (Unmerge Cells). This operation allows users to unmerge previously merged cells within a specified range in a spreadsheet.

Typical use cases include:

  • Automating the process of unmerging cells in spreadsheets managed in Feishu.
  • Preparing spreadsheet data for further processing or analysis by ensuring all cells are individual and not merged.
  • Cleaning up spreadsheet formatting programmatically as part of a larger workflow.

For example, if a user has a spreadsheet where some cells are merged across rows or columns, this node can be used to split those merged cells back into individual cells over a defined range.

Properties

Name Meaning
电子表格 Token The token string that authenticates access to the target spreadsheet.
单元格范围 The cell range to unmerge, formatted as <sheetId>!<startPosition>:<endPosition>.
  • 电子表格 Token: Required to authorize the node to access and modify the spreadsheet.
  • 单元格范围: Specifies which cells to unmerge, using a notation combining the sheet identifier and the cell range.

Output

The node outputs JSON data representing the result of the unmerge 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 unmerge action or error details if the operation failed.

No binary data output is indicated.

Dependencies

  • Requires an API key credential to authenticate with Feishu's spreadsheet service.
  • The node depends on Feishu's API endpoints to perform the unmerge cells operation.
  • Proper configuration of credentials in n8n is necessary to enable communication with Feishu.

Troubleshooting

  • Common Issues:

    • Invalid or expired spreadsheet token leading to authentication failures.
    • Incorrectly formatted cell range causing the API to reject the request.
    • Attempting to unmerge cells in a range where no cells are merged.

  • Error Messages:

    • Errors related to missing or invalid tokens will require checking the provided token and re-authenticating.
    • Range format errors should be resolved by verifying the syntax <sheetId>!<startPosition>:<endPosition>.
    • API errors may be wrapped and surfaced as node execution errors; enabling "Continue On Fail" can help isolate problematic items.

Links and References

Discussion