Google Sheets Connector
Google Sheets Connector Help
Version 4
ZappySys Logo File Version: v4
Supported Engine: 9

EndPoints 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 EndPoint or just EndPoint.

Label Name Description
Read Sheet Data read_sheet_data Read google spreadsheet data from desired tab / cell location (i.e. start/end range) [API Help..]
Clear Sheet Values clear_sheet_range Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept. [API Help..]
Delete Sheet Rows / Columns delete_sheet_rows_columns Deletes rows / columns based on startIndex / endIndex range (Index is zero based). For example to delete First 5 rows specify startIndex=0 and endIndex=4 [API Help..]
Delete SpreadSheet Tab delete_sheet_tab Deletes specified tab from spreadsheet [API Help..]
Create SpreadSheet Tab create_sheet_tab Creates new tab for specified spreadsheet. [API Help..]
Execute Command(s) batch_update_request Perform various operations available in online editor such as copy, paste, format, merge. Add multiple JSON command by adding comma after first command (e.g. requests : [ {..cmd1..} , {..cmd2..}, {..cmd3..} ] ) Refer to example requests on help link. [API Help..]
Update Sheet Data (Overwrite Cells) update_sheet_data Update data to spreadsheet on desired tab / cell location (i.e. start/end range) [API Help..]
Insert Sheet Data (Append at the end) insert_sheet_data 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 Help..]
Get Sheet Properties / Tab information get_sheet_properties Read read sheet properties (e.g. list of tabs on sheet and its properties) [API Help..]
Generic Request generic_request This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.