Google Sheets skill for reading and writing spreadsheets via the gws CLI. Covers cell reads, row appends, batch updates, sheet management, and formula evaluation.
The English summary is being prepared. Showing the original description.
Run score Not tested
See how to installReview the instructions the agent will receive before you install.
PREREQUISITE: Read the
gws-sharedskill for auth, global flags, and security rules.
Read and write Google Sheets spreadsheets using the gws CLI.
gws sheets <resource> <method> [flags]
Shell tip: Sheet ranges contain
!which zsh interprets as history expansion. Always use double quotes around range values:--range "Sheet1!A1:D10" # CORRECT --range 'Sheet1!A1:D10' # WRONG in zsh
# Create a new spreadsheet
gws sheets spreadsheets create \
--json '{"properties": {"title": "Q1 Budget 2026"}}'
# Get spreadsheet metadata
gws sheets spreadsheets get \
--params '{"spreadsheetId": "SPREADSHEET_ID"}'
# Read a range of cells
gws sheets spreadsheets values get \
--params '{"spreadsheetId": "SPREADSHEET_ID", "range": "Sheet1!A1:E10"}'
# Write values to a range
gws sheets spreadsheets values update \
--params '{"spreadsheetId": "SPREADSHEET_ID", "range": "Sheet1!A1", "valueInputOption": "USER_ENTERED"}' \
--json '{"values": [["Name", "Email", "Amount"], ["Alice", "alice@example.com", 500]]}'
# Append rows to a sheet
gws sheets spreadsheets values append \
--params '{"spreadsheetId": "SPREADSHEET_ID", "range": "Sheet1!A1", "valueInputOption": "USER_ENTERED", "insertDataOption": "INSERT_ROWS"}' \
--json '{"values": [["Bob", "bob@example.com", 750]]}'
# Clear a range
gws sheets spreadsheets values clear \
--params '{"spreadsheetId": "SPREADSHEET_ID", "range": "Sheet1!A2:E100"}'
# Batch read multiple ranges
gws sheets spreadsheets values batchGet \
--params '{"spreadsheetId": "SPREADSHEET_ID", "ranges": ["Sheet1!A1:B10", "Sheet2!C1:D5"]}'
# Batch write multiple ranges
gws sheets spreadsheets values batchUpdate \
--params '{"spreadsheetId": "SPREADSHEET_ID"}' \
--json '{
"valueInputOption": "USER_ENTERED",
"data": [
{"range": "Sheet1!A1", "values": [["Header"]]},
{"range": "Sheet2!A1", "values": [["Other Header"]]}
]
}'
# Add a new sheet tab
gws sheets spreadsheets batchUpdate \
--params '{"spreadsheetId": "SPREADSHEET_ID"}' \
--json '{
"requests": [{"addSheet": {"properties": {"title": "April"}}}]
}'
# Format cells (bold header row)
gws sheets spreadsheets batchUpdate \
--params '{"spreadsheetId": "SPREADSHEET_ID"}' \
--json '{
"requests": [{
"repeatCell": {
"range": {"sheetId": 0, "startRowIndex": 0, "endRowIndex": 1},
"cell": {"userEnteredFormat": {"textFormat": {"bold": true}}},
"fields": "userEnteredFormat.textFormat.bold"
}
}]
}'
| Command | Description |
|---|---|
gws sheets +read | Read values from a spreadsheet (simplified) |
gws sheets +append | Append a row to a spreadsheet (simplified) |
| Value | Behaviour |
|---|---|
RAW | Values stored as-is (strings stay strings) |
USER_ENTERED | Parsed as if typed by a user (formulas evaluated, dates recognised) |
get, create, batchUpdate
get, update, append, clear, batchGet, batchUpdate, batchClearByDataFilter
copyTo
gws sheets --help
gws schema sheets.spreadsheets.values.get
gws schema sheets.spreadsheets.values.append
gws schema sheets.spreadsheets.batchUpdate
No reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
Creating algorithmic art using p5.js with seeded randomness and interactive parameter exploration. Use this when users request creating art using code, generative art, algorithmic art, flow fields, or particle systems. Create original algorithmic art rather than copying existing artists' work to avoid copyright violations.
The English summary is being prepared. Showing the original description.
Applies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.
The English summary is being prepared. Showing the original description.
Control a headless browser to navigate URLs, click elements, fill forms, extract content from JavaScript-rendered pages, take screenshots, and automate end-to-end web workflows.
The English summary is being prepared. Showing the original description.
Create beautiful visual art in .png and .pdf documents using design philosophy. You should use this skill when the user asks to create a poster, piece of art, design, or other static piece. Create original visual designs, never copying existing artists' work to avoid copyright violations.
The English summary is being prepared. Showing the original description.
Review code for quality, simplicity, and maintainability. Identifies unnecessary abstractions, duplicated logic, oversized functions, missing error handling, and naming issues — then fixes them automatically before presenting the result.
The English summary is being prepared. Showing the original description.
WooCommerce store operations through NV oOS Pro — product research, catalog cross-referencing, inventory lookups, and Shopify or Flowhub comparisons where integrations are configured.
The English summary is being prepared. Showing the original description.