Sign InGet Started
Sign InGet Started

Google Sheets Integration

Google Sheets API Operations

Browse all 17 operations available for Google Sheets workflow automation.

Back to Google Sheets

DeveloperMetadata

2 operations
GET/v4/spreadsheets/{spreadsheetId}/developerMetadata/{metadataId}

Get developer metadata by ID

Retrieve a developer metadata entry by ID

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
2 path params
POST/v4/spreadsheets/{spreadsheetId}/developerMetadata:search

Search developer metadata by filter

Search for developer metadata entries by filter

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
1 path params

Sheets

1 operation
POST/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo

Copy a sheet to another spreadsheet

Copy a sheet tab to another spreadsheet

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
2 path params

Spreadsheets

4 operations
POST/v4/spreadsheets/{spreadsheetId}:batchUpdate

Apply batch updates to a spreadsheet

Apply structural changes like adding sheets or formatting

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
1 path params
POST/v4/spreadsheets

Create a new spreadsheet

Create a new Google Sheets spreadsheet

https://www.googleapis.com/auth/spreadsheetshttps://www.googleapis.com/auth/drive.file
GET/v4/spreadsheets/{spreadsheetId}

Get a spreadsheet by ID

Get spreadsheet metadata and structure

https://www.googleapis.com/auth/spreadsheets.readonly
1 path, 3 query params
POST/v4/spreadsheets/{spreadsheetId}:getByDataFilter

Get spreadsheet data matching filters

Get spreadsheet data matching specific filters

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
1 path params

Values

10 operations
POST/v4/spreadsheets/{spreadsheetId}/values/{range}:append

Append rows to a sheet

Append new rows to a sheet

https://www.googleapis.com/auth/spreadsheets
2 path, 5 query params
POST/v4/spreadsheets/{spreadsheetId}/values/{range}:clear

Clear values from a range

Clear cell values from a range while keeping formatting

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
2 path params
POST/v4/spreadsheets/{spreadsheetId}/values:batchClear

Clear values from multiple ranges

Clear values from multiple ranges at once

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
1 path params
POST/v4/spreadsheets/{spreadsheetId}/values:batchClearByDataFilter

Clear values from ranges matching data filters

Clear values from ranges matching data filters

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
1 path params
GET/v4/spreadsheets/{spreadsheetId}/values/{range}

Read values from a range

Read cell values from a spreadsheet range

https://www.googleapis.com/auth/spreadsheets.readonly
2 path, 3 query params
GET/v4/spreadsheets/{spreadsheetId}/values:batchGet

Read values from multiple ranges

Read values from multiple ranges in one request

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/drive.readonlyhttps://www.googleapis.com/auth/spreadsheetshttps://www.googleapis.com/auth/spreadsheets.readonly
1 path, 4 query params
POST/v4/spreadsheets/{spreadsheetId}/values:batchGetByDataFilter

Read values matching data filters

Read values from ranges matching data filters

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
1 path params
PUT/v4/spreadsheets/{spreadsheetId}/values/{range}

Write values to a range

Write values to a spreadsheet range

https://www.googleapis.com/auth/spreadsheets
2 path, 4 query params
POST/v4/spreadsheets/{spreadsheetId}/values:batchUpdate

Write values to multiple ranges

Write values to multiple ranges in one request

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
1 path params
POST/v4/spreadsheets/{spreadsheetId}/values:batchUpdateByDataFilter

Write values to ranges matching data filters

Write values to ranges matching data filters

https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
1 path params