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
If the column you are looking for is missing, consider customizing Google Sheets Connector.

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

ODBC application

Use these SQL queries in your ODBC application data source:

Delete spreadsheet tab

SELECT * FROM delete_sheet_tab
WITH
(
    "TabId" = '0'
)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Delete spreadsheet tab

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_sheet_tab
WITH
(
    "TabId" = ''0''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_SHEETS_IN_GATEWAY];