Feishu Node icon

Feishu Node

Feishu Node

Actions106

Overview

This node integrates with a spreadsheet service to append data to a specified range within a spreadsheet. It is useful for automating the process of adding new rows or updating existing data in spreadsheets, such as logging events, collecting form responses, or updating inventory records.

For example, you can use this node to append sales data collected from an e-commerce platform into a monthly report spreadsheet automatically, or to insert new user feedback entries into a shared team spreadsheet.

Properties

Name Meaning
电子表格 Token The token used to authenticate and access the target spreadsheet.
范围 The range in the spreadsheet where data will be appended, formatted as <sheetId>!<start>:<end>.
数据 The JSON-formatted data to append, structured according to the spreadsheet API specification.
插入数据选项 Method of appending data: either "覆盖" (overwrite existing data) or "插入行" (insert new rows).

Output

The node outputs JSON data representing the result of the append operation. This typically includes metadata about the update, such as the number of cells updated or confirmation of successful insertion. No binary data output is indicated.

Dependencies

  • Requires an API token credential for authenticating with the spreadsheet service.
  • The node depends on the external spreadsheet API endpoint that supports appending values.
  • Proper configuration of the API token in n8n credentials is necessary.

Troubleshooting

  • Common issues:
    • Invalid or expired token leading to authentication failures.
    • Incorrect range format causing API errors.
    • Data format not matching the expected JSON structure for the spreadsheet API.
  • Error messages:
    • Errors related to "未实现方法" (unimplemented method) indicate unsupported resource-operation combinations.
    • API errors returned by the spreadsheet service may include details in the error message; ensure the token and range are correct.
  • Resolutions:
    • Verify and refresh the spreadsheet token.
    • Double-check the range string format.
    • Validate the JSON data structure against the API documentation linked in the property description.

Links and References

Discussion