Read data from a specific range in a Lark Sheets spreadsheet. One of the following scopes is required for using this action:
  • View, comment, edit, and manage all files in My Space
  • View, comment, and download all files in My Space
  • View, comment, edit, and manage Sheets
  • View, comment, and export Sheets
External DocumentationTo learn more, visit the Lark documentation.

​
Basic Parameters

ParameterDescription
RangeThe cell range to read from the spreadsheet.

Examples:
* A1:C10 - Read cells from A1 to C10.
* A:A - Read entire column A.

For more information about the range parameter, visit Lark API documentation.
Sheet IDThe ID of the sheet to get the range from.

Use the Get Spreadsheet Metadata action to retrieve available sheet IDs.
Spreadsheet TokenThe token of the spreadsheet.

This token can be found in the spreadsheet URL - https://sample.larksuite.com/sheets/{SPREADSHEET_TOKEN}.

For example, if the sheet URL is https://sample.larksuite.com/sheets/shtcnmBA*yGehy8, the token is: shtcnmBA*yGehy8.

​
Advanced Parameters

ParameterDescription
Date Time Render OptionHow to render date and time values.
Value Render OptionHow to render cell values in the response.

​
Example Output

{
	"code": 0,
	"data": {
		"revision": 0,
		"spreadsheetToken": "***",
		"valueRange": {
			"majorDimension": "ROWS",
			"range": "***",
			"revision": 0,
			"values": [
				[
					"***"
				]
			]
		}
	},
	"msg": "Success"
}

​
Workflow Library Example

Get Sheet Range with Lark and Send Results Via Email
Workflow LibraryPreview this Workflow on desktop