skills.rest
gmickel
gmickelCOMMUNITY
Explore all skills by this author →
Website𝕏@gmickelGitHub

sheets-cli

Read and update Google Sheets data via command-line interface with JSON inputs and dry-run previews.

Updated Aug 27, 2026
Search Tags:#spreadsheet#update#read#google-sheets#append#dry-run#sheets-cli
One-click install
npx skills add https://github.com/gmickel/claude-code-config --skill sheets-cli
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sheets-cli
Source: https://github.com/gmickel/claude-code-config/tree/main/skills/sheets-cli
Command: npx skills add https://github.com/gmickel/claude-code-config --skill sheets-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manipulating tabular data in Google Sheets via the browser or manual CSV edits is slow and error-prone; this Skill provides a reproducible command-line workflow to read, append, and update spreadsheets programmatically with previews and structured JSON I/O.

Core Features & Use Cases

  • Authentication & Access: Login and manage credentials for Google Drive and Sheets API access.
  • Discover & Inspect: Find spreadsheets by name and list sheets/tabs with metadata.
  • Read & Update Workflows: Read table rows with absolute row numbers, append rows, update by key or by row index, and set arbitrary ranges.
  • Batch & Safety: Batch operations, dry-run previews, and JSON-formatted inputs for predictable changes.
  • Use Case: Update a project tracker by finding the "Tasks" spreadsheet, reading rows to find a task ID, previewing the change, and applying a key-based status update.

Quick Start

Read the Tasks sheet, preview an update to set Status to Done for TASK-42 using a dry-run, then apply the update if the preview looks correct.

Frequently Asked Questions about sheets-cli

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

FAQPage Schema
How do I update Google Sheets data from the command line?▼

Read and update Google Sheets data from the command line using structured JSON inputs for programmatic spreadsheet edits, supporting find by name, row appending, and key-based or index updates with dry-run previews.

How do I programmatically find a specific spreadsheet by name?▼

Find a specific spreadsheet by name programmatically using the Google Drive and Sheets API access provided by the CLI, which allows you to discover spreadsheets and list sheets with metadata without manual browser interaction.

Can I preview updates to a Google Sheets project tracker before applying them?▼

Preview updates to a Google Sheets project tracker before applying them by using the dry-run feature, which allows you to verify key-based status changes or row appends safely before committing the actual modifications.

Do I need Google Drive and Sheets API access to manage spreadsheets via CLI?▼

You need Google Drive and Sheets API access to manage spreadsheets via CLI, as these API credentials are required for discovering spreadsheets, reading table rows, and performing batch updates or arbitrary range sets programmatically.

What is the safest way to append rows to Google Sheets using a command-line interface?▼

The safest way to append rows to Google Sheets using a command-line interface is using JSON-formatted inputs combined with dry-run previews, ensuring predictable changes and explicit row-number metadata before applying batch operations.

Can I use a full Google Sheets URL instead of a spreadsheet ID for CLI updates?▼

You can use a full Google Sheets URL instead of a spreadsheet ID for CLI updates, as the tool supports both spreadsheet IDs and full URLs to read table rows and perform key-based or index updates.

Related Skills

Explore More Data & Analytics Skills→
think41think41
162

gsheetx

Automate Google Sheets data access, modification, and sharing from Python using gspread.

Official
Intermediate
cellarwoodcellarwood

recipe-log-deal-update

Append deal status updates to a Google Sheets Sales Pipeline spreadsheet.

Official
Basic
m13vm13v
312

gws-sheets-append

Append rows to Google Sheets using comma-separated values or JSON arrays.

Community
Intermediate
wuyyyyyouwuyyyyyou

gws-sheets-append

Append rows to Google Sheets from CSV or JSON inputs.

Community
Intermediate