Lark icon

Lark

Consume Lark API

Actions118

表格 → 读取数据

AI-generated

Summary

Read values from a specified range in a Lark spreadsheet. Choose the spreadsheet and sheet, enter a cell range, and optionally control how cell values and user IDs are rendered.

Inputs

  • Authentication — Choose Tenant Access Token or User Access Token authentication.
  • 电子表格 ID (required) — Select a spreadsheet from the list or enter its ID.
  • 工作表 ID (required) — Select a sheet from the spreadsheet or enter its ID.
  • 单元格范围 (required) — Range to read, in start:end format such as !A1:B2.
  • Value Render Option — Choose whether returned cell values are plain text, formulas, formatted values, or calculated unformatted values. Defaults to ToString.
  • Date Time Render Option — Date and time values use FormattedString rendering by default.
  • 用户 ID 类型 — Choose the user ID format: Open ID, Union ID, or User ID. Defaults to Open ID.

Output shape

A list of n8n items containing the Lark API response data for the requested range.

The operation returns the API response data through the node's standard JSON output; exact fields depend on the Lark API response and selected render options.

Links

Discussion