GetGoogleSheetData

Use this activity to retrieve data from your Google Sheets. You can specify a cell range from which to retrieve data.

Configuration

The Configuration tab has the following fields that identify which Google connection to use.

Field Description
Connection Google connection name. If you have created multiple Google connections, select the one you want to use in this flow.
Row or Column Specify whether you want the data retrieved (output of the activity) to be oriented by rows or columns.

Input

The Input tab has the following fields.

Field Description
spreadsheetId This is a mandatory field. The ID that is a part of the URL for the spreadsheet. For example, if the URL for the spreadsheet is https://docs.google.com/spreadsheets/d/1fIJ7c57nPwpor9NDarbDdBiCCDQ6lxP_jVG2u79lCKns/edit#gid=0, the spreadsheetID is 1fIJ7c57nPwpor9NDarbDdBiCCDQ6lxP_jVG2u79lCKns
sheetId This is a mandatory field. The name of the tab which appears at the bottom of the sheet.
cellRange The range of the area to be retrieved starting from the first cell to be retrieved to the last cell to be retrieved. For example, D4:H17. If you do not specify anything it will get the whole sheet.

Output

The Output tab displays the fields that correspond with the output of the activity. The data appearing in this tab is for informational purpose only and cannot be modified.