Get Values
GetValues reads one range of values from a spreadsheet.
It calls GET https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}.
The activity has 4 tabs: Configuration, Auth, Input, and Output.
Configuration
| Field | Required | Description |
|---|---|---|
| Name | Optional | Name of the step, should be unique within this workflow. |
| Description | Optional | Describe the purpose or function of this step. |
| Spreadsheet Id | Optional | Enter the ID of the spreadsheet to access. |
| Range | Optional | Specify the range of cells to access in the spreadsheet. |
| Value Render Option | Optional | Specify how to render values in the response. |
| Date Time Render Option | Optional | Specify how to render date and time values in the response. |
| Major Dimension | Optional | Specify the major dimension for the data (ROWS or COLUMNS). |
Auth
| Field | Required | Description |
|---|---|---|
| Auth Type | Optional | The authentication method for the request. OAuth 2 is the only option, and the default. |
| Auth Resource | Optional | OAuth resource containing credentials. |
Input
This activity is built on the REST Client, so the Input tab is the generic HTTP request rather than a Google Sheets-shaped payload.
| Field | Required | Data Type | Description |
|---|---|---|---|
| Target | Required | Object | The HTTP request. |
Output
The activity returns an httpResponse object.
| Field | Data Type | Description |
|---|---|---|
| status.code | Integer | Numeric HTTP status code. |
| status.message | String | Short message associated with the HTTP status. |
| headers | Object | HTTP response headers. |
| body | Object | Parsed body of the response. |
The response body carries:
| Field | Data Type |
|---|---|
| range | String |
| majorDimension | String |
| values | Array |
The output schema names these fields without describing them.