Google Sheets Connector
Documentation
Version: 6
Documentation
Home » API Integration Hub » Google Sheets Connector » Tables

Tables for Google Sheets Connector

On this page you will see possible API actions you can perform with Google Sheets connector. We will refer this as API Table or just Table.

Name Description Supported Operations
[Dynamic Table] No description available 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
__DynamicRequest__ This is a generic table. Use this to support Bulk read / write. You can supply Dynamic URL Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT generic_request
INSERT generic_request_bulk_write
UPDATE generic_request_bulk_write
UPSERT
DELETE
LOOKUP
SheetDetails Read sheet information (i.e. tabs on a sheet) for a specified SpreadSheetId Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT get_sheet_properties
INSERT
UPDATE
UPSERT
DELETE
LOOKUP get_sheet_properties
Sheets Read, insert, update sheet data for a specified SpreadSheetId and Tab 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