# Google Sheets tools

> The Google Sheets tools in the developer API, with every argument: read a spreadsheet's tabs, named ranges and values.

**Needs:** A Google Sheets connection. 2 tools, all read-only.

> [!IMPORTANT]
> Google is still reviewing the permission this connector needs. Until it approves it, Plugsight offers Google Sheets to Plugsight admins only, so for most people it isn't in the **Connector catalog** yet and these tools don't appear. See [Google Sheets](https://docs.plugsight.app/connectors/google-sheets.md).

These tools appear in `GET /v1/tools` only when the API key's MCP server includes a connection of this kind. Call each one with `POST /v1/tools/\<name>`, sending its arguments as a JSON object. See [Calling tools](https://docs.plugsight.app/developers/calling-tools.md) for the request and response format.

Open a spreadsheet by its link or id. The optional `account` argument takes a Google Sheets connection `id` from [`list_accounts`](https://docs.plugsight.app/developers/accounts-tools.md); leave it out when the MCP server has only one.

| Tool | What it does | Kind |
| --- | --- | --- |
| [`sheets_get_info`](#sheets_get_info) | Spreadsheet details | Read |
| [`sheets_read`](#sheets_read) | Read a spreadsheet | Read |

Every tool here only reads: none of them changes anything in Google Sheets, so none needs `confirm`.

The example requests fill in only the required arguments, with placeholder values.

## sheets_get_info

**Spreadsheet details** · Read

A Google Sheets spreadsheet's title, tabs (with their size) and named ranges. Call it before sheets_read to pick a tab.

| Argument | Type | Required | What it is |
| --- | --- | --- | --- |
| `spreadsheet` | string | Yes | The spreadsheet's link (from the browser's address bar) or its id |
| `account` | string | No | Google Sheets connection id from list_accounts (optional when there's only one) |

Example request:

```bash
curl -X POST https://app.plugsight.app/v1/tools/sheets_get_info \
  -H "Authorization: Bearer $PLUGSIGHT_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"spreadsheet": "…"}'
```

## sheets_read

**Read a spreadsheet** · Read

Reads values as shown in Google Sheets from a tab or range, e.g. "Sales", "Sales!A1:F200" or a named range. With header true, the first row becomes the column names.

| Argument | Type | Required | What it is |
| --- | --- | --- | --- |
| `spreadsheet` | string | Yes | The spreadsheet's link (from the browser's address bar) or its id |
| `range` | string | No | Tab name or A1 range, e.g. "Sales" or "Sales!A1:F200". Default: the first tab |
| `header` | boolean | No | Treat the first row as column names. Default `true`. |
| `max_rows` | integer | No | Most rows to return. From 1 to 5,000. Default `500`. |
| `account` | string | No | Google Sheets connection id from list_accounts (optional when there's only one) |

Example request:

```bash
curl -X POST https://app.plugsight.app/v1/tools/sheets_read \
  -H "Authorization: Bearer $PLUGSIGHT_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"spreadsheet": "…"}'
```

## Related articles

- [Google Sheets](https://docs.plugsight.app/connectors/google-sheets.md)
- [Calling tools](https://docs.plugsight.app/developers/calling-tools.md)
- [Errors](https://docs.plugsight.app/developers/errors.md)
- [Accounts tools](https://docs.plugsight.app/developers/accounts-tools.md)

---

Web version: https://docs.plugsight.app/developers/sheets-tools
