Google Sheets skill for reading and writing spreadsheets via the gws CLI. Covers cell reads, row appends, batch updates, sheet management, and formula evaluation.
インストールする前に、エージェントに与えられる指示の中身を確認できます。
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
まだレビューはありません。使ってみた感想をお寄せください。
概要と使いどころ
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.
日本語の概要は準備中です。原文の説明を表示しています。
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.
日本語の概要は準備中です。原文の説明を表示しています。
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.
日本語の概要は準備中です。原文の説明を表示しています。
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.
日本語の概要は準備中です。原文の説明を表示しています。
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.
日本語の概要は準備中です。原文の説明を表示しています。
WooCommerce store operations through NV oOS Pro — product research, catalog cross-referencing, inventory lookups, and Shopify or Flowhub comparisons where integrations are configured.
日本語の概要は準備中です。原文の説明を表示しています。