An atomic automation node designed to append data rows to Google Sheets via the gog CLI.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install google-sheets-append-row
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-sheets-append-row 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 Append Row?
The Google Sheets Append Row skill is a lean, standardized automation node designed for seamless data integration. Built on the principles of Kaizen and Jidoka, this skill allows AI agents to interact directly with spreadsheets using the gog command-line interface. It focuses on eliminating waste by providing an atomic, single-purpose function that ensures high reliability and error detection within Openclaw Skills environments.
By leveraging native terminal commands, this skill facilitates fast and efficient data entry without the overhead of complex API wrappers. It represents a standardized path for data manipulation, ensuring that every append operation is executed with precision and provides immediate feedback for autonomous defect detection.
Google Sheets Append Row Use Cases
- Logging system events or monitoring data into a central spreadsheet for real-time tracking.
- Updating sales leads or customer contact information directly from a terminal or agent workflow.
- Archiving automated test results or build logs for team review and historical analysis.
- Collecting user feedback or form submissions into a structured Google Sheets format.
How Google Sheets Append Row Works
- The AI agent identifies a requirement to append new data rows to a specific Google Sheet spreadsheet.
- The agent constructs a command containing the spreadsheet ID, the target range (e.g., Tab1!A:C), and the row values in JSON format.
- The skill executes the native
gog sheets appendcommand through the system terminal. - The gog CLI processes the request and communicates with the Google Sheets API to insert the data.
- The skill returns a JSON object confirming the operation, allowing for self-healing loops within Openclaw Skills if a failure is detected.
Google Sheets Append Row Setup
To use this skill, ensure that the gog CLI is installed on your system and properly authenticated with your Google account.
# Verify the gog binary is available in your PATH
gog --version
# Example of the command structure used by the skill
gog sheets append <spreadsheetId> <range> --values-json '[[ "Value1", "Value2" ]]' --json
Ensure the agent has the necessary environment permissions to execute shell commands and access the target Google Sheet.
Google Sheets Append Row Data Schema & Taxonomy
The skill utilizes a structured command-line interface to pass data. The following parameters are essential for the operation:
| Parameter | Description |
|---|---|
| spreadsheetId | The unique identifier found in the Google Sheet URL. |
| range | The specific tab and column range, such as "Sheet1!A:E". |
| values-json | A nested JSON array representing the rows and columns to be inserted. |
| --json | A flag that forces the CLI to return the result as a parseable JSON object. |
The output is a JSON object confirming the range updated and the number of rows appended.
Google Sheets Append Row Advanced Features
- Autonomous defect detection following Jidoka principles to report failed append operations.
- Atomic node design for inclusion in complex Openclaw Skills automation pipelines.
- Support for multi-column data insertion using standard JSON array formatting.
- Efficient execution through native CLI commands, reducing memory overhead compared to full SDKs.
SKILL.md
Loading
Related Openclaw Skills
Amazon AppConfig Skill
A comprehensive Openclaw Skills integration for managing Amazon AppConfig resources, deployments, and extensions via a 45-endpoint API interface.
UUID Generator
A versatile utility for generating cryptographically random, time-based, or namespace-based UUIDs in multiple formats.
Markdown to Slides
A streamlined CLI utility for converting Markdown documents into beautiful, themed PowerPoint presentations.
Elastic Observability and Search Skill
A comprehensive skill for mastering the Elastic ecosystem, from distributed search to full-stack observability and AI-driven data analysis.
Amazon API Gateway Skill for AI Agents
A comprehensive automation skill for managing Amazon API Gateway resources including REST APIs, API keys, usage plans, and deployments through 120 specialized endpoints.
AltoroJ REST API Skill
A comprehensive Openclaw Skills integration for interacting with the AltoroJ banking REST API to manage accounts, transfers, and administrative tasks.
Featured*
