> **Building with AI coding agents?** Install the authstack plugin with one command. This equips your agent with accurate Scalekit implementation patterns.
>
> **Recommended**:
> ```bash
> npx @scalekit-inc/cli setup
> ```
>
> Global:
> ```bash
> npm install -g @scalekit-inc/cli
> scalekit setup
> ```
>
> Supports Claude Code, Cursor, GitHub Copilot, Codex + skills for 40+ agents.
> Features: full-stack-auth, agent-auth, mcp-auth, modular-sso, modular-scim.
> [Full setup guide](https://docs.scalekit.com/dev-kit/build-with-ai/)

---

# Google Sheets connector

1. ### Install the SDK

   ```bash frame="terminal"
       npm install @scalekit-sdk/node
       ```
     ```bash frame="terminal"
       pip install scalekit
       ```
     Full SDK reference: [Node.js](/agentkit/sdks/node/) | [Python](/agentkit/sdks/python/)

2. ### Set your credentials

   <AgentKitCredentials />

3. ### Set up the connector

   Register your Google Sheets credentials with Scalekit so it handles the token lifecycle. You do this once per environment.

   <details>
   <summary>Dashboard setup steps</summary>

   <SetupGoogleSheetsSection />

   </details>

4. ### Authorize and make your first call

   <QuickstartGenericOauthSection connector="googlesheets" toolName="googlesheets_read_spreadsheet" providerName="Google Sheets" toolInputNode="{ spreadsheet_id: 'YOUR_SPREADSHEET_ID' }" toolInputPython='{"spreadsheet_id":"YOUR_SPREADSHEET_ID"}' />

## What you can do

Connect this agent connector to let your agent:

- **Update spreadsheet properties, dimension properties, batch** — Update spreadsheet-level properties of a Google Sheet, such as its title, locale, or time zone
- **Whitespace trim** — Remove leading and trailing whitespace, and collapse internal whitespace to single spaces, for every cell in a range of a Google Sheet
- **Columns text to** — Split the text in a single column of a Google Sheet into multiple columns, using a delimiter such as comma, semicolon, or a custom character
- **Range sort, insert, add protected** — Sort the rows within a range in a Google Sheet by a single column, ascending or descending
- **Filter set basic, clear basic, batch clear values by data** — Create the standard 'basic filter' on a range in a Google Sheet, enabling the filter dropdown arrows in the header row
- **Search developer metadata** — Search for developer metadata entries in a Google Sheet by key, or by the sheet/row/column they are attached to

## Common workflows

<SectionAfterSetupGooglesheetsCommonWorkflows />

## Tool list

Use the exact tool names from the **Tool list** below when you call `execute_tool`. If you're not sure which name to use, list the tools available for the current user first.

<ToolList tools={tools} />

---

## 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 |