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.