google-sheets
Read, write, append, and manage Google Sheets via the Google Sheets API (Node.js SDK). Use when you need to interact with spreadsheets — reading data, writing/updating cells, appending rows, clearing ranges, formatting cells, managing sheets. Requires a Google Cloud service account with Sheets API enabled.
Why use this skill?
Automate your spreadsheet tasks with the OpenClaw Google Sheets skill. Read, write, format, and manage your Google Sheets data directly through the AI agent.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/longmaba/google-sheetWhat This Skill Does
The google-sheets skill acts as a bridge between the OpenClaw AI agent and the Google Sheets API. It provides a comprehensive command-line interface for performing CRUD operations on spreadsheets, managing sheet structures, and applying complex visual formatting. Whether you are automating data entry, generating reports, or styling dashboards programmatically, this skill enables full programmatic control over Google Sheets files using a Node.js-based infrastructure. It handles authentication securely via Google Cloud service accounts, allowing the agent to perform headless operations on any sheet shared with the service account's email address.
Installation
To install this skill, run the command clawhub install openclaw/skills/skills/longmaba/google-sheet in your terminal. Ensure that you have a Google Cloud Project with the Sheets API enabled. After downloading your service account JSON key, configure the authentication by setting the GOOGLE_SERVICE_ACCOUNT_KEY environment variable to the path of your key file. Finally, navigate to the installed directory and run npm install to resolve all necessary Node.js dependencies.
Use Cases
- Automated Reporting: Periodically fetch data from a database and write it directly into a tracking spreadsheet.
- Data Formatting: Automatically style weekly sales reports by applying bold text and background colors to headers and threshold-crossing rows.
- Spreadsheet Management: Create new tabs, rename existing sheets, or merge cell ranges based on dynamic user input or file processing triggers.
- Batch Data Updates: Bulk append rows to existing logs or clear out historical ranges to maintain clean data sets.
Example Prompts
- "Read the data from 'Sheet1!A1:D50' in spreadsheet '1abc123...' and summarize the trends found in the sales figures."
- "Append a new row to the 'Transactions' sheet in my budget tracker with today's date, the label 'Coffee', and the amount '5.50'."
- "Apply a yellow background and bold font to the headers in the first row of my inventory spreadsheet, then auto-resize the columns to fit the content."
Tips & Limitations
- Permissions: Always ensure the Google Sheet is shared with the specific email found in your service account JSON file; otherwise, the API will return a 403 Forbidden error.
- Rate Limits: Be mindful of Google API rate limits if you are processing hundreds of operations in a short period.
- Security: Treat your service account JSON file as a sensitive credential. Never commit it to public repositories.
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-longmaba-google-sheet": {
"enabled": true,
"auto_update": true
}
}
}Tags(AI)
Flags: network-access, file-read, external-api