# ClearGoogleSheetData

Use this activity to erase data from a whole Google Sheet or a part of the sheet.

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

## 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 | Leave blank to clear the whole sheet/. Example "B13:G16" to clear a range. to clear one cell just give the cell location example "B13" if you do not provide a cell range it will clear every thing on the sheet.

## Output

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