google-sheets-apiOpenClaw skill that installs a Google Sheets CLI with setup steps and commands for read/write, batch, formatting, and sheet management.
Install via ClawdBot CLI:
clawdbot install codedao12/google-sheets-apiProvide a production-ready Google Sheets CLI for OpenClaw. This skill supports data reads/writes, batch operations, formatting, and sheet management with service account authentication.
cd google-sheet-api
npm installnode scripts/sheets-cli.js help
node scripts/sheets-cli.js read <spreadsheetId> "Sheet1!A1:C10"
node scripts/sheets-cli.js append <spreadsheetId> "Sheet1!A:B" '@data.json'You can also use npm:
npm run sheets -- read <spreadsheetId> "Sheet1!A1:C10"Supported sources (first match wins):
GOOGLE_SHEETS_CREDENTIALS_JSON (inline JSON string)GOOGLE_SERVICE_ACCOUNT_KEY (file path)GOOGLE_SHEETS_KEY_FILE (file path)GOOGLE_APPLICATION_CREDENTIALS (file path)./service-account.json, ./credentials.json, ./google-service-account.json~/.config/google-sheets/credentials.json@path.Example data.json:
[["Name","Score"],["Alice",95]]Data:
read, write, append, clear, batchGet, batchWriteFormatting:
format, getFormat, borders, merge, unmerge, copyFormatLayout:
resize, autoResize, freezeSheets:
create, info, addSheet, deleteSheet, renameSheetAdvanced:
batch (raw spreadsheets.batchUpdate requests)429 and transient 5xx errors.Generated Mar 1, 2026
A finance team uses this skill to automatically pull quarterly sales data from a Google Sheet, generate formatted reports, and update dashboards. It enables batch updates for multiple spreadsheets at once, ensuring consistency and saving hours of manual work.
A retail business integrates this skill to read inventory levels from a Google Sheet, append new stock entries via JSON input, and apply formatting to highlight low-stock items. This automates stock tracking and reduces errors in manual data entry.
A marketing agency uses this skill to batch-write customer survey responses from various sources into a central Google Sheet. It formats the data for analysis and creates new sheets for different campaigns, streamlining feedback processing.
A project management team employs this skill to read task lists from a Google Sheet, append completed tasks via CLI commands, and resize columns for better visibility. This supports agile workflows with minimal manual intervention.
A school administration uses this skill to write student grades from assessment systems into a Google Sheet, apply formatting for performance tiers, and manage multiple class sheets. It ensures accurate, up-to-date records for reporting.
A company offers this skill as part of a subscription-based service that integrates Google Sheets with other business tools via APIs. They charge monthly fees for automation features, targeting small to medium enterprises needing streamlined data workflows.
A consultancy firm uses this skill to provide tailored automation solutions for clients, such as custom CLI scripts for specific Google Sheets operations. They bill on a project or hourly basis, focusing on industries like finance or logistics.
A developer creates a freemium tool based on this skill, offering basic read/write functions for free and charging for advanced features like batch updates or formatting. Revenue comes from premium upgrades and enterprise licenses.
💬 Integration Tip
Ensure service account keys are securely stored in environment variables and share spreadsheets only with the required email to maintain security and avoid access issues.
Google Workspace CLI for Gmail, Calendar, Drive, Contacts, Sheets, and Docs.
Query Google Places API (New) via the goplaces CLI for text search, place details, resolve, and reviews. Use for human-friendly place lookup or JSON output for scripts.
Search for places (restaurants, cafes, etc.) via Google Places API proxy on localhost.
Gmail, Calendar, Drive, Docs, Sheets — NO Google Cloud Console required. Just OAuth sign-in. Zero setup complexity vs traditional Google API integrations.
Google Drive API integration with managed OAuth. List, search, create, and manage files and folders. Use this skill when users want to interact with Google D...
Google Sheets API integration with managed OAuth. Read and write spreadsheet data, create sheets, apply formatting, and manage ranges. Use this skill when users want to read from or write to Google Sheets. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).