Skip to content
All APIs

Google Sheets Reader

Web & Search · 1 endpoint

Any Google Sheet shared "anyone with the link", turned into headers plus rows from Google's own CSV export — no account or key needed.

Base URL

https://api.diraz.ae
0 requests45s cache1 credit / request

Endpoint

GET/v1/google/sheets

Snippet

Request — cURL

v1

curl https://api.diraz.ae/v1/google/sheets \
  -H "Authorization: Bearer drz_live_…"

Query parameters

idstring · required
The spreadsheet ID from its URL — `docs.google.com/spreadsheets/d/<id>/…`.
gidinteger · optional
The sheet tab to read. `0` is the first tab.Default: 0
limitinteger · optional
Rows to return, 1 to 10000.Default: 1000
max_ageinteger (seconds) · optional
Ask for data no older than this. Clamped to the product's own floor, so it can narrow the window but never force a refresh on every call.Default: 300

Example response

200 OK

v1

{
  "data": {
    "spreadsheet_id": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
    "sheet_id": 0,
    "headers": ["Student Name", "Gender", "Class Level", "Home State", "Major", "Extracurricular Activity"],
    "rows": [
      ["Alexandra", "Female", "4. Senior", "CA", "English", "Drama Club"],
      ["Andrew", "Male", "1. Freshman", "SD", "Math", "Lacrosse"]
    ],
    "total_rows": 30
  },
  "meta": {
    "request_id": "req_7Q2fK4mZ",
    "as_of": "2026-08-20T04:05:00.000Z",
    "age_seconds": 3,
    "next_update_at": "2026-08-20T04:05:45.000Z"
  }
}
spreadsheet_id / sheet_id
Which spreadsheet and tab this data comes from.
headers
The first row, as Google exports it — the column names.
rows
The remaining rows. String cells throughout: a CSV export carries presentation text, not typed values.
total_rows
Rows in the sheet, before `limit` trims.

Errors

401 Unauthorized

v1

{
  "error": {
    "code": "UNAUTHORIZED",
    "message": "The API key is invalid, expired, or revoked."
  },
  "meta": {
    "request_id": "req_7Q2fK4mZ"
  }
}

Every failure carries a stable machine-readable code before the human message, and the same meta.request_id the successful responses carry. Quote it and we can find your exact request.

Errors are free

Nothing on this page is billed. You are charged for a 2xx and nothing else — a rejected key, a bad parameter, a rate limit, or an outage on our side all cost you zero. Retry without watching the meter.

UNAUTHORIZEDHTTP 401
Missing, malformed, expired, or revoked API key.
FORBIDDENHTTP 403
The key is valid but lacks the scope this product needs.
VALIDATION_ERRORHTTP 422
A query parameter is the wrong type or out of range.
RATE_LIMITEDHTTP 429
Rate limit exhausted. `Retry-After` says how long to wait.
SERVICE_UNAVAILABLEHTTP 503
No data recent enough to serve. Carries `Retry-After`, and is never billed.
Total requests0
Cache45s
Status
Operational
Category
Web & Search
Scope
market:read
Rate limit
60 requests / 60s per key
Pricing
1 credit / request
Request a keyView as Markdown
  • Google Sheets Reader

1/1 passing

Every response is timestamped. as_of is when the data was published, age_seconds how old that is now, and next_update_at when newer data is expected.

Three shapes to handle:

  • Up to date200

    The data is inside its published window. The overwhelming majority of requests.

  • Delayeddelayed: true

    Newer data is late. You still get the most recent there is, flagged so you can decide whether to use it.

  • Unavailable503

    Nothing recent enough to serve. Carries Retry-After, and is never billed.