Retrieves data from a Google Sheet 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.
This Wrk Action divides. For more information on divides please visit our article explaining Divides.
Common use cases
Data Manipulation
Application
Google Sheets
Inputs (what you have)
NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
Spreadsheet link | The link to the Google spreadsheet. Note that the spreadsheet should provide view access to anyone accessing the spreadsheet via the URL (i.e. Anyone with the link). | URL | Yes |
|
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 theData Library are the outputs of previous Wrk Actions in the Wrkflow.
Outputs (what you get)
NAME | DESCRIPTION | TYPE | REQUIRED | EXAMPLE |
Row number | Row number associated with the results retrieved. | Integers | Yes | 1 |
To be defined | The outputs will be defined by the user within the Fields to capture section. | Any of the following:
| Yes | 15 |
Outcomes
NAME | DESCRIPTION |
Success | This status is selected if the data was successfully retrieved from the Google Sheets sheet. |
Information missing | This status is selected if the information that has to be retrieved is missing. |
Unsuccessful | This status is selected in the event of the following scenarios:
- If the Google Sheet link is missing or incorrect
- If the access to the Google sheet is denied |
Requirements
The data within the spreadsheet should be formatted in a table, ensuring that each column in the sheet has a specific header name in Row 1 of the sheet.
All Drives and Sheets need to be shared with:
googlewrkbots@wrk.com