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 |

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 |

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