google-sheets

What This Skill Does

The google-sheets skill for OpenClaw provides a powerful interface for automating spreadsheet workflows directly through the Google Sheets API. It enables users to read existing data, update specific cell ranges, append new records, manage worksheet structures, and create entire new spreadsheets programmatically. By handling the complexities of RESTful API interactions behind the scenes, this skill allows users to treat Google Sheets as a dynamic database for data logging, report generation, and collaborative document management. Whether you need to push AI-generated analysis into a structured table or pull data for processing, this tool acts as a bridge between OpenClaw and your Google Workspace environment.

Installation

To integrate this skill, run the following command in your terminal:

clawhub install openclaw/skills/skills/mrgoodb/google-sheets

Ensure that you have generated a valid OAuth2 token or service account credential with the appropriate scopes enabled in the Google Cloud Console. Export your token to your environment variables as GOOGLE_ACCESS_TOKEN to allow the agent to authenticate with the API.

Use Cases

• Automated Reporting: Regularly push performance metrics or agent logs into a master tracking sheet for stakeholders.
• Data Aggregation: Collect entries from multiple sources and append them to a centralized ledger for historical record-keeping.
• Workflow Orchestration: Use spreadsheet rows as a task queue, where the agent reads the next available task, processes it, and updates the cell status to 'completed'.
• Content Management: Draft large batches of content in Sheets and have the agent read the range to populate a CMS or social media calendar.

Example Prompts

1. "Open the sheet with ID 1abc-XYZ and append a new row to Sheet1 containing the values: Today, 85, Completed, Urgent."
2. "Read the data from the first ten rows of Sheet1 in my project spreadsheet and summarize the scores in column B."
3. "Create a new spreadsheet titled 'Quarterly Analysis' and clear any existing data in the first tab to prepare for a fresh import."

Tips & Limitations

• Range Formatting: Always ensure the sheet name and range are formatted correctly (e.g., 'Sheet1!A1:D10'). Mismatched sheet names will result in API errors.
• API Quotas: Be mindful of Google's rate limits on the Sheets API, especially when performing high-frequency updates or batch operations.
• Permissions: Ensure the account associated with your GOOGLE_ACCESS_TOKEN has 'Editor' access to the specific spreadsheet ID you are targeting.
• Data Validation: While the valueInputOption=USER_ENTERED setting allows you to input strings that look like formulas, exercise caution to avoid injecting unwanted or malformed logic into your sheets.