gws-sheets

What This Skill Does

The gws-sheets skill serves as the primary gateway for OpenClaw to interact with the Google Sheets API (v4). It provides a robust command-line interface to read, write, and manipulate spreadsheet data directly within your agent workflow. By abstracting the complexity of the Google Sheets REST API, this skill allows users to perform CRUD operations on spreadsheets, manage sheet metadata, and execute batch updates with ease. Whether you need to extract data for analysis, automate reporting by appending rows, or manage the structure of your sheets, gws-sheets bridges the gap between your data and the OpenClaw AI.

Installation

To integrate this skill into your environment, use the OpenClaw CLI package manager. Ensure your workspace is initialized and your Google Workspace credentials are configured according to the gws-shared documentation. Run the following command in your terminal:

clawhub install openclaw/skills/skills/googleworkspace-bot/gws-sheets

Once installed, verify the connection by running gws sheets --help to list available resources and methods.

Use Cases

This skill is designed for high-efficiency data management tasks. Common use cases include:

• Automated Reporting: Periodically updating a master spreadsheet with new metrics or logs using the append helper.
• Data Analysis Pipeline: Fetching specific grid data from complex spreadsheets to be processed by OpenClaw’s logic or external analysis tools.
• Spreadsheet Management: Creating new sheets programmatically for project tracking or inventory management.
• Metadata Synchronization: Using developer metadata methods to track specific versioning or tagging information directly within the cell or sheet structures.

Example Prompts

1. "Find the spreadsheet with the ID '1abc-123' and read the data from the 'Sales' tab."
2. "Append the latest Q3 financial results from the text file to the spreadsheet '2023_Financials'."
3. "Create a new Google Sheet named 'Q4 Project Tracker' and share it with the team email address."

Tips & Limitations

• Field Masks: When using the get method, always specify a field mask. Requesting the entire spreadsheet structure can lead to excessive data transfer if your sheet is large.
• Batching: Use batchUpdate for multiple modifications to minimize API overhead and ensure transactional integrity—if one update in a batch fails, the entire request reverts.
• Permissions: Ensure the service account or user profile used for authentication has the correct scope (e.g., spreadsheets.readonly vs spreadsheets) to avoid permission errors.
• Discovery: Always use gws schema sheets.<resource>.<method> before writing complex JSON payloads to verify expected types and parameter names.