Feishu Node

Overview

This node is designed to update the dimensions (rows or columns) of a spreadsheet in an external spreadsheet service. It allows users to modify properties such as visibility and size (height for rows, width for columns) of specific rows or columns within a given sheet. This functionality is useful when automating spreadsheet formatting tasks, such as hiding certain rows/columns, adjusting their sizes for better readability, or preparing sheets dynamically based on data.

Practical examples include:

• Automatically hiding unused rows or columns in a report.
• Setting uniform column widths after importing data.
• Adjusting row heights to fit content dynamically during data processing workflows.

Properties

Name	Meaning
电子表格 Token	The token used to authenticate and access the spreadsheet.
工作表 ID	The identifier of the specific worksheet within the spreadsheet to update.
更新的维度	The dimension to update: either "行" (ROWS) or "列" (COLUMNS).
起始位置	The starting index (1-based) of the row or column range to update.
结束位置	The ending index (1-based) of the row or column range to update.
是否显示行或列	Boolean flag indicating whether the specified rows or columns should be visible or hidden.
行高或列宽	The fixed size in pixels for the row height or column width.

Output

The node outputs JSON data representing the result of the update operation on the spreadsheet dimensions. This typically includes confirmation of the updated ranges and their new properties. The output does not include binary data.

Dependencies

• Requires an API token credential to authenticate with the external spreadsheet service.
• The node depends on the external spreadsheet service's API to perform dimension updates.
• No additional environment variables are explicitly required beyond the provided token.

Troubleshooting

• Common issues:

  • Invalid or expired token leading to authentication failures.
  • Specifying invalid sheet IDs or out-of-range indices causing API errors.
  • Attempting to update dimensions without proper permissions on the spreadsheet.

• Error messages:

  • Errors related to missing or invalid tokens usually indicate authentication problems; ensure the token is correct and has necessary scopes.
  • Range errors may occur if startIndex or endIndex values are outside the valid bounds of the sheet; verify these values carefully.
  • If the node throws an error about unimplemented operations, confirm that the resource and operation names match exactly.

Links and References

• Refer to the external spreadsheet service API documentation for details on dimension updates.
• n8n documentation on custom nodes and credentials management for setting up API tokens.