sheets-cli

Manage Google Sheets data programmatically via a command-line interface.

3|Updated Dec 23, 2025
One-click install
npx skills add https://github.com/boazcstrike/opencode --skill sheets-cli-boazcstrike
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sheets-cli
Source: https://github.com/boazcstrike/opencode/tree/main/skills/sheets-cli
Command: npx skills add https://github.com/boazcstrike/opencode --skill sheets-cli-boazcstrike

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines interactions with Google Sheets, allowing users to read, write, and update data directly from the command line without needing to open the Google Sheets interface.

Core Features & Use Cases

  • Data Management: Read, append, and update data in Google Sheets.
  • Spreadsheet Discovery: Find spreadsheets by name.
  • Batch Operations: Perform multiple operations atomically.
  • Use Case: Update the 'Status' column for a specific project in your 'Projects' Google Sheet to 'Completed' by referencing the project's name.

Quick Start

Use the sheets-cli tool to append a new row with the values '{"Name":"NewCo","Status":"Active"}' to the 'Projects' sheet in your spreadsheet.

Frequently Asked Questions about sheets-cli

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I manage Google Sheets data directly from the command line?

You can manage Google Sheets data from the command line by using a CLI tool to read tables, append rows, and update cells by key or index. This enables programmatic data management without needing to open the Google Sheets interface.

Can I update a specific cell in Google Sheets via CLI by referencing a row key?

Yes, you can update a specific cell in Google Sheets via CLI by referencing a row key or index. This allows you to target specific records, such as changing a project's status to 'Completed' by using its name.

Does the Google Sheets CLI tool support batch operations for updating data?

Yes, the Google Sheets CLI tool supports executing batch operations. You can perform multiple data updates atomically, ensuring that a sequence of read, append, or update operations execute together reliably.

What is the best way to find a specific spreadsheet by name using an API?

The best way to find a specific spreadsheet by name is using a CLI tool that integrates with the Google Drive API. This integration enables automated spreadsheet discovery and management directly from your terminal environment.

Do I need to open the Google Sheets interface to append a new row to a sheet?

No, you do not need to open the Google Sheets interface to append a new row. You can use a CLI tool to programmatically append rows with specific JSON values, such as adding a new company to a 'Projects' sheet.