google-sheet-api

What This Skill Does

The Google Sheets API skill provides a high-performance, CLI-driven interface for interacting with Google Sheets, designed specifically for automation pipelines and programmatic data management within the OpenClaw environment. Unlike simple integration tools, this skill exposes granular control over spreadsheet resources, including batch operations, complex cell formatting, sheet structural modifications, and raw JSON-based data streaming. It bridges the gap between raw data sources and structured spreadsheet reporting by allowing users to inject, extract, and manipulate cell data directly through CLI commands or automated scripts.

Installation

To integrate this utility into your OpenClaw workflow, use the standard package installer: clawhub install openclaw/skills/skills/codedao12/google-sheet-api

Once installed, ensure your environment is prepared by setting up a Google Cloud Project with the Sheets API enabled. Download your service account JSON key and ensure the service account email has appropriate sharing permissions on your target spreadsheets. You may provide credentials via environment variables such as GOOGLE_SHEETS_CREDENTIALS_JSON or by placing the key in a standard location like ./service-account.json.

Use Cases

• Automated Reporting: Syncing database exports or API results into a centralized spreadsheet for stakeholders.
• Pipeline Formatting: Applying conditional styling or structural layouts (like frozen headers) programmatically after a data dump.
• Batch Data Operations: Managing large-scale updates across multiple tabs or files simultaneously without manual spreadsheet entry.
• CI/CD Integration: Updating project status logs or tracking metrics directly from build scripts using JSON-in/JSON-out workflows.

Example Prompts

1. "Read the data from 'Sheet1!A1:D50' in spreadsheet ID 1abc-123 and output it as JSON for my next pipeline step."
2. "Append the contents of data.json into 'Summary!A:B' for spreadsheet 1abc-123."
3. "Format the header row of 'Sheet1' to have a bold font and a light gray background using the batch update command."

Tips & Limitations

• Security: Never hardcode credentials in your repository. Use environment variables to inject sensitive keys securely at runtime.
• Limits: Be mindful of Google Sheets API rate limits. Implement exponential backoff for 429 status codes to maintain stability.
• Scopes: Adhere to the principle of least privilege. If your task only requires data extraction, configure your service account for read-only access to prevent accidental modifications.
• Complexity: This tool is intended for advanced users. If you only require simple edits, consider standard spreadsheet features instead of this programmatic approach.