Feishu Node

Overview

This node interacts with a spreadsheet service to read values from a specified range within a spreadsheet. It is useful for automating data retrieval tasks where you need to extract tabular data from spreadsheets for further processing, reporting, or integration with other systems.

Typical use cases include:

• Extracting sales data or inventory lists from a shared spreadsheet.
• Reading user input or form responses stored in a spreadsheet.
• Automating data synchronization between spreadsheets and other applications.

For example, you can specify a sheet and cell range like Sheet1!A1:C10 to retrieve all values in that block, optionally controlling how the values and dates are formatted.

Properties

Name	Meaning
电子表格 Token	The token string used to authenticate access to the spreadsheet.
范围	The query range in the format <sheetId>!<startCell>:<endCell>, e.g., Sheet1!A1:B10.
值渲染选项	Specifies how cell data is returned. Options: ToString, Formula, FormattedValue, UnformattedValue.
日期时间渲染选项	Specifies the format for date/time/datetime cell data. Only option: FormattedString.
用户 ID 类型	When cells contain user mentions (e.g., @user), this sets the type of user ID returned. Options: open_id, union_id.

Output

The node outputs JSON data representing the values retrieved from the specified spreadsheet range. Each item corresponds to one input item processed, containing the extracted cell values structured as arrays or objects depending on the underlying API response.

If the spreadsheet contains user mentions, the output includes user IDs according to the selected user ID type.

No binary data output is indicated by the source code.

Dependencies

• Requires an API authentication token ("电子表格 Token") to access the spreadsheet service.
• The node depends on an external spreadsheet API client implemented internally (not shown in the snippet).
• Proper credentials must be configured in n8n to allow authorized access.

Troubleshooting

• Invalid token or authentication failure: Ensure the provided spreadsheet token is correct and has sufficient permissions.
• Incorrect range format: The range must follow the pattern <sheetId>!<startCell>:<endCell>. Invalid formats will cause errors.
• Unsupported value render options: Use only the listed options (ToString, Formula, etc.) to avoid unexpected results.
• User ID type mismatch: If user mentions are not resolved correctly, verify the chosen user ID type matches your system's expectations.
• API errors: Network issues or API limits may cause failures; check logs for detailed error messages.

Links and References

• Refer to your spreadsheet service’s API documentation for details on range notation and value rendering options.
• Consult n8n documentation on credential setup and node usage best practices.