# API Endpoints

Complete reference of available HTTP methods to interact with your spreadsheet. Replace `[sheetId]` with your project ID.

## GET List Records

`/api/sheets/[sheetId]`

Returns all records from the spreadsheet in JSON array format.

#### Parameters (Query):

- `limit` (optional): Limits the number of results.
- `offset` (optional): Pagination.

## GET Get Record

`/api/sheets/[sheetId]?id=123`

Returns a single record where the `id` column matches the value.

## POST Create Record

`/api/sheets/[sheetId]`

Adds a new row to the spreadsheet. The request body must be a JSON object with keys corresponding to the columns.

```
{
  "name": "New Customer",
  "email": "customer@example.com"
}
```

## PUT Update Record

`/api/sheets/[sheetId]?id=123`

Updates an existing row based on the ID.

## DELETE Delete Record

`/api/sheets/[sheetId]?id=123`

Removes the corresponding row from the spreadsheet.

#### Methods