# 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.

Copyright © TIBCO Software Inc. All rights reserved.