Get Sheet Data
Use this action to retrieve the specific data from the spreadsheet.
Using the Get Sheet Data Action
To use this action in your workflow, connect it to ThingWorx Flow. To connect to the flow, do the following:
1. Drag the Get Sheet Data action under the Google Sheets connector to the canvas, place the pointer over the action, and then click 
or double-click the action. The Get Sheet Data action window opens.
or double-click the action. The Get Sheet Data action window opens.2. Edit the label name, if needed. By default, the label name is same as the action name.
3. To add a new authorization, refer to the section Authorize Google Sheets in the Google Sheets connector topic.
 | If you previously added a Google Sheets authorization, select an authorization from the list. |
4. In the Spreadsheet ID field, select or specify the sheet ID.
5. In the Sheet ID field, select or specify the sheet ID.
6. Click + to view the additional fields, and then enter the information that follows:
◦ Start—Return data from a specific cell, row, or column by using the notation A1, 1 or A respectively. The end index is required.
◦ End—The cell, row, or column up to which to continue the retrieve operation. For example, Z1, 1, or Z. The start index is required.
7. Click Done.