google-sheets

Google Sheets

Spreadsheet operations built for how small businesses actually track data.

Uses the gws CLI for all Sheets operations. See the google-workspace skill for setup.

Triggers

• "read the spreadsheet"
• "update the sheet"
• "add a row to..."
• "create a spreadsheet"
• "pull data from sheets"
• "log this to a spreadsheet"
• Any request involving spreadsheet read/write operations

Prerequisites

• gws CLI installed and authenticated with Sheets + Drive scope
• Run gws auth login -s sheets,drive if not already done

Core Commands

gws sheets +read                   # Read values from a spreadsheet
gws sheets +append                 # Append a row to a spreadsheet
gws sheets spreadsheets create     # Create a new spreadsheet
gws sheets spreadsheets get        # Get spreadsheet metadata

Common Operations

Read data from a sheet

# Read a range
gws sheets +read
# When prompted: spreadsheet ID + range (e.g., "Sheet1!A1:D10")

# Read via API directly
gws sheets spreadsheets values get --params '{
  "spreadsheetId": "SPREADSHEET_ID",
  "range": "Sheet1!A1:D100"
}'

# Read entire sheet
gws sheets spreadsheets values get --params '{
  "spreadsheetId": "SPREADSHEET_ID",
  "range": "Sheet1"
}'

Append a row

# Append a single row
gws sheets +append
# When prompted: spreadsheet ID, range, values

# Append via API directly
gws sheets spreadsheets values append --params '{
  "spreadsheetId": "SPREADSHEET_ID",
  "range": "Sheet1!A:D",
  "valueInputOption": "USER_ENTERED"
}' --json '{
  "values": [["2026-01-15", "Widget A", "50", "$12.50"]]
}'

Write / Update cells

# Update a specific range
gws sheets spreadsheets values update --params '{
  "spreadsheetId": "SPREADSHEET_ID",
  "range": "Sheet1!B2",
  "valueInputOption": "USER_ENTERED"
}' --json '{
  "values": [["updated value"]]
}'

# Batch update multiple ranges
gws sheets spreadsheets values batchUpdate --params '{
  "spreadsheetId": "SPREADSHEET_ID"
}' --json '{
  "valueInputOption": "USER_ENTERED",
  "data": [
    {"range": "Sheet1!A1", "values": [["Revenue"]]},
    {"range": "Sheet1!B1", "values": [["Date"]]},
    {"range": "Sheet1!A2", "values": [["$1,250"]]}
  ]
}'