📊

Google Sheets Read API

Read data from any Google Spreadsheet. Returns headers and rows as structured JSON objects — perfect for AI agents accessing spreadsheet data.

API Docs $0.002 / request

About this tool

Read rows from any Google Spreadsheet your service account has access to. Returns the first row as headers and remaining rows as key-value objects. Supports optional range parameter (e.g. Sheet1!A1:Z100).

Quick Start

curl "https://api.iteratools.com/sheets/read?spreadsheet_id=YOUR_SHEET_ID" \
  -H "Authorization: Bearer YOUR_KEY"

Response

{"ok": true, "data": {"headers": ["Name", "Email", "Score"], "rows": [{"Name": "Alice", "Email": "alice@example.com", "Score": "95"}], "total": 1, "range": "Sheet1!A1:C2"}}

Parameters

spreadsheet_id (required) — The ID from your spreadsheet URL
range (optional) — Sheet range, e.g. Sheet1 or Sheet1!A1:Z100

Pricing

$0.002 per request via x402 micropayment on Base (USDC).

Full Documentation Browse All Tools