← All Tools
📝

Google Sheets Write API

Write or append rows to an existing Google Spreadsheet. Supports overwrite and append modes — ideal for AI agents storing research results, logs, or structured data.

API Docs $0.003 / request

About this tool

Write a 2D array of values to a Google Spreadsheet. Use mode=overwrite (default) to replace data starting at the given range, or mode=append to add rows below existing data without overwriting.

Quick Start

curl -X POST https://api.iteratools.com/sheets/write \ -H "Authorization: Bearer YOUR_KEY" \ -H "Content-Type: application/json" \ -d '{ "spreadsheet_id": "YOUR_SHEET_ID", "range": "Sheet1!A2", "values": [["Alice", "alice@example.com", 95], ["Bob", "bob@example.com", 87]], "mode": "append" }'

Response

{"ok": true, "data": {"updated_rows": 2}}

Parameters

  • spreadsheet_id (required) — The ID from your spreadsheet URL
  • values (required) — 2D array of values to write
  • range (optional) — Starting cell, e.g. Sheet1!A1
  • mode (optional) — overwrite (default) or append

Pricing

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

Full Documentation Browse All Tools