Go to app
Academy
What's new?
Tray UAC
Developer
Connectors
Templates
Help Center
Back
Google Sheets
Overview
Notes on using Google Sheets
Use Cases
Operations (sample payloads)
Operations
Google Sheets Operations
Latest version:
8.1
Changelog
Add values to spreadsheet
Appends values to a spreadsheet.
Create column headers for sheet
Add column headers to your worksheet.
Create empty column or row
Add a column or row to the end of a Google Sheet.
Create row
Add a row to a Google Sheet.
Create spreadsheet
Create a new spreadsheet for your Google Sheets.
Create worksheet
Add a worksheet to a spreadsheet.
Delete column
Remove a column from a worksheet.
Delete row
Remove row from a worksheet.
Delete worksheet
Delete a worksheet from a spreadsheet.
Get row by index
Find a row by its index.
Get rows
Get data from a worksheet of a spreadsheet.
Get spreadsheet details
Get details about a spreadsheet, including information about its worksheets.
Get total active rows
Returns total active rows in a sheet.
Get worksheet data
Get data from a worksheet of a spreadsheet.
Get worksheet data using range
Get data from a worksheet of a spreadsheet using a cell range.
Insert empty column
Insert a column into a Google Sheet.
Insert empty row
Insert a row into a Google Sheet.
List worksheet column headers
List columns of a worksheet.
List worksheet column headers DDL
List worksheet column headers using ID DDL
List worksheets
List worksheets within a spreadsheet.
Raw HTTP request (advanced)
Perform a raw HTTP request with some pre-configuration and processing by the connector, such as authentication.
Update cell value
Set the value of an individual cell in a Google Sheet.
Update row
Update a row, by its number, within a worksheet.
Update values in spreadsheet
Update the values of a spreadsheet in a given range.
Previous
Operations (sample payloads)