/google-sheets-plg

name: google-sheets-plg
description: Agent-callable Google Sheets tools — read and write spreadsheet data as rows or raw cells, manage worksheets and columns, and apply formatting, sorting, and validation. Use when the user mentions Google Sheets or wants to read, add, update, look up, or organize spreadsheet data, even if they don't name Sheets explicitly.
license: Elastic-2.0
compatibility: Run `npm install --omit=dev` in this directory, then `node cli.js`. The TypeScript source needs Node.js 22.18+; on older Node, run `cli.js` for build-it-yourself / prebuilt / alternative-runtime options.
metadata:
  title: Google Sheets
  source: https://github.com/zapier/connectors/blob/main/plugins/google-sheets-plg/skills/google-sheets-plg/SKILL.md
  zapier-app-key: GoogleSheetsV2CLIAPI
  api-docs: https://developers.google.com/workspace/sheets/api/reference/rest

Google Sheets

_Independent, unofficial connector for Google Sheets. Not affiliated with, endorsed by, or sponsored by Google Sheets. "Google Sheets" is a trademark of its owner, used only to identify the service this connector works with._

Tools for working with Google Sheets against the [Google Sheets API v4](https://developers.google.com/workspace/sheets/api/reference/rest) (`https://sheets.googleapis.com/v4/`), with spreadsheet discovery via the [Google Drive API](https://developers.google.com/drive/api/reference/rest/v3/files/list). 26 tools across two complementary surfaces: a **record surface** — rows as objects keyed by their column headers (the "log this expense", "update the status to Done", "look up last quarter's total" jobs) — and a **cell surface** — raw A1-addressed values for formulas, precise numeric/text control, and arbitrary ranges. Plus spreadsheet/worksheet structure and presentation (formatting, sorting, validation).

When to use this

• **Read or find data inside a spreadsheet** — look up a row by a column value (`lookupRow`), find all matching rows (`findRows`), list a window of rows (`listRows`), or read a raw range (`getValues`).
• **Write data** — append a row or many rows (`createRow` / `createRows`), update specific columns of a row without disturbing the others (`updateRow` / `updateRows`), or write a raw range / formula (`updateValues`).
• **Clear or delete** — clear a row's contents but keep the row (`clearRows` / `clearValues`) or remove rows entirely (`deleteRows`).
• **Manage structure** — create a spreadsheet (`createSpreadsheet`), add / list / copy / rename / hide / delete worksheets, add columns.
• **Format & validate** — number/date/currency formats, text styling, sort a range, copy a range, dropdowns and number/date validation, conditional formatting.

Setup

This is an [agentskills.io](https://agentskills.io) skill.

If the connector has not been installed as a skill yet, install it first with `npx skills add zapier/connectors --skill google-sheets-plg` (or your harness's own skill-install mechanism), then continue here. Installing the skill copies these files, not dependencies. Before running the CLI, a local MCP server, or `zapier-sdk` auth commands, run `npm install --omit=dev` here once. Importing the published package as a dependency in your own project instead? That `npm install` already resolves everything — see [`references/use-as-sdk.md`](references/use-as-sdk.md).

The connector runs on **Node.js 22.18+**. Pick the reference that matches how you're running it, and load it before doing anything else:

| You have... | Load | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------------------------------------ | | An MCP-aware client — tools may already be loaded (e.g. `mcp__google-sheets-plg__<tool>`), or you can register a local server yourself (or guide the user to) | [`references/use-as-mcp.md`](references/use-as-mcp.md) | | Terminal / subprocess access (you can run `node`) | [`references/use-as-cli.md`](references/use-as-cli.md) | | Only your own code, importing this package as a dependency | [`references/use-as-sdk.md`](references/use-as-sdk.md) | | No tool access, no terminal, no ability to import this package — you write your own code that calls the Google Sheets API directly (e.g. a code-execution sandbox) | [`references/use-as-recipe.md`](references/use-as-recipe.md) |

Scripts

All scripts use the single `google-sheets-plg` connection.

| Script | Script name | Connections | Description | | ------------------------------------------------------------------------------ | --------------------------- | ------------------- | --------------------------------------------------------------------------------- | | [`scripts/createSpreadsheet.ts`](scripts/createSpreadsheet.ts) | `createSpreadsheet` | `google-sheets-plg` | Create a new spreadsheet, optionally with worksheets and a header row. | | [`scripts/getSpreadsheet.ts`](scripts/getSpreadsheet.ts) | `getSpreadsheet` | `google-sheets-plg` | Get a spreadsheet's metadata and its list of worksheets. | | [`scripts/listSpreadsheets.ts`](scripts/listSpreadsheets.ts) | `listSpreadsheets` | `google-sheets-plg` | Find spreadsheets in Drive by name (needs Drive acces