# Google Sheets API API

> Google Sheets API API on Apizie: 17 endpoints (Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any…, Creates a spreadsheet, returning the newly created spreadsheet., Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within…, Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. For more information,…, …) returned as clean JSON through one API key. Send your own provider key in the x-upstream-key header. Call it over REST at https://www.apizie.tech/v1/analytics:googleapis-sheets/{endpoint} or from Claude, ChatGPT and Cursor through the Apizie MCP server. Free plan: 1,000 requests a month.

- Project key: `analytics:googleapis-sheets`
- Category: Analytics
- Status: byok
- Source: https://developers.google.com/workspace/sheets/
- Page: https://www.apizie.tech/api/analytics/googleapis-sheets
- OpenAPI: https://www.apizie.tech/api/analytics/googleapis-sheets/openapi.json

Reads and writes Google Sheets.

## Endpoints

### Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-batch-update` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| spreadsheetId | string | yes | The spreadsheet to apply the updates to. |
| body | object | yes | JSON request body |

### Creates a spreadsheet, returning the newly created spreadsheet.
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-create` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| body | object | yes | JSON request body |

### Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within…
`GET https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-get` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| commentsViewMode | string | no | The comments view mode to apply to the spreadsheet. This allows viewing the spreadsheet with comments omitted or included. If one is not… |
| excludeTablesInBandedRanges | boolean | no | True if tables should be excluded in the banded ranges. False if not set. |
| includeGridData | boolean | no | True if grid data should be returned. This parameter is ignored if a field mask was set in the request. |
| ranges | string | no | The ranges to retrieve from the spreadsheet. |
| spreadsheetId | string | yes | The spreadsheet to request. |

### Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. For more information,…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-get-by-data-filter` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| spreadsheetId | string | yes | The spreadsheet to request. |
| body | object | yes | JSON request body |

### Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the…
`GET https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-developer-metadata-get` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| metadataId | integer | yes | The ID of the developer metadata to retrieve. |
| spreadsheetId | string | yes | The ID of the spreadsheet to retrieve metadata from. |

### Returns all developer metadata matching the specified DataFilter. For more information, see [Read, write,…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-developer-metadata-search` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| spreadsheetId | string | yes | The ID of the spreadsheet to retrieve metadata from. |
| body | object | yes | JSON request body |

### Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-sheets-copy-to` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| sheetId | integer | yes | The ID of the sheet to copy. |
| spreadsheetId | string | yes | The ID of the spreadsheet containing the sheet to copy. |
| body | object | yes | JSON request body |

### Appends values to a spreadsheet. The input range is used to search for existing data and find a "table"…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-values-append` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| includeValuesInResponse | boolean | no | Determines if the update response should include the values of the cells that were appended. By default, responses do not include the… |
| insertDataOption | string | no | How the input data should be inserted. |
| range | string | yes | The [A1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell) of a range to search for a logical table of… |
| responseDateTimeRenderOption | string | no | Determines how dates, times, and durations in the response should be rendered. This is ignored if response_value_render_option is… |
| responseValueRenderOption | string | no | Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. |
| spreadsheetId | string | yes | The ID of the spreadsheet to update. |
| valueInputOption | string | no | How the input data should be interpreted. |
| body | object | yes | JSON request body |

### Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-values-batch-clear` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| spreadsheetId | string | yes | The ID of the spreadsheet to update. |
| body | object | yes | JSON request body |

### Clears one or more ranges of values from a spreadsheet. For more information, see [Read, write, and search…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-values-batch-clear-by-data-filter` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| spreadsheetId | string | yes | The ID of the spreadsheet to update. |
| body | object | yes | JSON request body |

### Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one…
`GET https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-values-batch-get` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| dateTimeRenderOption | string | no | How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The… |
| majorDimension | string | no | The major dimension that results should use. For example, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`, then requesting… |
| ranges | string | no | The [A1 notation or R1C1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell) of the range to retrieve… |
| spreadsheetId | string | yes | The ID of the spreadsheet to retrieve data from. |
| valueRenderOption | string | no | How values should be represented in the output. The default render option is ValueRenderOption.FORMATTED_VALUE. |

### Returns one or more ranges of values that match the specified data filters. For more information, see [Read,…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-values-batch-get-by-data-filter` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| spreadsheetId | string | yes | The ID of the spreadsheet to retrieve data from. |
| body | object | yes | JSON request body |

### Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-values-batch-update` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| spreadsheetId | string | yes | The ID of the spreadsheet to update. |
| body | object | yes | JSON request body |

### Sets values in one or more ranges of a spreadsheet. For more information, see [Read, write, and search…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-values-batch-update-by-data-filter` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| spreadsheetId | string | yes | The ID of the spreadsheet to update. |
| body | object | yes | JSON request body |

### Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-values-clear` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| range | string | yes | The [A1 notation or R1C1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell) of the values to clear. |
| spreadsheetId | string | yes | The ID of the spreadsheet to update. |
| body | object | yes | JSON request body |

### Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.
`GET https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-values-get` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| dateTimeRenderOption | string | no | How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE. The… |
| majorDimension | string | no | The major dimension that results should use. For example, if the spreadsheet data in Sheet1 is: `A1=1,B1=2,A2=3,B2=4`, then requesting… |
| range | string | yes | The [A1 notation or R1C1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell) of the range to retrieve… |
| spreadsheetId | string | yes | The ID of the spreadsheet to retrieve data from. |
| valueRenderOption | string | no | How values should be represented in the output. The default render option is FORMATTED_VALUE. |

### Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a…
`POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-values-update` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| includeValuesInResponse | boolean | no | Determines if the update response should include the values of the cells that were updated. By default, responses do not include the… |
| range | string | yes | The [A1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell) of the values to update. |
| responseDateTimeRenderOption | string | no | Determines how dates, times, and durations in the response should be rendered. This is ignored if response_value_render_option is… |
| responseValueRenderOption | string | no | Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. |
| spreadsheetId | string | yes | The ID of the spreadsheet to update. |
| valueInputOption | string | no | How the input data should be interpreted. |
| body | object | yes | JSON request body |

## Example
```
curl "https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-batch-update" \
  -H "x-api-key: $APIZIE_KEY" \
  -H "x-upstream-key: $PROVIDER_KEY"
```

## FAQ

### How do I call the Google Sheets API API?
Create a free Apizie key, then send POST https://www.apizie.tech/v1/analytics:googleapis-sheets/sheets-spreadsheets-batch-update with the header x-api-key. Every endpoint returns { project, data, timestamp }.

### Is the Google Sheets API API free on Apizie?
Yes. The Free plan includes 1,000 requests a month at 100 requests a minute, no credit card. Google Sheets API itself also needs your own key from googleapis.com.

### Can AI agents use the Google Sheets API API?
Yes. Add the Apizie MCP server (https://www.apizie.tech/mcp) to Claude, ChatGPT, Cursor or VS Code, then ask in plain language. The agent calls run_scraper with project key analytics:googleapis-sheets.

### What is the status of the Google Sheets API API?
Needs your own provider key (bring your own key)