google-workspace

What This Skill Does

The google-workspace skill, known as gog, acts as a powerful command-line interface for the Google Workspace ecosystem. It allows your OpenClaw agent to interact directly with your Gmail, Calendar, Drive, Contacts, Sheets, and Docs. Whether you need to automate email management, retrieve calendar events, query data from spreadsheets, or download document contents, this tool bridges the gap between your local terminal and your cloud-based data. By leveraging this skill, you can turn your AI agent into a personal assistant that manages your daily operations and data processing tasks securely through OAuth-based authentication.

Installation

To install this skill, run the following command in your terminal: clawhub install openclaw/skills/skills/zaycv/google-workspace. Once installed, you must perform a one-time setup:

1. Run gog auth credentials /path/to/client_secret.json to configure your API access.
2. Execute gog auth add [email protected] --services gmail,calendar,drive,contacts,sheets,docs to link your Google account and specify required scopes.
3. Verify your configuration with gog auth list. For convenience, set the environment variable [email protected] to prevent repetitive command-line flags.

Use Cases

• Automated Reporting: Periodically fetch data from a Google Sheet, process the numbers, and email a summary to stakeholders.
• Calendar Management: Audit your schedule by querying upcoming events and cross-referencing them with meeting notes stored in Google Docs.
• Content Processing: Archive old emails or export important documents to local formats like .txt for archival or long-term storage.
• Data Synchronization: Sync contacts or update CRM sheets programmatically without manual browser interaction.

Example Prompts

1. "Check my Gmail for any new messages received in the last 24 hours from my manager and summarize the content for me."
2. "Look at the spreadsheet with ID 'xyz123' and append a new row to it with today's date and the latest inventory count I just provided."
3. "Export the content of my project proposal document (ID: 'doc-987') to a local file at /tmp/proposal.txt so I can share it via Slack."

Tips & Limitations

• Efficiency: Always use the --json flag when scripting or automating workflows to ensure machine-readable outputs.
• In-place Editing: Note that this skill is primarily for reading or appending data to Docs; it does not support complex in-place document editing. Use it for export or basic retrieval.
• Security: Always confirm sensitive actions like sending emails or creating calendar events to prevent unintended consequences.
• Recommendations: Use --values-json instead of inline rows for Sheets operations to avoid parsing errors with complex strings.