# Google Sheets Structured Data Extractor

> Google Sheets Structured Data Extractor is a paid API for AI agents from api.scrapeforagents.tech, paid per call via x402, $0.025/call, status unknown (last checked 2026-10-02).

Extracts structured row data from public Google Sheets URLs into JSON, with support for tab selection, cell range filtering, and header row configuration.

## Facts

- Endpoint: POST https://api.scrapeforagents.tech/v1/google?utm_source=zero.xyz
- Price: $0.025/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-02
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/google-sheets-structured-data-extractor-23465355
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_LQqWZde6_kbP3oZDL2id6

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability google-sheets-structured-data-extractor-23465355 -d '<json body>'
```

Example prompt: Pull all the rows from this public Google Sheet https://docs.google.com/spreadsheets/d/1aBcD.../edit#gid=0, starting from header row 1, and give me up to 500 rows as structured JSON.

## When to prefer this

Use this endpoint when you need to extract structured tabular data from a publicly accessible Google Sheet via a pay-per-call model with no charge for failed or empty runs. It supports tab-level selection via GID, arbitrary A1 cell ranges, and configurable header rows, making it suitable for well-structured spreadsheets. Avoid if the sheet is private, if you need write access, or if you require real-time Google Sheets API authentication. Note: the domain is flagged as parked on Hostinger DNS, so verify reliability before relying on this in production.

## Known failure modes

- Sheet is private or access-restricted — returns empty or error response
- Invalid or malformed Google Sheets URL — request fails with an error
- GID not found on the spreadsheet — returns empty items
- Cell range outside used range — returns empty items
- Sheet has no data in the specified range — returns count 0
- Hostinger-parked domain may be unreliable or return 402 payment required errors
- Service domain signals suggest parked/stub infrastructure — reliability uncertain

## How this service works

Pay-per-call structured web data. Failed or empty runs are not charged.

## Output

Returns a JSON object with a count of matched rows and an items array. Each item includes the raw row data as key-value pairs, the row number, the sheet GID, the sheet URL, and the spreadsheet ID. The product field is always 'google'.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "maxItems": {
   "type": "integer",
   "default": 1000,
   "minimum": 0,
   "description": "Maximum data rows across all URLs. Set to 0 for no cap."
  },
  "cellRange": {
   "type": "string",
   "default": "",
   "description": "Optional A1 range such as A1:F100. Leave empty to export the worksheet's used rows and columns."
  },
  "headerRow": {
   "type": "integer",
   "default": 1,
   "minimum": 1,
   "description": "One-based row within the selected range containing column names. Rows before it are skipped."
  },
  "sheetUrls": {
   "type": "array",
   "description": "Public Google Sheets URLs. Add #gid=... to select a worksheet tab; each URL exports one tab."
  },
  "includeEmptyRows": {
   "type": "boolean",
   "default": false,
   "description": "Include fully blank rows when they appear in the exported range."
  }
 }
}
```

## Response schema (JSON Schema)

```json
{
 "type": "json",
 "example": {
  "count": 1,
  "items": [
   {
    "data": null,
    "sheetGid": null,
    "sheetUrl": null,
    "rowNumber": null,
    "spreadsheetId": null
   }
  ],
  "product": "google"
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/google-sheets-structured-data-extractor-23465355/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from api.scrapeforagents.tech](https://www.zero.xyz/host/api.scrapeforagents.tech/llms.txt)