google-sheet-api

What This Skill Does

The google-sheet-api skill for OpenClaw provides a powerful, production-ready Command Line Interface (CLI) to interact with Google Sheets. Built specifically for developers and automation engineers, this skill enables seamless integration between your data pipelines and Google Sheets. It supports advanced features including bulk data read/writes, cell formatting, sheet management (creating, renaming, deleting), and granular batch updates. By utilizing Google service account authentication, it allows for secure, non-interactive authentication suitable for headless environments, CI/CD pipelines, and automated server-side reporting tasks. It is designed to handle JSON-in/JSON-out workflows, making it highly compatible with modern data processing architectures.

Installation

To integrate this skill into your OpenClaw environment, execute the installation command: clawhub install openclaw/skills/skills/codedao12/google-sheets-api. Once installed, navigate to the local directory where the skill resides and run npm install to resolve all necessary dependencies. Ensure you have your Google Cloud service account JSON key ready, as the skill requires valid credentials to interface with the Google Sheets API. You can manage credentials via environment variables such as GOOGLE_APPLICATION_CREDENTIALS or by placing the file in one of the predefined lookup paths.

Use Cases

• Automating report generation where raw JSON data is converted into formatted spreadsheets.
• Synchronizing CRM data or inventory logs with team-facing dashboards.
• Batch processing updates across multiple tabs or large datasets without browser-based manual entry.
• Applying visual styles and formatting programmatically to maintain brand consistency in exported reports.
• Integrating Google Sheets into headless backend workflows for lightweight database storage.

Example Prompts

1. "OpenClaw, read the first 50 rows from Sheet1 in spreadsheet ID '1abc123' and save the result to data.json."
2. "Use the google-sheet-api to append the contents of ./new_records.json to the 'Sales' tab in spreadsheet '1abc123'."
3. "Format the range 'A1:D1' in sheet 'ProjectTracker' to have bold text and a light blue background using the google-sheet-api."

Tips & Limitations

This skill is optimized for service account usage; it is not intended for end-user OAuth consent flows. Keep your payload sizes modest to avoid hitting API rate limits, and implement exponential backoff logic if you are running massive batch jobs. Always prioritize read-only scopes when performing analysis tasks to maintain the principle of least privilege. Never store service account keys in your version control system; utilize environment variables or secure vault storage.