Read spreadsheet data

Read data from a Google Sheets spreadsheet using A1 notation.

get/api/v1/sheets/{spreadsheet_id}

Request

  • Base URL: https://localhost:3000
  • URL: https://localhost:3000/api/v1/sheets/{spreadsheet_id}
  • Auth: OAuth 2 (authorization code, authorization URL /oauth/authorize, token URL /oauth/token)

Path parameters

spreadsheet_idstring required

The Google Sheets spreadsheet ID

Query parameters

rangestring required

A1 notation range (e.g., 'Sheet1!A1:D10', 'A1:Z100')

Response

Spreadsheet data

userstring
spreadsheet_idstring
rangestring
rowsinteger

Number of rows returned

Changes

No recorded changes to this operation across all 1 revision of this API.