Retrieve data from a row in Google Sheets
Retrieves one or more fields from a row in a Google Sheets spreadsheet. Data should be organized as a table with column headers in the first row. Every row other than the headers represents a set of data to be captured.
Common use cases
- Data Manipulation
Category
- Google Sheets
Inputs (what you have)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|---|---|---|---|
| Spreadsheet link | Link of the Google Sheets spreadsheet.Note: Spreadsheet should provide view access to anyone accessing the spreadsheet via the URL (i.e. Anyone with the link). | Link | Yes | https://docs.google.com/spreadsheets/d/1-/edit |
| Row number | Row where the values reside | Number | Yes | 2 |
| Fields to capture | Add all headers where the data should be retrieved from. Headers must have the exact names as seen in the sheet and the correct data type.Note: Headers defined here will also act as outputs to the Wrk Action | Any of the following:TextDecimalsIntegersTrue/FalseWebsite Link | Yes | 2 |
| Sheet name | The name of the Google Sheets tab. First tab will be used by default. Sheet name is case sensitive | Text | No | REQ |
Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data library. These variables in the Data library section are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
| NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
|---|---|---|---|---|
| To be defined | The outputs will be defined by the user within the Fields to capture section. | Any of the following:TextDecimalsIntegersTrue/FalseWebsite Link | Yes |
Outcomes
| NAME | DESCRIPTION |
|---|---|
| Success | This status is selected if the value from specified fields was successfully retrieved from the specified row in a Google Sheets. |
| Missing Info | This status is selected in the event of the following scenarios:- If the first row does not contain the titles of the columns |
| Unsuccessful | This status is selected in the event of the following scenarios:- If the Google Sheets spreadsheet link is missing or incorrect- If the access to the Google sheet is denied |
Requirements
-
The data within the spreadsheet should be formatted as a table, with header names located in Row 1 of the sheet
-
All Drives and Sheets need to be shared with:
googlewrkbots@wrk.com