---
name: Google Sheets
version: 1.0.0
description: "Google Sheets API access for AI agents. Read and write spreadsheet data, create sheets, and manage formatting with OAuth token passthrough."
homepage: https://sheets.googleapis.com/v4
metadata: {"seren":{"category":"integration","publisher_slug":"google-sheets","api_base":"https://api.serendb.com"}}
---

# Google Sheets

Google Sheets API access for AI agents. Read and write spreadsheet data, create sheets, and manage formatting with OAuth token passthrough.

## API Endpoints

### GET `/spreadsheets/{spreadsheetId}`

Get spreadsheet metadata and properties

**Example:**

```bash
curl -X GET https://api.serendb.com/publishers/google-sheets/spreadsheets/{spreadsheetId} \
  -H "Authorization: Bearer $SEREN_API_KEY"
```

### GET `/spreadsheets/{spreadsheetId}/values/{range}`

Read cell values from a range

**Example:**

```bash
curl -X GET https://api.serendb.com/publishers/google-sheets/spreadsheets/{spreadsheetId}/values/{range} \
  -H "Authorization: Bearer $SEREN_API_KEY"
```

### PUT `/spreadsheets/{spreadsheetId}/values/{range}`

Write values to a range

**Example:**

```bash
curl -X PUT https://api.serendb.com/publishers/google-sheets/spreadsheets/{spreadsheetId}/values/{range} \
  -H "Authorization: Bearer $SEREN_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{}'
```

### POST `/spreadsheets/{spreadsheetId}/values/{range}:append`

Append values to a sheet

**Example:**

```bash
curl -X POST https://api.serendb.com/publishers/google-sheets/spreadsheets/{spreadsheetId}/values/{range}:append \
  -H "Authorization: Bearer $SEREN_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{}'
```

### POST `/spreadsheets/{spreadsheetId}/values:batchGet`

Read multiple ranges

**Example:**

```bash
curl -X POST https://api.serendb.com/publishers/google-sheets/spreadsheets/{spreadsheetId}/values:batchGet \
  -H "Authorization: Bearer $SEREN_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{}'
```

### POST `/spreadsheets/{spreadsheetId}/values:batchUpdate`

Write to multiple ranges

**Example:**

```bash
curl -X POST https://api.serendb.com/publishers/google-sheets/spreadsheets/{spreadsheetId}/values:batchUpdate \
  -H "Authorization: Bearer $SEREN_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{}'
```

### POST `/spreadsheets/{spreadsheetId}:batchUpdate`

Apply batch updates (formatting, sheets)

**Example:**

```bash
curl -X POST https://api.serendb.com/publishers/google-sheets/spreadsheets/{spreadsheetId}:batchUpdate \
  -H "Authorization: Bearer $SEREN_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{}'
```

### POST `/spreadsheets`

Create a new spreadsheet

**Example:**

```bash
curl -X POST https://api.serendb.com/publishers/google-sheets/spreadsheets \
  -H "Authorization: Bearer $SEREN_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{}'
```

## MCP Tools

This API publisher also supports MCP (Model Context Protocol) access. Each API endpoint is available as an MCP tool.

### Available Tools

- `get_spreadsheets_by_spreadsheetId`: Get spreadsheet metadata and properties
- `get_spreadsheets_by_spreadsheetId_values_by_range`: Read cell values from a range
- `put_spreadsheets_by_spreadsheetId_values_by_range`: Write values to a range
- `post_spreadsheets_by_spreadsheetId_values_{range}:append`: Append values to a sheet
- `post_spreadsheets_by_spreadsheetId_values:batchGet`: Read multiple ranges
- `post_spreadsheets_by_spreadsheetId_values:batchUpdate`: Write to multiple ranges
- `post_spreadsheets_{spreadsheetId}:batchUpdate`: Apply batch updates (formatting, sheets)
- `post_spreadsheets`: Create a new spreadsheet

### Introspection

```bash
# List tools
curl https://api.serendb.com/publishers/google-sheets/_mcp/tools \
  -H "Authorization: Bearer $SEREN_API_KEY"

# Call a tool
curl -X POST https://api.serendb.com/publishers/google-sheets/_mcp/tools/{tool_name} \
  -H "Authorization: Bearer $SEREN_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"body": {"key": "value"}}'
```

## Pricing

**Pricing Model:** per_byte

- Base price per 1000 rows (bytes): $0.00100000

**Minimum charge:** $0.00010000

---

## Need Help?

- Seren Docs: https://docs.serendb.com
- Publisher: Google Sheets API access for AI agents. Read and write spreadsheet data, create sheets, and manage formatting with OAuth token passthrough.