Get Sheet Data
Use the Get Sheet Data action to retrieve specific data from the spreadsheet.
Complete the following steps to use the Get Sheet Data action in your workflow:
1. Drag the Get Sheet Data action under Google Sheets to the canvas, place the pointer over the action, and then click 
or double-click the action. The Get Sheet Data window opens.
or double-click the action. The Get Sheet Data window opens.2. Edit the Label, if needed. By default, the label name is the same as the action name.
3. To add a Google Sheets connector type, refer to Supported Google Sheets Connector Types.
If you previously added a connector type, select the appropriate Connector Type, and under Connector Name, select the connector.
4. Click TEST to validate the connector.
5. Click MAP CONNECTOR to execute the action using a connector that is different from the one that you are using to populate the input fields. In the Runtime Connector field, provide a valid Google Sheets connector name. For more information about MAP CONNECTOR, see Using Map Connector.
6. In the Spreadsheet ID list, select or specify the sheet ID.
7. In the Sheet ID list, select or specify the sheet ID.
8. Click Show additional fields.
9. In the Start field, provide the specific cell, row, or column (A1, 1 or A) from which you want to retrieve data. This is a required field.
10. In the End field, provide the specific cell, row, or column (Z1, 1, or Z) up to which you want to retrieve data. This is a required field.
11. Click Done.
Output schema
