google-sheets
A Google Sheets connector from Zapier's connectors repository, packaged as an agent skill with TypeScript scripts that call the Sheets v4 API and use the Drive API to find spreadsheets.
What the skill teaches
A Google Sheets connector from Zapier's connectors repository, packaged as an agent skill with TypeScript scripts that call the Sheets v4 API and use the Drive API to find spreadsheets. The agent can run them through a bundled CLI, register them as a local MCP server, or import them as a library; Node.js 22.18 or newer is needed and dependencies are installed with npm first. Scripts look up and list rows, read raw ranges, add or update rows and ranges, clear or delete rows, create spreadsheets and worksheets, and apply formats, sorting, validation and conditional formatting. Zapier states it is unofficial and not affiliated with Google.
Capabilities
- Look up, add and update rows
- Read and write raw ranges and formulas
- Create spreadsheets and manage worksheets
- Apply formatting, sorting and validation
Install
- Run this to add it to Any client:
npx skills add zapier/connectors --skill google-sheets
What's inside
- .claude-plugin/plugin.json
- .mcp.json
- CHANGELOG.md
- LICENSE
- NOTICE
- README.md
- cli.js
- cli.ts
- connections.ts
- evals/evals.json
- evals/results.md
- index.ts
- lib/a1.ts
- lib/constants.ts
- lib/headers.ts
- lib/schemas.ts
- lib/sheetsFetch.ts
- lib/spreadsheetId.ts
- package.json
- references/google-sheets-a1-and-values.md
- references/google-sheets-api-gotchas.md
- references/use-as-cli.md
- references/use-as-mcp.md
- references/use-as-recipe.md
- references/use-as-sdk.md
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tool | Google Sheets | |
| Publisher | Zapier | source |
| Official status | Community (not published by the tool's vendor) | source |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | Yes | source |
| Platforms | Not stated in its documentation | |
| AI clients | Not stated in its documentation | |
| Licence | Elastic-2.0 | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Aug 25, 2026185 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository |
Sources
- Skill file (SKILL.md)github.com/zapier/connectors · Backs: Licence, Official status, Includes scriptsNov 10, 2026
- GitHub repositorygithub.com/zapier/connectors · Backs: Publisher, ActivityNov 11, 2026
- Folder in the repository (google-sheets)github.com/zapier/connectors · Backs: Includes scriptsNov 10, 2026