Google Sheets Connector
Documentation
Version: 9
Documentation

Table Sheets


Description

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

Parameters

Parameter Label Required Options Description Help
There are no parameters

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

Google Sheets
Sheets
SSIS API Source - Read from table or endpoint

Read/write to Sheets table using API Destination

Google Sheets
Sheets
Select
SSIS API Destination - Access table operation