Feishu Node icon

Feishu Node

Feishu Node

Actions106

Overview

This node, named "Feishu Node," integrates with the Feishu platform to perform various operations on resources such as spreadsheets. Specifically, for the resource "电子表格" (Spreadsheet) and operation "新增工作表" (Add Sheet), it allows users to add a new worksheet to an existing spreadsheet by specifying the spreadsheet token, the title of the new sheet, and optionally its position within the spreadsheet.

Common scenarios where this node is beneficial include:

  • Automating the creation of new sheets in a spreadsheet when new data categories or reports need to be generated.
  • Dynamically managing spreadsheet structure as part of a workflow that processes or organizes data.
  • Integrating with other systems to update spreadsheets without manual intervention.

Practical example:

  • A user wants to add a new sheet titled "Monthly Report" at the first position (index 0) in a spreadsheet identified by its token. This node can be configured to perform that action automatically whenever triggered.

Properties

Name Meaning
电子表格 Token The token identifying the target spreadsheet where the new sheet will be added.
新增工作表的标题 The title/name of the new worksheet to be created inside the spreadsheet.
新增工作表的位置 The position index where the new worksheet should be inserted; defaults to 0 (first).

Output

The node outputs JSON data representing the result of the operation. Typically, this would include details about the newly created worksheet such as its ID, title, and position within the spreadsheet. If the operation fails, error information is returned in the output JSON.

The node does not explicitly handle binary data output.

Dependencies

  • Requires an API key credential for authenticating with the Feishu platform.
  • The node depends on the Feishu API to manage spreadsheets and worksheets.
  • Proper configuration of credentials in n8n is necessary to authorize requests.
  • The node uses internal helper methods from the n8n workflow environment to execute API calls and handle errors.

Troubleshooting

  • Common issues:

    • Invalid or expired spreadsheet token leading to authentication or authorization failures.
    • Specifying an invalid index for the new sheet position (e.g., negative numbers or out-of-range values).
    • Network connectivity problems preventing communication with the Feishu API.

  • Error messages:

    • "未实现方法: 电子表格.新增工作表" ("Unimplemented method: Spreadsheet.AddSheet") indicates the requested operation is not supported or incorrectly specified.
    • API errors wrapped as NodeApiError may contain detailed cause information; check the error message for specifics.

  • Resolutions:

    • Verify the spreadsheet token is correct and has sufficient permissions.
    • Ensure the index value is valid and within the allowed range.
    • Check network connectivity and retry the operation.
    • Enable "Continue On Fail" option if partial processing is acceptable.

Links and References

Discussion