{"uid":"cap_LQqWZde6_kbP3oZDL2id6","slug":"google-sheets-structured-data-extractor-23465355","name":"Google Sheets Structured Data Extractor","description":"Pay-per-call structured web data. Failed or empty runs are not charged.","url":"https://api.scrapeforagents.tech/v1/google?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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."}}},"responseSchema":{"type":"json","example":{"count":1,"items":[{"data":null,"sheetGid":null,"sheetUrl":null,"rowNumber":null,"spreadsheetId":null}],"product":"google"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.025","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.025/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.025","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.025","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_kwO16GpwbVNbmZLKPLdJ-","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.025","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Extracts structured row data from public Google Sheets URLs into JSON, with support for tab selection, cell range filtering, and header row configuration.","exampleAgentPrompt":"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.","exampleUseCases":[{"title":"Export campaign tracker from Sheets","prompt":"Grab all the data from our public Google Sheet at https://docs.google.com/spreadsheets/d/1xYZ.../edit, using row 1 as the header, and return up to 1000 rows so I can analyze our campaign performance."},{"title":"Read specific cell range from a tab","prompt":"From this Google Sheet https://docs.google.com/spreadsheets/d/1aBc.../edit#gid=123456, extract only the range B2:G50 — the first row of that range is the header — and return me the structured data."},{"title":"Pull inventory list from public spreadsheet","prompt":"Can you fetch the inventory data from this Google Sheets link https://docs.google.com/spreadsheets/d/1qRs.../edit, skip empty rows, use header row 2, and cap the results at 200 rows?"}],"resultDescription":"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'.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-02T00:47:34.307Z","isFirstParty":false,"canonicalSlug":"google-sheets-structured-data-extractor-23465355"}