Google Sheets

Read and update Google Sheets spreadsheets

10 Capabilities

Append Values

Append rows to a spreadsheet after the last row with data in the given range.

Batch Update

Apply arbitrary Google Sheets API spreadsheets.batchUpdate requests for structural and formatting updates such as adding sheets, resizing dimensions, formatting cells, freezing rows, merging cells, charts, filters, and protected ranges.

Batch Update Values

Update multiple ranges of values in a spreadsheet in a single request.

Clear Values

Clear all values from a range in a spreadsheet (formatting is preserved).

Create

Create a new spreadsheet.

Delete

Delete a Google spreadsheet from Drive.

Get

Get spreadsheet metadata and sheet structure.

Get Values

Get cell values from a range in a spreadsheet.

List

List spreadsheets in Google Drive.

Update Values

Update cell values in a range in a spreadsheet.