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

EndPoint Execute Command(s)




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. [Read more]

Parameter Label Required Options Description
Body Request Body YES
TabId TabId YES Numeric ID of SpreadSheet Tab for which you like to delete rows/columns. For first tab its 0. You can find this ID from Sheet URL in browser. Get Number after edit#gid= (thats your Tab ID)
SpreadSheetId SpreadSheetId YES
Option Value
Enter Your Sheet Id
Example Sheet Id 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms
Enter unique spreadsheet Id. To obtain sheet Id. Open spreadsheet in browser and check URL. You will example value like 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms that is your sheet id.
Output Columns
Name DataType Length Raw Description
spreadsheetId DT_WSTR 100 False
Input Columns
Name DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.