Get Range From Spreadsheet
danger
This action has been deprecated and will no longer be available in new workflows.
Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.
Basic Parameters
Parameter | Description |
---|---|
Major Dimension | The major dimension that results should use. For example, if the spreadsheet data in Sheet1 is: A1=1,B1=2,A2=3,B2=4 , then requesting range=Sheet1!A1:B2?majorDimension=ROWS returns [[1,2],[3,4]] , whereas requesting range=Sheet1!A1:B2?majorDimension=COLUMNS returns [[1,3],[2,4]] . |
Range | Sets the ranges of values from the spreadsheet which will be returned, in the form of startCell :endCell to be returned.For example, A1-E1 will return the first five cells in the first row. |
Spreadsheet ID | The ID of the spreadsheet to retrieve data from. |
Advanced Parameters
Parameter | Description |
---|---|
Date Time Render Option | How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. |
Delegated User Override | Perform the action on behalf of another user, overriding the delegated user defined in the connection. If not specified, the delegated user is the one provided in the connection. Has no effect when using an OAuth connection. NOTE: the connection details are not edited by this input. |
Example Output
{
"range": "Sheet1!A2:E2",
"majorDimension": "ROWS",
"values": [
[
"a",
"b",
"c",
"d",
"a"
]
]
}
Workflow Library Example
Get Range from Spreadsheet with Google Sheets and Send Results Via Email