📋

Google Sheets CLI

community

Read, write, and update Google Sheets data via CLI — read tables, append rows, update cells, and perform batch operations.

data

What This Skill Does

Read, write, and update Google Sheets data via CLI — read tables, append rows, update cells, and perform batch operations.

Capabilities

  • Read Tables — Fetch and display spreadsheet data
  • Append Rows — Add new data rows to sheets
  • Update Cells — Modify cells by key or index
  • Batch Operations — Perform bulk updates efficiently

How It Works

  1. Connect to your Google Sheet by ID or URL
  2. Use CLI commands to read, write, or update data
  3. Batch operations handle bulk changes efficiently
  4. Data is synced directly with Google Sheets

Example Usage

"Read all data from the Projects sheet"
"Append a new row to the Tasks spreadsheet"
"Update the status column for row 5"