Google Sheets Connector
Google Sheets Connector Help
Version 4
ZappySys Logo File Version: v4
Supported Engine: 9

EndPoint Delete Sheet Rows / Columns


Name

delete_sheet_rows_columns

Description

Deletes rows / columns based on startIndex / endIndex range (Index is zero based). For example to delete First 5 rows specify startIndex=0 and endIndex=4 [API Help]

Parameters

Parameter Label Required Options Description
Dimension Range Type YES
Option Value
ROWS ROWS
COLUMNS COLUMNS
Specifies what would you like to delete (i.e. Rows or Columns)
StartIndex Range Start Index (starts from 0) YES Range Start Index (Zero based) for operation. For Column Operation translate Alpha value to zero based index. Example: Column D = Index 3. Column AA=26
EndIndex Range End Index (starts from 0) YES Range End Index (Zero based) for operation. For Column Operation translate Alpha value to zero based index. Example: Column D = Index 3. Column AA=26
TabId TabId YES Numeric ID of SpreadSheet Tab for which you like to delete rows/columns. For first tab its 0. You can find this ID from Sheet URL in browser. Get Number after edit#gid= (thats your Tab ID)
SpreadSheetId SpreadSheetId YES
Option Value
Enter Your Sheet Id
Example Sheet Id 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms
Enter unique spreadsheet Id. To obtain sheet Id. Open spreadsheet in browser and check URL. You will example value like 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms that is your sheet id.

Output Columns

Label DataType Length Raw Description
spreadsheetId DT_WSTR 100 False

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.