skills/davila7__claude-code-templates
1
0
Fork 0
mirror of https://github.com/davila7/claude-code-templates.git synced 2026-09-19 01:30:23 +08:00
Code Issues Packages Projects Releases Wiki Activity
Files
perf/split-components-json
davila7__claude-code-templates/cli-tool/components/commands/google-workspace/gws-sheets-read.md
T
Daniel Avila e2cbc8176c feat: Add 107 Google Workspace CLI commands (#403) 
Migrated all skills from https://github.com/googleworkspace/cli to claude-code-templates as command components.

## Summary

Added 107 Google Workspace commands across three categories:
- 47 GWS service commands (gmail, drive, calendar, sheets, docs, etc.)
- 10 persona commands (IT admin, project manager, etc.)
- 50 recipe/workflow commands (task automation, team collaboration, etc.)

## GWS Service Commands (47)

Google Workspace API integrations for core services:
- Admin SDK (users, groups, devices, org units)
- Gmail (send, read, manage email)
- Calendar (events, scheduling, agenda)
- Drive (files, folders, sharing, upload)
- Docs/Sheets/Slides (document management)
- Chat/Meet (collaboration)
- Tasks (task management)
- Forms (form creation and responses)
- Classroom (education management)
- Vault (eDiscovery and archiving)
- Apps Script (automation)
- Model Armor (AI safety)
- And more specialized services

## Persona Commands (10)

Role-based workflow personas:
- IT Administrator
- Project Manager
- Executive Assistant
- Content Creator
- Customer Support
- Event Coordinator
- HR Coordinator
- Researcher
- Sales Operations
- Team Lead

## Recipe/Workflow Commands (50)

Task automation workflows:
- Email automation (batch reply, filters, drafts)
- Calendar management (scheduling, free time, events from sheets)
- Drive operations (folder organization, file ownership, sharing)
- Form workflows (feedback forms, response collection)
- Sheet automation (backup, compare tabs, reports)
- Team collaboration (announcements, file sharing, notifications)
- Meeting workflows (scheduling, participant review, materials)
- Security tasks (audit sharing, triage alerts)
- Document workflows (templates, save email to doc)
- And many more productivity automations

## Technical Details

- All commands use proper frontmatter (allowed-tools, argument-hint, description)
- Commands include usage examples and prerequisite checks
- Structured with Task sections for Claude Code execution
- Include Apache 2.0 license attribution
- Reference original skill names for traceability

## Component Catalog

- Updated docs/components.json
- Total commands: 168 → 275 (107 new)
- All new commands in google-workspace category with subcategories

## License & Attribution

Source: Google Workspace CLI (https://github.com/googleworkspace/cli)
License: Apache License 2.0
All commands include proper attribution and license information

Co-authored-by: Claude Opus 4.6 <noreply@anthropic.com>
2026-03-07 15:25:10 -05:00

2.5 KiB
Raw Permalink Blame History

allowed-tools: Bash, Read, Write, Edit argument-hint: [resource] [method] [flags] description: Google Sheets: Read values from a spreadsheet.

Google Workspace Sheets Read

Execute Google Workspace Sheets Read operations: $ARGUMENTS

Prerequisites

  • Google Workspace CLI (gws) must be installed
  • Authentication configured: Run gws auth status to verify
  • Review gws sheets-read --help for all available commands

Available Resources and Methods

sheets +read

PREREQUISITE: Read ../gws-shared/SKILL.md for auth, global flags, and security rules. If missing, run gws generate-skills to create it.

Read values from a spreadsheet

Usage

gws sheets +read --spreadsheet <ID> --range <RANGE>

Flags

Flag Required Default Description
--spreadsheet ✓ — Spreadsheet ID
--range ✓ — Range to read (e.g. 'Sheet1!A1:B2')

Examples

gws sheets +read --spreadsheet ID --range 'Sheet1!A1:D10'
gws sheets +read --spreadsheet ID --range Sheet1

Tips

  • Read-only — never modifies the spreadsheet.
  • For advanced options, use the raw values.get API.

See Also

Usage

# List available resources and methods
gws sheets-read --help

# Inspect method schema before calling
gws schema sheets-read.<resource>.<method>

# Execute command with arguments
gws sheets-read $ARGUMENTS

Task

Execute the requested Sheets Read operation: $ARGUMENTS

  1. Verify Prerequisites

    • Check gws is installed: gws --version
    • Verify authentication: gws auth status
    • Review available commands: gws sheets-read --help

  2. Inspect Method Schema

    • Before calling any method, inspect its parameters
    • Use gws schema to understand required fields
    • Review parameter types and constraints

  3. Execute Operation

    • Build command with appropriate flags
    • Use --params for query/path parameters
    • Use --json for request body
    • Handle pagination with --max-results or --page-token

  4. Error Handling

    • Check command output for errors
    • Review API quotas and rate limits
    • Handle authentication issues
    • Retry transient failures

License: Apache License 2.0 Source: Google Workspace CLI Original Skill: gws-sheets-read

Reference in New Issue View Git Blame Copy Permalink