# Spreadsheet References – Range Lookup

> Spreadsheet References – Range Lookup is a paid API for AI agents from spreadsheet.openverbs.com, paid per call via x402, $0.004/call, status unknown (last checked 2026-09-14).

Retrieves cell references or data for a specified A1-notation range from a spreadsheet via POST request.

## Facts

- Endpoint: POST https://spreadsheet.openverbs.com/v1/range
- Price: $0.004/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-14
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/spreadsheet-references-range-lookup-3a00bd76
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_mmCdCS26bD-n7KS5hodHq

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 spreadsheet-references-range-lookup-3a00bd76 -d '<json body>'
```

Example prompt: Can you fetch the spreadsheet data for the range A1:C10 from OpenVerbs Spreadsheet References?

## When to prefer this

Use this endpoint when you need to look up or retrieve data from a specific cell range in a spreadsheet using standard A1 notation. It is ideal for agents that need to read tabular spreadsheet data programmatically without a full spreadsheet API integration. Prefer this over manual data entry or generic file-parsing when the data lives in a structured spreadsheet and the range is known.

## Known failure modes

- Invalid or malformed A1 range string (e.g. missing colon, wrong format) results in a validation error
- Range string exceeds 64-character maximum length
- Range string is empty or too short (less than 1 character)
- Payment not included or insufficient — x402 payment required at $0.004 USDC per call
- Spreadsheet resource not found or inaccessible

## How this service works

Parse an A1 range like "A1:C10" into its start and end cells (normalized so start is the top-left) and its extent — row count, column count and total cell count.

## Output

Returns the cell references and/or values for the specified A1-notation range from the spreadsheet, enabling downstream processing or display of the retrieved data.

## Request schema (JSON Schema)

```json
{
 "$schema": "https://json-schema.org/draft/2020-12/schema",
 "type": "object",
 "properties": {
  "input": {
   "type": "object",
   "properties": {
    "type": {
     "type": "string",
     "const": "http"
    },
    "method": {
     "type": "string",
     "enum": [
      "POST"
     ]
    },
    "bodyType": {
     "type": "string",
     "enum": [
      "json",
      "form-data",
      "text"
     ]
    },
    "body": {
     "type": "object",
     "properties": {
      "range": {
       "type": "string",
       "minLength": 1,
       "maxLength": 64,
       "description": "A1 range, e.g. \"A1:C10\"."
      }
     },
     "required": [
      "range"
     ],
     "additionalProperties": false
    }
   },
   "required": [
    "type",
    "method",
    "bodyType",
    "body"
   ],
   "additionalProperties": false
  }
 },
 "required": [
  "input"
 ]
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/spreadsheet-references-range-lookup-3a00bd76/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from spreadsheet.openverbs.com](https://www.zero.xyz/host/spreadsheet.openverbs.com/llms.txt)