Feishu Node

Overview

This node, named "Feishu Node," provides integration with a spreadsheet service (likely Feishu's spreadsheet). The specific operation "自动写入数据" (Auto Write Data) allows users to automatically write structured data into a specified worksheet within a spreadsheet. This is useful for scenarios where you want to programmatically update or append rows of data based on incoming JSON objects, such as logging form submissions, syncing data from other systems, or automating report generation.

Practical examples:

• Automatically appending new sales records received from an API into a sales tracking spreadsheet.
• Writing user feedback collected from a web form directly into a shared spreadsheet for team review.
• Syncing inventory updates from an external database into a centralized spreadsheet.

Properties

Name	Meaning
电子表格 Token	The token used to authenticate and access the spreadsheet.
工作表 ID	The identifier of the worksheet within the spreadsheet where data will be written.
数据	An array of JSON objects representing the data rows to write; keys correspond to headers.
开始行数	The starting row number in the worksheet where writing begins (1-based index).
是否显示表头	Boolean flag indicating whether to include the header row when writing data.

Output

The node outputs JSON data representing the result of the write operation. Each output item corresponds to an input item processed, containing either the success response or error details if the operation failed. The exact structure depends on the underlying API response but generally includes confirmation of written rows or error messages.

No binary data output is indicated by the source code or properties.

Dependencies

• Requires an API token ("电子表格 Token") to authenticate requests to the spreadsheet service.
• The node depends on an external spreadsheet API accessible via this token.
• No additional environment variables or n8n-specific credentials are explicitly mentioned beyond the token property.

Troubleshooting

• Common issues:

  • Invalid or expired token leading to authentication failures.
  • Incorrect worksheet ID causing the node to fail to locate the target sheet.
  • Mismatch between keys in the "数据" JSON objects and the actual spreadsheet headers, potentially causing data misalignment.
  • Starting row number out of range or overlapping existing data unintentionally.

• Error messages:

  • Errors thrown during execution are wrapped and reported with context including resource, operation, and item index.
  • If the node is configured to continue on failure, errors for individual items are returned in the output JSON under an error field.
  • Authentication errors typically require checking the validity and permissions of the provided token.
  • API errors may indicate quota limits or malformed requests; reviewing the data format and API documentation can help resolve these.

Links and References

• Feishu Spreadsheet API documentation (if publicly available)
• n8n documentation on creating custom nodes and handling JSON data inputs
• General guides on working with spreadsheets programmatically (e.g., Google Sheets API concepts, which are similar)

---

If you need more detailed information about the internal API calls or error handling logic, please provide the relevant source code files or specify further.