| 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. |
