Feishu Node

Actions61

Overview

This custom n8n node enables users to insert data into a Feishu (Lark) spreadsheet. It is designed for scenarios where automated workflows need to write or append structured data into specific ranges of a Feishu spreadsheet, such as logging form submissions, updating reports, or synchronizing data from other systems.

Practical examples:

Automatically adding new sales records to a shared Feishu spreadsheet.
Logging support ticket information from another system into a Feishu sheet.
Syncing CRM contact updates into a Feishu spreadsheet for team visibility.

Properties

Name	Type	Meaning
电子表格 Token	String	The token identifying the target Feishu spreadsheet. Required for authentication and access.
范围	String	The range in the spreadsheet where data will be written. Format: `<sheetId>!<start>:<end>`.
数据	JSON	The data to insert, formatted according to Feishu's API requirements. Reference

Output

The node outputs an array of items, each with a json field containing the result of the insert operation. If an error occurs and "Continue On Fail" is enabled, the output item will contain an error field with the error message (and additional details if available).

Example success output:

[
  {
    "json": {
      // Response fields from Feishu API, e.g., updated range, inserted values, etc.
    }
  }
]

Example error output (when Continue On Fail is enabled):

[
  {
    "json": {
      "error": "Error message here"
    }
  }
]

Dependencies

Feishu API: Requires a valid Feishu spreadsheet token.
n8n Credentials: Must configure credentials named feishuCredentialsApi in n8n for authentication.

Troubleshooting

Missing Method Error:
- Message: 未实现方法: 电子表格.插入数据
  This means the requested resource-operation combination is not implemented. Double-check that you selected the correct resource and operation.
Authentication Errors:
- If the spreadsheet token is invalid or missing, the node will fail. Ensure the "电子表格 Token" property is set correctly and that the associated credentials are valid.
Range Format Issues:
- If the "范围" property does not match the required format (<sheetId>!<start>:<end>), the API call may fail. Double-check your range string.
Data Format Errors:
- The "数据" property must follow the structure expected by the Feishu API. Refer to the official documentation for the correct format.