Feishu Node

Actions61

Overview

The "电子表格: 追加数据" (Spreadsheet: Append Data) operation in this custom n8n node allows users to append data to a Feishu (Lark) spreadsheet. This is useful for automating workflows where new rows or values need to be added to an existing sheet, such as logging form submissions, updating reports, or collecting results from various sources.

Practical examples:

Automatically add survey responses to a central spreadsheet.
Log error events or notifications into a tracking sheet.
Aggregate sales or inventory updates from multiple systems.

Properties

Name	Type	Meaning
电子表格 Token	String	The token of the spreadsheet. Required for authentication and identifying the target file.
范围	String	The range to which data will be appended. Format: `<sheetId>!<start>:<end>`.
数据	JSON	The data to append. See Feishu API documentation for structure.
插入数据选项	Options	Specifies how to append data: "覆盖" (Overwrite) or "插入行" (Insert Rows).

Output

The output is a JSON object reflecting the result of the append operation for each input item.
If an error occurs and "Continue On Fail" is enabled, the output will include an error field with the error message (and possibly additional error details if available).

Example success output:

{
  "spreadsheetToken": "...",
  "updatedRange": "...",
  "updatedRows": ...,
  "updatedColumns": ...,
  "data": [...]
}

Example error output (when "Continue On Fail" is enabled):
```
{
  "error": "Error message here"
}
```

Dependencies

External Service: Requires access to the Feishu (Lark) Spreadsheet API.
API Key/Credentials: Needs valid Feishu credentials configured in n8n under feishuCredentialsApi.
Environment: No special environment variables are required beyond standard n8n credential setup.

Troubleshooting

Common Issues:
- Invalid Token: If the "电子表格 Token" is incorrect or expired, the node will fail to authenticate.
- Incorrect Range Format: The "范围" property must follow the correct format (<sheetId>!<start>:<end>), otherwise the API may reject the request.
- Malformed Data: The "数据" property must match the expected JSON structure; refer to the Feishu API documentation for details.
- Permission Denied: Ensure the authenticated user has write access to the target spreadsheet.
Error Messages:
- "未实现方法: 电子表格.追加数据": Indicates the requested resource-operation combination is not implemented.
- "NodeApiError": Usually means an API call failed; check the error details for more information.
- "Error message here": General errors will be included in the output if "Continue On Fail" is enabled.