GET: Read your sheet data

Use a GET request to read data from your Google Sheet.

The basics

curl \

This will get all rows in TAB


Get all rows from "Employees":

curl \

Read first two rows from the "Employees" tab:

curl \

Read the third row from sheet "Employees":

curl \

Get all "Employees" who are male and still employed:

curl \


All options are passed as query parameters

limitNumber of how many rows should be returned
offset0Number from which row response should start


200: Success

An array of objects. Each object is a row from the Google Spreadsheet. For example:

"values": [
{ "id": "1", "name": "Erlich Bachman", "gender": "male" },
{ "id": "2", "name": "Richard Hendricks", "gender": "male" },
{ "id": "3", "name": "Dinesh Chugtai", "gender": "male" },
{ "id": "4", "name": "Bertram Gilfoyle", "gender": "male" },
{ "id": "5", "name": "Jared Dunn", "gender": "male" },
{ "id": "6", "name": "Jian Yang", "gender": "not hotdog" }

The values data will ALWAYS be an array, even if you request with limit=1.

We do not return the cell range in the sheet, as this data may be incorrect if another client subsequently updates the sheet (for example, deleting a row).

401: Unauthorized

The metal key was invalid.

404: Not found

The tab you were looking for was not found.