Feishu Node icon

Feishu Node

Feishu Node

Actions106

Overview

This node integrates with a spreadsheet service (likely Feishu Sheets) to write data into specified ranges within a spreadsheet. It is useful for automating updates or inserting new data rows/columns programmatically into spreadsheets without manual intervention.

Common scenarios include:

  • Automatically logging data from other workflows into a spreadsheet.
  • Updating reports or dashboards by writing calculated values.
  • Syncing external data sources into a spreadsheet for further analysis.

For example, you can use this node to write sales figures into a monthly report sheet by specifying the target range and providing the data array.

Properties

Name Meaning
电子表格 Token The authentication token required to access the spreadsheet.
范围 The cell range where data will be written, formatted as <sheetId>!<start>:<end>.
数据 The data to write, provided as a JSON array. Supports various data types as per the spreadsheet API.

Output

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

No binary data output is produced by this node.

Dependencies

  • Requires an API token credential to authenticate with the spreadsheet service.
  • Depends on the spreadsheet service's API endpoint that supports writing values to sheets.
  • The node uses internal helper methods to construct execution metadata and handle errors.

Troubleshooting

  • Invalid Token or Authentication Failure: Ensure the provided spreadsheet token is valid and has sufficient permissions.
  • Incorrect Range Format: The range must follow the format <sheetId>!<start>:<end>. Mistakes here will cause API errors.
  • Data Format Issues: The 数据 property must be a valid JSON array matching the expected data types supported by the spreadsheet API.
  • API Errors: If the underlying API returns errors, they are surfaced as node errors. Check error messages for details.
  • Continue On Fail Behavior: If enabled, the node will continue processing subsequent items even if some fail, returning error details in the output.

Links and References

Discussion