Knowledge Base
Admin
Google Sheets

Google Sheets

Google Sheets API for reading and writing spreadsheet data

Active Verified

Capabilities (7)

Write Spreadsheet Range

Write data to a specific range in a spreadsheet.

write_range(spreadsheet_id, range, values) -> {updatedRange: string}
Required scopes:
https://www.googleapis.com/auth/spreadsheets

Append Rows

Append rows to the end of a spreadsheet table.

append_rows(spreadsheet_id, range, values) -> {updates: object}
Required scopes:
https://www.googleapis.com/auth/spreadsheets

Clear Range

Clear all values from a specific range in a spreadsheet.

clear_range(spreadsheet_id, range) -> {clearedRange: string}
Destructive
Required scopes:
https://www.googleapis.com/auth/spreadsheets

Get Spreadsheet Info

Get metadata about a spreadsheet including sheet names, properties, and named ranges.

get_spreadsheet(spreadsheet_id) -> Spreadsheet
Required scopes:
https://www.googleapis.com/auth/spreadsheets.readonly

Read Spreadsheet Range

Read data from a specific range in a spreadsheet. Returns values as a 2D array.

read_range(spreadsheet_id, range) -> {values: any[][]}
Required scopes:
https://www.googleapis.com/auth/spreadsheets.readonly

Create Spreadsheet

Create a new Google Sheets spreadsheet.

create_spreadsheet(title, sheets?) -> Spreadsheet
Required scopes:
https://www.googleapis.com/auth/spreadsheets

Batch Update Sheet Values

Write to multiple ranges in a Google Sheet in a single atomic call. Cheaper than N separate `write_range` calls and rolls back if any range fails. Each entry in `value_ranges` is a `{range, values}` pair — same shape as write_range takes.

batch_update_values(spreadsheet_id, value_ranges, value_input_option?) -> {responses}
Required scopes:
https://www.googleapis.com/auth/spreadsheets

Links

Authentication

  • Oauth2_authorization_code (Primary)