{"uid":"cap_mmCdCS26bD-n7KS5hodHq","slug":"spreadsheet-references-range-lookup-3a00bd76","name":"Spreadsheet References – Range Lookup","description":"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.","url":"https://spreadsheet.openverbs.com/v1/range","method":"POST","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType","body"],"properties":{"body":{"type":"object","required":["range"],"properties":{"range":{"type":"string","maxLength":64,"minLength":1,"description":"A1 range, e.g. \"A1:C10\"."}},"additionalProperties":false},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.004","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.004/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.004","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.004","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_IC2Tu5SqCq6yLntxrNjLG","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.004","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Retrieves cell references or data for a specified A1-notation range from a spreadsheet via POST request.","exampleAgentPrompt":"Can you fetch the spreadsheet data for the range A1:C10 from OpenVerbs Spreadsheet References?","exampleUseCases":[{"title":"Pull quarterly sales data cells","prompt":"Get me the values in cells B2:B13 from the spreadsheet — that's where the monthly sales figures are stored."},{"title":"Extract header row for schema mapping","prompt":"Fetch the header row A1:Z1 from the spreadsheet so I can see what columns are available before I process the rest of the data."},{"title":"Read a specific data block for reporting","prompt":"I need to pull the data in range D5:F20 from the spreadsheet to build a summary report — can you grab those cells?"}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T18:30:24.540Z","isFirstParty":false}