Google Sheets

Google Sheets API for reading and writing spreadsheet data

Active Verified

Capabilities (6)

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 to the end of a spreadsheet table.


                      append_rows(spreadsheet_id, range, values) -> {updates: object}

Required scopes:

https://www.googleapis.com/auth/spreadsheets

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 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 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 a new Google Sheets spreadsheet.


                      create_spreadsheet(title, sheets?) -> Spreadsheet

Required scopes:

https://www.googleapis.com/auth/spreadsheets