Reference

Endpoint Create SpreadSheet Tab

Name

create_sheet_tab

Description

Creates new tab for specified spreadsheet. [API reference]

Parameters

Parameter Required Options
Name: NewTabName

Label: NewTabName

Name for new Tab you like to add 		YES
Name: InitialRowCount

Label: InitialRowCount

Initial row count for new sheet 		YES
Name: InitialColumnCount

Label: InitialColumnCount

Initial column count for new sheet 		YES
Name: TabColorRedValue

Label: TabColorRedValue

Tab Color - Red Value for RGB 		YES
Name: TabColorGreenValue

Label: TabColorGreenValue

Tab Color - Green Value for RGB 		YES
Name: TabColorBlueValue

Label: TabColorBlueValue

Tab Color - Blue Value for RGB 		YES
Name: SpreadSheetId

Label: SpreadSheetId

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.
Option Value
Enter Your Sheet Id
Example Sheet Id 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
spreadsheetId DT_WSTR nvarchar(100) 100
If the column you are looking for is missing, consider customizing Google Sheets Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length 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 or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Google Sheets
Read / write Google Sheets data inside your app, perform many Google Sheets operations without coding using easy to use high performance API Connector for Google Sheets
Google Sheets
Create SpreadSheet Tab
Required Parameters
NewTabName Fill-in the parameter...
InitialRowCount Fill-in the parameter...
InitialColumnCount Fill-in the parameter...
TabColorRedValue Fill-in the parameter...
TabColorGreenValue Fill-in the parameter...
TabColorBlueValue Fill-in the parameter...
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Google Sheets
Read / write Google Sheets data inside your app, perform many Google Sheets operations without coding using easy to use high performance API Connector for Google Sheets
Google Sheets
Create SpreadSheet Tab
Required Parameters
NewTabName Fill-in the parameter...
InitialRowCount Fill-in the parameter...
InitialColumnCount Fill-in the parameter...
TabColorRedValue Fill-in the parameter...
TabColorGreenValue Fill-in the parameter...
TabColorBlueValue Fill-in the parameter...
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Create spreadsheet tab 

SELECT * FROM create_sheet_tab
WITH
(
    "NewTabName" = 'My New Tab',
    "InitialRowCount" = '100',
    "InitialColumnCount" = '27',
    "TabColorRedValue" = '0.0',
    "TabColorGreenValue" = '0.0',
    "TabColorBlueValue" = '0.0'
)

SQL Server

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

Create spreadsheet tab 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM create_sheet_tab
WITH
(
    "NewTabName" = ''My New Tab'',
    "InitialRowCount" = ''100'',
    "InitialColumnCount" = ''27'',
    "TabColorRedValue" = ''0.0'',
    "TabColorGreenValue" = ''0.0'',
    "TabColorBlueValue" = ''0.0''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_SHEETS_IN_GATEWAY];