Retrieve data from Google Sheets
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 | https://docs.google.com/spreadsheets/d/1-/edit |
| 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:TextDecimalsIntegersTrue/FalseWebsite Link | 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