Get Sheet Range - BlinkOps Documentation

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

Parameter	Description
Range	The 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 ID	The ID of the sheet to get the range from. Use the `Get Spreadsheet Metadata` action to retrieve available sheet IDs.
Spreadsheet Token	The 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/shtcnmBAyGehy8`, the token is: `shtcnmBAyGehy8`.

Advanced Parameters

Parameter	Description
Date Time Render Option	How to render date and time values.
Value Render Option	How 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

Preview this Workflow on desktop