Can I perform cell formatting like colors and fonts?

Absolutely. The skill includes a 'format' command that allows you to set bold/italic styles, background colors (hex), text colors, and font sizes.

How do I authenticate the Google Sheets skill?

You must run the command 'gws auth login' to provide OAuth2 consent via your browser. You can check your status anytime with 'gws auth status'.

Can I read specific ranges or entire sheets?

Yes, the skill supports standard A1 notation for specific ranges (e.g., 'Sheet1!A1:D10') or you can provide the sheet name to read all available data.

Do I need an official Google CLI to use this skill?

No, this skill uses the unofficial gws (Workspace CLI), which is an independent, open-source project designed for Google Workspace management.

Does this skill support JSON output for automation?

Yes, the skill defaults to structured JSON output, making it highly compatible with AI agents and scripts that need to parse spreadsheet data programmatically.

Google Sheets CLI Integration

Name: Google Sheets CLI Integration
Author: omriariav

byomriariav

•

Productivity & Workflow

Manages Google Sheets spreadsheets directly from the command line, enabling seamless data reading, writing, and formatting for automated workflows.

The Google Sheets skill provides a comprehensive CLI interface for interacting with Google Sheets, allowing users to perform complex spreadsheet tasks without leaving their terminal or IDE. It supports over 19 distinct commands covering everything from basic data retrieval and cell updates to advanced sheet management like freezing panes, merging cells, and applying conditional formatting. Designed for automation and programmatic access, it outputs structured JSON by default, making it an essential tool for developers building data pipelines, reporting scripts, or integrating live spreadsheet data into their coding environment via Claude Code.

Key Features

01Powerful data processing tools including find-and-replace, multi-column sorting, and cell merging

022 GitHub stars

03Advanced formatting controls for bold text, background colors, font sizes, and cell alignment

04Full spreadsheet CRUD operations including creating, reading, updating, and appending data

05Precision row and column manipulation such as inserting, deleting, resizing, and freezing panes

06Structural management of sheets, including adding, renaming, duplicating, and deleting individual tabs

Use Cases

01Automating the export of application logs or database queries directly into a shared Google Sheet for team visibility

02Cleaning and reformatting large datasets in Google Sheets using CLI-based batch operations

03Programmatically updating project trackers or financial models from a local development environment

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add omriariav/workspace-cli sheets

For use in Claude.ai and ChatGPT

Download Skill