gog

What This Skill Does

The gog skill is a powerful command-line interface (CLI) for Google Workspace, acting as a bridge between your terminal and the Google ecosystem. It allows OpenClaw AI agents to programmatically interact with Gmail, Google Calendar, Google Drive, Google Contacts, Google Sheets, and Google Docs. By leveraging OAuth 2.0, the skill enables secure, authenticated access to your cloud data, allowing for automated management of emails, calendar scheduling, file retrieval, and spreadsheet manipulation. It is designed for both interactive use and automated scripting workflows, providing a standardized interface for complex operations across the Google suite.

Installation

To integrate this skill into your environment, use the OpenClaw installer: clawhub install openclaw/skills/skills/jacobo-create/backup-gog-20260213-121122. Once installed, perform the mandatory setup: initialize credentials via gog auth credentials /path/to/client_secret.json and authenticate your specific account with gog auth add [email protected] --services gmail,calendar,drive,contacts,sheets,docs. Setting the environment variable [email protected] is highly recommended to streamline commands.

Use Cases

• Automated Reporting: Periodically fetch data from specific cells in Google Sheets and email the findings via Gmail.
• Data Pipeline Integration: Update spreadsheet logs programmatically by appending row data based on external tool outputs.
• Content Management: Export Google Docs to local formats or read document content to feed into AI summarization tasks.
• Schedule Management: Query calendar events for specific date ranges to provide summaries or check availability.
• File Discovery: Quickly locate files within Google Drive using search queries to facilitate further analysis.

Example Prompts

1. "Search my Gmail for emails from the last 7 days regarding the project proposal and list the top 5."
2. "Update my project tracking spreadsheet by appending a new row with today's status update: 'Completed', 'Task A', 'John'."
3. "Export the document with ID '1abc-123' to a text file saved at /tmp/summary.txt and print its content."

Tips & Limitations

For scripting scenarios, always use the --json flag combined with --no-input to prevent the CLI from hanging on interactive prompts. Note that gog is focused on data retrieval and specific write operations; in-place editing of Google Docs is not supported and requires dedicated API clients. Always be cautious when using write-heavy commands like sheets update or gmail send. The skill requires manual confirmation for sensitive actions like mailing or scheduling, ensuring that the AI agent does not perform unintended actions without your explicit oversight.