Feishu Node

Overview

This node provides functionality to insert rows or columns into a spreadsheet. It is useful when you need to dynamically modify the structure of a spreadsheet by adding empty rows or columns at specified positions. Common scenarios include preparing a sheet for new data import, adjusting layout before data processing, or programmatically managing spreadsheet templates.

For example, you can insert 3 new rows starting from row index 5 to shift existing data downwards, or add a new column at position 2 to accommodate additional data fields.

Properties

Name	Meaning
电子表格 Token	The token string used to authenticate and access the target spreadsheet.
工作表 ID	The identifier of the specific worksheet within the spreadsheet where rows/columns are inserted.
更新的维度	Dimension to update: either "行" (ROWS) or "列" (COLUMNS).
起始位置	The zero-based start index where the insertion begins.
结束位置	The zero-based end index where the insertion ends (exclusive).
继承样式	Whether the inserted blank rows/columns inherit cell styles: options are "不继承" (no inheritance), "继承起始位置的样式" (inherit style from before), or "继承结束位置的样式" (inherit style from after).

Output

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

Dependencies

• Requires an API token credential to authenticate with the spreadsheet service.
• Needs the spreadsheet and worksheet IDs to identify the target location.
• The node depends on an external spreadsheet service API that supports dimension insertion operations.
• No additional environment variables or n8n configurations are explicitly required beyond providing the token credential.

Troubleshooting

• Common issues:
  • Invalid or expired token may cause authentication failures.
  • Incorrect worksheet ID or indices out of range will lead to errors.
  • Specifying an end index less than or equal to the start index might cause logical errors or no changes.
• Error messages:
  • Errors related to missing or invalid parameters will prompt users to check input values.
  • API errors from the spreadsheet service will be surfaced; ensure network connectivity and valid credentials.
• To resolve, verify all inputs carefully, refresh tokens if needed, and confirm the worksheet exists and indices are valid.

Links and References

• Refer to your spreadsheet service’s API documentation for details on inserting rows and columns and style inheritance options.
• Consult n8n documentation on how to configure API key credentials securely.