AutoGineer
Generated banner for Gws Sheets
Generated logo for Gws Sheets

Gws Sheets

Google WorkspaceOfficialPublished by Google Workspace

  • Skill
  • Tool integration
  • Automation and integrations
  • Apache-2.0
  • No issues found
Download ZIP

From the author

Google Sheets: Read and write spreadsheets.
— the description by Google Workspace

AutoGineer summary

Written by AutoGineer from the skill’s own files, not by the author

The gws-sheets skill provides a command-line interface to interact with Google Sheets, enabling users to perform various operations such as creating, reading, and updating spreadsheets. It acts as a wrapper for the Google Sheets API, allowing for programmatic management of spreadsheet data and metadata directly from the terminal.

What it does

  • Create new Google Sheets spreadsheets
  • Retrieve spreadsheet data using specific IDs or data filters
  • Apply batch updates to spreadsheets with validation
  • Manage developer metadata within spreadsheets
  • Interact with individual sheets and cell values
  • Inspect API schemas to determine required parameters and types

When to use it

  • When you need to automate spreadsheet data entry or retrieval
  • When managing Google Sheets programmatically via CLI
  • When performing batch updates on spreadsheet structures
  • When integrating Google Sheets operations into shell scripts or automated workflows

Advantages

  • Provides direct CLI access to Google Sheets API functionality
  • Supports complex batch update operations with validation
  • Allows for granular data retrieval using field masks or data filters
  • Integrates seamlessly with other gws-based tools

Usage examples

“gws sheets spreadsheets create --params '{"properties": {"title": "New Report"}}'”
Creates a new Google Sheets file titled 'New Report' and returns the spreadsheet object.
“gws schema sheets.spreadsheets.get”
Displays the required parameters, types, and default values for the get method to help construct the correct command.

Install

  1. Download the skill as a ZIP:

    https://mp-staging.autogineer.com/agent-skills/googleworkspace/gws-sheets/download

  2. Unzip it into the cross-client skills folder of your project:

    mkdir -p .agents/skills && unzip gws-sheets.zip -d .agents/skills

Documentation by Google Workspace

sheets (v4)

PREREQUISITE: Read ../gws-shared/SKILL.md for auth, global flags, and security rules. If missing, run gws generate-skills to create it.

gws sheets <resource> <method> [flags]

Helper Commands

CommandDescription
+appendAppend a row to a spreadsheet
+readRead values from a spreadsheet

API Resources

spreadsheets

  • batchUpdate — Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not valid then the entire request will fail and nothing will be applied. Some requests have replies to give you some information about how they are applied. The replies will mirror the requests. For example, if you applied 4 updates and the 3rd one had a reply, then the response will have 2 empty replies, the actual reply, and another empty reply, in that order.

  • create — Creates a spreadsheet, returning the newly created spreadsheet.

  • get — Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids is not returned. You can include grid data in one of 2 ways: * Specify a field mask listing your desired fields using the fields URL parameter in HTTP * Set the includeGridData URL parameter to true.

  • getByDataFilter — Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. For more information, see Read, write, and search metadata. This method differs from GetSpreadsheet in that it allows selecting which subsets of spreadsheet data to return by specifying a dataFilters parameter. Multiple DataFilters can be specified.

  • developerMetadata — Operations on the 'developerMetadata' resource

  • sheets — Operations on the 'sheets' resource

  • values — Operations on the 'values' resource

Discovering Commands

Before calling any API method, inspect it:

# Browse resources and methods
gws sheets --help

# Inspect a method's required params, types, and defaults
gws schema sheets.<resource>.<method>

Use gws schema output to build your --params and --json flags.

Files

Requirements and compatibility

Works with: Claude Code, Claude apps, OpenAI Codex, GitHub Copilot, Cursor, Gemini CLI, Kiro, OpenCode, Goose, Amp, Roo Code, JetBrains Junie, Factory Droid, Devin (ex-Windsurf), Mistral Vibe, OpenHands, Letta

“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.

Security

No issues found by our static scan· No issues found

A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.

Attribution and licence

Published by
Google Workspace
Publisher
Google Workspace (Official)
Source
googleworkspace/cli · skills/gws-sheets · commit cd3697e
Licence
Apache License 2.0 (redistribution allowed)
  • LICENSE (added by AutoGineer from LICENSE)
  • ATTRIBUTION.md (written by AutoGineer)
Synced

AutoGineer is not affiliated with or endorsed by Google Workspace.

Download ZIP

The ZIP holds the skill’s files, its licence files and an ATTRIBUTION.md. Download gws-sheets.zip