Reference

Table Sheets


Description

Read, insert, update sheet data for a specified SpreadSheetId and Tab

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT read_sheet_data
INSERT insert_sheet_data
UPDATE update_sheet_data
UPSERT
DELETE
LOOKUP read_sheet_data

Examples

SSIS

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

Read from Sheets table using 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
Sheets
Required Parameters
Range Fill-in the parameter...
Optional Parameters
IncludeParentColumns False
ArrayTransformType TransformColumnslessArray
First Row Has Column Names True
ArrayTransCustomColumns Col1,Col2,Col3
SSIS API Source - Read from table or endpoint

Read/write to Sheets table using 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
Sheets
Select
Required Parameters
Range Fill-in the parameter...
Optional Parameters
IncludeParentColumns False
ArrayTransformType TransformColumnslessArray
First Row Has Column Names True
ArrayTransCustomColumns Col1,Col2,Col3
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get Sheets

SELECT * FROM Sheets

SQL Server

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

Get Sheets

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Sheets';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_SHEETS_IN_GATEWAY];