Capability Sources

Read a bounded rectangle of Google Sheets cells

Changed on

Uses the calling member's selected Google account. Perform mutations only when explicitly requested; selecting or discovering a connector does not authorize a write. Do not automatically retry an uncertain mutation.

get/v1/capabilities/google-workspace/spreadsheets/{spreadsheetId}/values

Request

  • Base URL
    https://api.openworklabs.com
  • URL
    https://api.openworklabs.com/v1/capabilities/google-workspace/spreadsheets/{spreadsheetId}/values
  • Auth
    • API key in header x-api-key
    • or HTTP bearer

Path parameters

spreadsheetIdstring required

Query parameters

rangestring required
valueRenderOption'FORMATTED_VALUE' | 'UNFORMATTED_VALUE' | 'FORMULA'

Response

Google-confirmed result.

oktrue required
spreadsheetIdstring required
rangestring required
majorDimension'ROWS' required
valueRenderOption'FORMATTED_VALUE' | 'UNFORMATTED_VALUE' | 'FORMULA'

Changes

  • c93387179b31Revision changes
    • info

      response property details/items/path/items/ list-of-types was narrowed by removing types number from media type application/json of response 400

  • df3754993784Revision changes
    • info

      added the optional property to the response with the status