A robust tool for automating Google Sheets operations including data management, formatting, and layout control via the Google Sheets API.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install google-sheet
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install google-sheet using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Google Sheets?
The Google Sheets skill for Openclaw Skills provides a powerful interface for AI agents to interact directly with spreadsheets using the Google Sheets API. By leveraging a Node.js SDK and service account authentication, this tool enables programmatic reading, writing, and management of spreadsheet data without manual intervention.
This integration is particularly valuable for developers looking to incorporate structured data storage or retrieval into their AI workflows. Whether you are building an automated reporting system or a data-driven AI agent, this extension for Openclaw Skills offers the technical depth required to handle complex spreadsheet tasks like cell formatting, sheet management, and bulk data operations.
Google Sheets Use Cases
- Programmatically reading data ranges for AI-driven analysis.
- Appending logs, research findings, or generated content to existing spreadsheets.
- Automating spreadsheet layout tasks like freezing rows or auto-fitting columns.
- Managing multiple sheet tabs and metadata within a single spreadsheet file.
- Applying professional formatting and borders to generated data reports.
How Google Sheets Works
- The skill authenticates with the Google Sheets API using a pre-configured Google Cloud service account key.
- Users or agents issue commands via a CLI interface to target specific Spreadsheet IDs.
- The skill processes the request, translating it into the appropriate Google API call (e.g., spreadsheets.values.get or spreadsheets.batchUpdate).
- Data is exchanged in JSON format, allowing for structured input and output of cell values and formatting properties.
Google Sheets Setup
- Google Cloud Console Setup: Enable the Google Sheets API and create a Service Account to download a JSON key.
- Credential Configuration: Provide the key via the
GOOGLE_SERVICE_ACCOUNT_KEYenvironment variable or placeservice-account.jsonin the skill directory. - Permission Management: Share your target Google Sheets with the
client_emailfound in your service account JSON. - Dependency Installation:
cd skills/google-sheets && npm install
Google Sheets Data Schema & Taxonomy
The skill utilizes standard Google Sheets identifiers and A1 notation for data organization:
| Attribute | Description |
|---|---|
| Spreadsheet ID | The unique string found in the sheet URL: /d/SPREADSHEET_ID/edit |
| Range | A1 notation (e.g., Sheet1!A1:C10) used to target specific cells |
| JSON Data | Input values provided as nested arrays (e.g., [["Row1Col1", "Row1Col2"]]) |
| Format Objects | JSON schemas defining colors, text styles, and alignment properties |
Google Sheets Advanced Features
- Multi-tab management including adding, renaming, and deleting sheets within a workbook.
- Granular formatting controls for background colors, text styles, and alignment.
- Advanced layout commands for merging cells, freezing panes, and manual or auto-resizing of columns and rows.
- Efficient format duplication using the
copyFormatcommand to sync styles across ranges.
SKILL.md
Loading
Related Openclaw Skills
Facebook Page Manager
A powerful Openclaw Skills tool for automating Facebook Page posts, comment management, and engagement via the Meta Graph API.
WordCount
A high-performance bash utility for calculating precise line, word, character, and byte counts with full support for CJK text.
Korail Manager
A powerful automation skill for searching, watching, and reserving Korail and SRT train tickets in South Korea.
Korail Manager
An automation tool for searching, watching, and booking KTX and SRT train tickets with integrated notification support.
Poe Chat
A versatile skill that triggers specific Poe models using simple @ tags with automatic model selection and file upload capabilities.
Report PPT Generator Pro
An AI-driven presentation engine that converts text manuscripts into professional, style-matched PowerPoint decks with AI illustrations and interactive previews.
Featured*
