Endpoint

Create SpreadSheet Tab

Name

create_sheet_tab

Description

Creates new tab for specified spreadsheet. [API reference]

Parameters

Parameter

Label

Required

Options

Description

NewTabName

YES

Name for new Tab you like to add

InitialRowCount

YES

Initial row count for new sheet

InitialColumnCount

YES

Initial column count for new sheet

TabColorRedValue

YES

Tab Color - Red Value for RGB

TabColorGreenValue

YES

Tab Color - Green Value for RGB

TabColorBlueValue

YES

Tab Color - Blue Value for RGB

SpreadSheetId

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:

Create SpreadSheet Tab using API Source

Google Sheets

Create SpreadSheet Tab

SSIS API Source - Read from table or endpoint

Create SpreadSheet Tab using API Destination

Google Sheets

Create SpreadSheet Tab

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];