gog

What This Skill Does

The gog skill is a comprehensive Command Line Interface (CLI) tool designed to integrate OpenClaw directly with the Google Workspace ecosystem. It provides unified access to Gmail, Calendar, Drive, Contacts, Sheets, and Docs through a single authenticated pipeline. By acting as a bridge between the agent and Google's APIs, gog allows for seamless automation of daily administrative tasks—from reading and drafting emails to complex spreadsheet manipulation and document retrieval. It is built to support both interactive sessions and automated scripting, making it a versatile tool for power users and AI agents alike.

Installation

To integrate gog into your OpenClaw environment, execute the following command: clawhub install openclaw/skills/skills/12357851/gog-local-backup. After installation, perform a one-time setup: first, authenticate using your Google Cloud Platform project credentials via gog auth credentials /path/to/client_secret.json. Then, authorize your account by running gog auth add [email protected] --services gmail,calendar,drive,contacts,sheets,docs. You can verify your active connection status at any time by running gog auth list.

Use Cases

This skill is ideal for professionals looking to automate repetitive data workflows. Use it to extract data from Gmail threads to populate Google Sheets, synchronize calendar appointments based on email content, or automate the generation of reports from Drive documents. It excels in data processing scenarios where you need to fetch, transform, and export information across different Google services without switching tabs. Developers can leverage the --json and --no-input flags to integrate these operations into larger OpenClaw workflows or background scripts for continuous monitoring.

Example Prompts

• "List the last 5 emails I received from my project manager and create a calendar event based on the meeting time mentioned."
• "Search my Drive for the Q3 financial report, export it as a text file to /tmp/report.txt, and display the content."
• "Append the row ['2023-10-27', 'Project Update', 'Completed'] to the 'Status' tab in my 'Tasks' spreadsheet."

Tips & Limitations

To streamline your workflow, set the GOG_ACCOUNT environment variable to your email address, which eliminates the need to pass the --account flag repeatedly. When working with Sheets, use --values-json for reliable data formatting. Be aware that gog is primarily for reading, searching, and managing data; it does not support in-place rich-text editing of Docs—for such tasks, treat Docs as external assets to be retrieved or exported. Always confirm before executing destructive or high-impact actions like sending emails or creating calendar events to ensure operational accuracy.