Feishu Node icon

Feishu Node

Feishu Node

Actions106

Overview

This node, named "Feishu Node," integrates with the Feishu platform to perform various operations on resources such as spreadsheets. Specifically, for the resource "电子表格" (Spreadsheet) and operation "插入数据" (Insert Data), it allows users to prepend data rows into a specified range within a spreadsheet. This is useful for scenarios where new data needs to be added at the beginning of an existing dataset, such as adding recent entries or logs to the top of a sheet.

Practical examples include:

  • Prepending new sales records to a sales tracking spreadsheet.
  • Adding latest user feedback entries at the top of a feedback log.
  • Inserting new inventory items before existing ones in a stock management sheet.

Properties

Name Meaning
电子表格 Token The token string used to authenticate and access the target spreadsheet.
范围 The cell range specifying where to write data, formatted as <sheetId>!<start>:<end>.
数据 The JSON-formatted data to insert, structured according to Feishu's API specification for values.

Output

The node outputs an array of JSON objects representing the result of the insert operation for each input item processed. Each output item corresponds to one execution of the insert action, containing metadata about the operation's success or failure.

If binary data were involved, it would typically represent files or attachments, but this node focuses on JSON data manipulation within spreadsheets.

Dependencies

  • Requires an API authentication token ("电子表格 Token") to access Feishu spreadsheets.
  • Depends on Feishu's open API for spreadsheet operations.
  • Needs proper configuration of credentials in n8n to securely store and use the API token.

Troubleshooting

  • Common Issues:

    • Invalid or expired token leading to authentication failures.
    • Incorrect range format causing API errors.
    • Malformed JSON data that does not conform to Feishu's expected structure.

  • Error Messages:

    • "未实现方法: 电子表格.插入数据" indicates the operation is not implemented or recognized; ensure correct resource and operation names.
    • API errors related to authorization usually mean the token is invalid or lacks necessary permissions.
    • Range errors suggest the specified range string is malformed or out of bounds.

  • Resolutions:

    • Verify and refresh the API token.
    • Double-check the range string format and correctness.
    • Validate JSON data against Feishu's documentation linked in the property description.

Links and References

Discussion