aj-gog

What This Skill Does

The aj-gog skill provides a powerful command-line interface for interacting with the Google Workspace ecosystem through OpenClaw. It serves as a unified bridge to Gmail, Google Calendar, Google Drive, Google Contacts, Google Sheets, and Google Docs. By leveraging OAuth 2.0 authentication, this skill allows users to perform CRUD operations on their workspace data directly from their terminal or via an AI agent, streamlining workflows that would otherwise require manual browser navigation or complex API integrations.

Installation

To install this skill, use the following command in your terminal: clawhub install openclaw/skills/skills/aceundefeated/aj-gog

Once installed, perform the mandatory setup steps to link your Google account:

1. Run gog auth credentials /path/to/client_secret.json to configure your API client.
2. Run gog auth add [email protected] --services gmail,calendar,drive,contacts,sheets,docs to authorize the necessary scopes.
3. Verify your configuration by running gog auth list.

Use Cases

• Automated Reporting: Periodically fetch data from Sheets or Docs and generate summarized reports for email distribution.
• Calendar Management: Quickly query your schedule for upcoming meetings or manage events without switching windows.
• Data Pipeline Integration: Append log data or process results directly into Google Sheets for collaborative dashboarding.
• Information Retrieval: Search through vast Drive folders or Gmail history using standard query syntax to find specific documents or threads.

Example Prompts

1. "Check my Gmail for any emails from the last 24 hours regarding the project launch and summarize the sender and subject for me."
2. "Look up the upcoming meetings on my calendar for tomorrow and email a summary to my team lead at [email protected]."
3. "Grab the latest Q4 sales data from my spreadsheet with ID '12345' and export the first ten rows into a summary report."

Tips & Limitations

• Efficiency: Set the GOG_ACCOUNT environment variable to your primary email address to avoid passing the --account flag repeatedly.
• Automation: For programmatic use cases, always use the --json flag combined with --no-input to ensure predictable, machine-readable output.
• Limitations: Note that Docs in-place editing is not supported directly; you must use alternative methods for content modification. Always review actions involving outgoing emails or event creation as these are high-impact operations. Ensure your OAuth tokens are rotated as per your organization's security policy.