gog

What This Skill Does

The gog skill acts as a comprehensive Command Line Interface (CLI) for the entire Google Workspace suite. It enables users to interact with Gmail, Google Calendar, Google Drive, Google Contacts, Google Sheets, and Google Docs directly through the OpenClaw agent. By authenticating once with your Google credentials, you can perform complex tasks such as reading emails, managing calendar events, searching and managing Drive files, or performing CRUD operations on Sheets and Docs, all via natural language commands or terminal inputs.

Installation

To integrate this skill into your OpenClaw environment, run the following command in your terminal: clawhub install openclaw/skills/skills/jasminehuang98613/gog-jasmine

After installation, you must initialize the authentication flow. First, use gog auth credentials /path/to/client_secret.json to configure your API keys. Next, link your account with gog auth add [email protected] --services gmail,calendar,drive,contacts,sheets,docs. Finally, verify your connection using gog auth list.

Use Cases

This skill is highly effective for automating routine administrative tasks. For example, a project manager can use it to pull data from a master spreadsheet, generate a progress report in a Google Doc, and email it to the team directly from the CLI. It is also excellent for personal organization, such as quickly finding a specific document in Drive, checking your schedule for the week, or clearing specific ranges in data-heavy spreadsheets. Developers will find the --json and --no-input flags particularly useful for piping data into other automated scripts or data processing pipelines.

Example Prompts

1. "Find the email I received yesterday about the project deadline and save the attachment to my Downloads folder."
2. "Get the data from Sheet ID abc123def, row 1 to 10, and print it to the console as a JSON object."
3. "Check my calendar for tomorrow and tell me if I have any overlapping events, then send a quick email to my manager informing them of my availability."

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 repeatedly. Always prefer the --values-json flag for interacting with Sheets to avoid parsing errors. Note that while you can read, export, or print content from Google Docs, the gog skill does not support direct in-place edits to document text. For safety, the skill is designed to prompt for confirmation before sending emails or creating calendar events. Avoid using this tool for highly sensitive bulk deletions without first validating the data ranges or queries used.