Feishu Node

Overview

This node interacts with a spreadsheet service to add rows or columns to a specified worksheet within a spreadsheet. It is useful when you need to dynamically expand the size of a sheet by inserting additional rows or columns programmatically. For example, if you are automating data collection and want to ensure there is enough space for new entries, this node can increase the dimensions accordingly.

Properties

Name	Meaning
电子表格 Token	The token used to authenticate and access the spreadsheet.
工作表 ID	The identifier of the specific worksheet within the spreadsheet where rows/columns are added.
更新的维度	The dimension to update: either "行" (ROWS) or "列" (COLUMNS).
增加的行数或列数	The number of rows or columns to add; must be between 1 and 5000.

Output

The node outputs JSON data representing the result of the add-dimension operation. This typically includes confirmation of the updated spreadsheet state or metadata about the change. There is no indication that binary data is output by this node.

Dependencies

• Requires an API token credential to authenticate with the spreadsheet service.
• The node depends on a resource-operation handler system internally to execute the correct method based on the selected resource ("电子表格") and operation ("增加行列").
• No external environment variables are explicitly required beyond the provided token.

Troubleshooting

• Common issues:
  • Invalid or expired spreadsheet token may cause authentication failures.
  • Providing an incorrect or non-existent worksheet ID will result in errors.
  • Specifying a length outside the allowed range (0, 5000] will likely cause validation errors.
• Error messages:
  • If the operation is not implemented for the given resource-operation pair, the node throws an error indicating the method is unimplemented.
  • API-related errors are caught and reported; enabling "continue on fail" allows processing subsequent items despite errors.
• To resolve errors, verify the token validity, confirm the worksheet ID exists, and ensure the length parameter is within the valid range.

Links and References

• Refer to your spreadsheet service's API documentation for details on how tokens and sheet IDs are managed.
• Consult n8n documentation on handling credentials and node parameters for best practices.