Google Sheets Connector
Documentation
Version: 9
Documentation

EndPoint Delete SpreadSheet Tab


Name

delete_sheet_tab

Description

Deletes specified tab from spreadsheet [API reference]

Parameters

Parameter Label Required Options Description
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 NO
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 Data Type (SSIS) Data Type (SQL) Length Raw Description
spreadsheetId DT_WSTR nvarchar(100) 100 False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Google Sheets Connector in API Source component to read data or in API Destination component to read/write data:

Delete SpreadSheet Tab using API Source

Google Sheets
Delete SpreadSheet Tab
SSIS API Source - Read from table or endpoint

Delete SpreadSheet Tab using API Destination

Google Sheets
Delete SpreadSheet Tab
SSIS API Destination - Access table or endpoint