Feishu Node

Overview

This node provides functionality to move rows or columns within a spreadsheet. It is useful when you need to reorder data in a sheet programmatically, such as shifting a range of rows or columns to a new position without manually cutting and pasting. Practical examples include reorganizing report layouts, adjusting data tables dynamically, or automating spreadsheet formatting tasks.

Properties

Name	Meaning
电子表格 Token	The token used to authenticate access to the spreadsheet.
工作表 ID	The identifier of the specific worksheet within the spreadsheet where the operation occurs.
移动的维度	The dimension to move: either "行" (ROWS) or "列" (COLUMNS).
起始位置	The zero-based starting index of the row or column range to move.
结束位置	The zero-based ending index of the row or column range to move.
目标位置	The zero-based target index where the selected rows or columns should be moved to.

Output

The node outputs JSON data representing the result of the move operation. Each output item corresponds to an input item processed, containing metadata about the execution. If the operation fails for any item and "continue on fail" is enabled, the output will include error details for that item.

No binary data output is produced by this node.

Dependencies

• Requires an API token credential to authenticate with the spreadsheet service.
• Needs the spreadsheet ID and worksheet ID to identify the target location.
• The node depends on an external spreadsheet API capable of moving rows or columns based on provided indices.

Troubleshooting

• Common issues:
  • Invalid or expired spreadsheet token causing authentication failures.
  • Incorrect worksheet ID leading to "not found" errors.
  • Out-of-range indices for start, end, or destination positions causing operation failure.
• Error messages:
  • Errors thrown during the move operation are captured and can include API-specific error messages.
  • If "continue on fail" is disabled, the node stops execution on the first error.
  • To resolve errors, verify token validity, confirm worksheet existence, and ensure indices are within valid ranges.

Links and References

• Refer to your spreadsheet service's API documentation for details on moving rows and columns.
• Consult n8n documentation on handling credentials and error workflows for best practices.