Read a bounded Google Sheets A1 or named range with selectable value and date rendering

Read a bounded Google Sheets A1 or named range with selectable value and date rendering. A range without a sheet name uses the first visible sheet.

Authorization

bearerApiKey

AuthorizationBearer <token>

Create a scoped API key in the Adlass settings.

In: header

Path Parameters

connection_id*string

Resource identifier: connection_id.

Formatuuid

Header Parameters

X-Request-Id?string

Optional correlation identifier.

Lengthlength <= 128

Request Body

application/json

TypeScript Definitions

Use the request body type in TypeScript.

spreadsheet_id*Spreadsheet Id

Match^[A-Za-z0-9_\-]{10,128}$

range*Range

Match

^(?:(?:'(?:[^\x00-\x1f\x7f\[\]*?/\\:']|''){1,200}'|[^\s\x00-\x1f\x7f\[\]*?/\\:!']{1,100})(?:!(?:[A-Za-z]{1,3}[0-9]{0,7}|[0-9]{1,7})(?::(?:[A-Za-z]{1,3}[0-9]{0,7}|[0-9]{1,7}))?)?|(?:[A-Za-z]{1,3}[0-9]{0,7}|[0-9]{1,7})(?::(?:[A-Za-z]{1,3}[0-9]{0,7}|[0-9]{1,7}))?)$

Length1 <= length <= 200

value_render_option?Value Render Option

Default"FORMATTED_VALUE"

Value in

"FORMATTED_VALUE"
"UNFORMATTED_VALUE"
"FORMULA"

date_time_render_option?Date Time Render Option

Default"FORMATTED_STRING"

Value in

"FORMATTED_STRING"
"SERIAL_NUMBER"

max_rows?Max Rows

Range1 <= value <= 1000

Default200

space_id?|

Formatuuid

grant_id?|

Formatuuid

Response Body

`application/json`

`application/problem+json`

curl -X POST "https://example.com/integrations/connections/123e4567-e89b-42d3-a456-426614174000/providers/gsheets/values/read" \  -H "Content-Type: application/json" \  -d '{    "spreadsheet_id": "123e4567-e89b-42d3-a456-426614174000",    "range": "example"  }'

{  "range": "example",  "rows": [],  "row_count": 0,  "truncated": false}

Read a bounded Google Sheets A1 or named range with selectable value and date rendering

Authorization

Path Parameters

Header Parameters

Request Body

Response Body

200application/json

400application/problem+json

401application/problem+json

402application/problem+json

403application/problem+json

404application/problem+json

405application/problem+json

409application/problem+json

410application/problem+json

413application/problem+json

415application/problem+json

422application/problem+json

429application/problem+json

500application/problem+json

502application/problem+json

503application/problem+json

504application/problem+json

`application/json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`

`application/problem+json`