Endpoint

Insert Sheet Data (Append at the end)

Name

insert_sheet_data

Description

Append data to spreadsheet on desired tab. Data is appended after last non-empty row/cell location. You can supply cell offset to start scan to find non-empty cell. [API reference]

Related Tables

[Dynamic Table] , Sheets

Parameters

Parameter

Label

Required

Options

Description

Range

Start Range

YES

This is the range in which next row location is detected based on first empty cell and row (Examples: A1, A1:GR, A1:GR200). This range is also used to detect metadata. Values are appended after the last row of the table.

TabName

If you have multiple tabs on your spreadsheet then you can specify here. By default first tab is used if you do not enter.

valueRenderOption

Option	Value
FORMATTED_VALUE	FORMATTED_VALUE
UNFORMATTED_VALUE	UNFORMATTED_VALUE
FORMULA	FORMULA

valueInputOption

Option	Value
USER_ENTERED	USER_ENTERED
RAW	RAW

majorDimension

Option	Value
DIMENSION_UNSPECIFIED	DIMENSION_UNSPECIFIED
COLUMNS	COLUMNS
ROWS	ROWS

dateTimeRenderOption

Option	Value
SERIAL_NUMBER	SERIAL_NUMBER
FORMATTED_STRING	FORMATTED_STRING

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
spreadsheetId	`DT_WSTR`	`nvarchar(100)`	100	`False`
tableRange	`DT_WSTR`	`nvarchar(255)`	255	`False`
updatedRange	`DT_WSTR`	`nvarchar(255)`	255	`False`
updatedRows	`DT_I4`	`int`		`False`
updatedColumns	`DT_I4`	`int`		`False`
updatedCells	`DT_I4`	`int`		`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:

Insert into [Dynamic Table] table using API Destination

This Endpoint belongs to [Dynamic Table] table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Google Sheets

[Dynamic Table]

Insert

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Insert Sheet Data (Append at the end)

-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!

insert_sheet_data endpoint belongs to [Dynamic Table] , Sheets table(s), and can therefore be used via those table(s).

SQL Server

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

Insert Sheet Data (Append at the end)

DECLARE @MyQuery NVARCHAR(MAX) = '-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_SHEETS_IN_GATEWAY];

insert_sheet_data endpoint belongs to [Dynamic Table] , Sheets table(s), and can therefore be used via those table(s).