Feishu Node icon

Feishu Node

Feishu Node

Actions106

Overview

This node provides operations to manipulate electronic spreadsheets within the Feishu ecosystem. Specifically, the "删除行列" (Delete Rows or Columns) operation allows users to delete a range of rows or columns from a specified worksheet in a spreadsheet. This is useful for cleaning up data, removing unnecessary or outdated information, or restructuring the spreadsheet dynamically as part of an automated workflow.

Practical examples include:

  • Automatically deleting empty or irrelevant rows after data import.
  • Removing specific columns that are no longer needed before exporting data.
  • Cleaning up sheets by deleting header or footer rows programmatically.

Properties

Name Meaning
电子表格 Token The token string used to authenticate and identify the target spreadsheet.
工作表 ID The identifier of the worksheet within the spreadsheet where rows or columns will be deleted.
删除的维度 The dimension to delete: either "行" (Rows) or "列" (Columns).
起始位置 The starting index (1-based) of the row or column to begin deletion.
结束位置 The ending index (1-based) of the row or column to end deletion.

Output

The node outputs JSON data representing the result of the delete operation. Each output item corresponds to an input item processed. The exact structure depends on the underlying API response but generally includes confirmation of the deletion or any relevant metadata.

No binary data output is indicated.

Dependencies

  • Requires an API token ("电子表格 Token") to authenticate requests to the spreadsheet service.
  • Needs the worksheet ID ("工作表 ID") to specify the target sheet.
  • The node relies on the Feishu API or equivalent backend service to perform the deletion.
  • Proper credentials must be configured in n8n to allow authenticated access.

Troubleshooting

  • Common issues:

    • Invalid or expired token leading to authentication failures.
    • Incorrect worksheet ID causing the operation to fail because the target sheet does not exist.
    • Specifying start or end indices out of the valid range may cause errors or no changes.
    • Attempting to delete dimensions that do not exist (e.g., deleting columns when only rows exist).

  • Error messages:

    • Authentication errors typically indicate invalid tokens; verify and refresh the token.
    • "未实现方法" (Unimplemented method) error suggests the requested resource-operation combination is not supported; check if the operation name and resource are correct.
    • Index out of bounds errors require adjusting the startIndex and endIndex values to valid ranges.

Links and References

Discussion