> **Building with AI coding agents?** If you're using an AI coding agent, install the official Scalekit plugin. It gives your agent full awareness of the Scalekit API — reducing hallucinations and enabling faster, more accurate code generation.
>
> - **Claude Code**: `/plugin marketplace add scalekit-inc/claude-code-authstack` then `/plugin install <auth-type>@scalekit-auth-stack`
> - **GitHub Copilot CLI**: `copilot plugin marketplace add scalekit-inc/github-copilot-authstack` then `copilot plugin install <auth-type>@scalekit-auth-stack`
> - **Codex**: run the bash installer, restart, then open Plugin Directory and enable `<auth-type>`
> - **Skills CLI** (Windsurf, Cline, 40+ agents): `npx skills add scalekit-inc/skills --list` then `--skill <skill-name>`
>
> `<auth-type>` / `<skill-name>`: `agent-auth`, `full-stack-auth`, `mcp-auth`, `modular-sso`, `modular-scim` — [Full setup guide](https://docs.scalekit.com/dev-kit/build-with-ai/)

---

# Google Sheets

<div class="grid grid-cols-5 gap-4 items-center">
 <div class="col-span-4">
  Connect to Google Sheets. Create, edit, and analyze spreadsheets with powerful data management capabilities
 </div>
 <div class="flex justify-center">
  <img src="https://cdn.scalekit.cloud/sk-connect/assets/provider-icons/google_sheets.svg" width="64" height="64" alt="Google Sheets logo" />
 </div>
</div>

Supports authentication: OAuth 2.0

## Usage

<UsageGooglesheetsSection />

## Tool list

## `googlesheets_create_spreadsheet`

Create a new Google Sheets spreadsheet with an optional title and initial sheet configuration. Returns the new spreadsheet ID and metadata.

| Name | Type | Required | Description |
| --- | --- | --- | --- |
| `locale` | string | No | Locale of the spreadsheet |
| `schema_version` | string | No | Optional schema version to use for tool execution |
| `sheets` | `array<object>` | No | Initial sheets to include in the spreadsheet |
| `time_zone` | string | No | Time zone for the spreadsheet |
| `title` | string | No | Title of the new spreadsheet |
| `tool_version` | string | No | Optional tool version to use for execution |

## `googlesheets_get_values`

Returns only the cell values from a specific range in a Google Sheet — no metadata, no formatting, just the data. For full spreadsheet metadata and formatting, use googlesheets_read_spreadsheet instead.

| Name | Type | Required | Description |
| --- | --- | --- | --- |
| `major_dimension` | string | No | Whether values are returned by rows or columns |
| `range` | string | Yes | Cell range to read in A1 notation |
| `schema_version` | string | No | Optional schema version to use for tool execution |
| `spreadsheet_id` | string | Yes | The ID of the Google Sheet |
| `tool_version` | string | No | Optional tool version to use for execution |
| `value_render_option` | string | No | How values should be rendered in the response |

## `googlesheets_read_spreadsheet`

Returns everything about a spreadsheet — including spreadsheet metadata, sheet properties, cell values, formatting, themes, and pixel sizes. If you only need cell values, use googlesheets_get_values instead.

| Name | Type | Required | Description |
| --- | --- | --- | --- |
| `include_grid_data` | boolean | No | Include cell data in the response |
| `ranges` | string | No | Cell range to read in A1 notation |
| `schema_version` | string | No | Optional schema version to use for tool execution |
| `spreadsheet_id` | string | Yes | The ID of the Google Sheet to read |
| `tool_version` | string | No | Optional tool version to use for execution |

## `googlesheets_update_values`

Update cell values in a specific range of a Google Sheet. Supports writing single cells or multiple rows and columns at once.

| Name | Type | Required | Description |
| --- | --- | --- | --- |
| `include_values_in_response` | boolean | No | Return the updated cell values in the response |
| `range` | string | Yes | Cell range to update in A1 notation |
| `schema_version` | string | No | Optional schema version to use for tool execution |
| `spreadsheet_id` | string | Yes | The ID of the Google Sheet to update |
| `tool_version` | string | No | Optional tool version to use for execution |
| `value_input_option` | string | No | How input values should be interpreted |
| `values` | `array<array>` | Yes | 2D array of values to write to the range |

---

## More Scalekit documentation

| Resource | What it contains | When to use it |
|----------|-----------------|----------------|
| [/llms.txt](/llms.txt) | Structured index with routing hints per product area | Start here — find which documentation set covers your topic before loading full content |
| [/llms-full.txt](/llms-full.txt) | Complete documentation for all Scalekit products in one file | Use when you need exhaustive context across multiple products or when the topic spans several areas |
| [sitemap-0.xml](https://docs.scalekit.com/sitemap-0.xml) | Full URL list of every documentation page | Use to discover specific page URLs you can fetch for targeted, page-level answers |