gogifocus

What This Skill Does

The gogifocus skill provides a powerful command-line interface (CLI) for interacting with the Google Workspace ecosystem directly through OpenClaw. It serves as a unified bridge to Gmail, Google Calendar, Google Drive, Google Contacts, Google Sheets, and Google Docs. By leveraging OAuth authentication, it allows the AI agent to perform complex administrative and data-processing tasks, such as searching through thousands of emails, parsing data from complex spreadsheets, managing calendar events, or extracting text content from documents, all without needing to open a browser window. It is designed to be highly scriptable, making it an essential tool for automating workflows that span multiple Google services.

Installation

To integrate this skill into your environment, use the OpenClaw repository manager. Execute the following command in your terminal: clawhub install openclaw/skills/skills/ifocus1776/gogifocus

Once installed, you must perform the one-time OAuth configuration:

1. Obtain your client_secret.json from the Google Cloud Console.
2. Run gog auth credentials /path/to/client_secret.json.
3. Authorize your account: gog auth add [email protected] --services gmail,calendar,drive,contacts,sheets,docs.
4. Verify your setup with gog auth list.

Use Cases

This skill is perfect for high-velocity data management and communication automation. Common use cases include: summarizing emails from the last week for a briefing; syncing data between local databases and Google Sheets; batch-updating rows in a shared spreadsheet based on conditional logic; searching for specific files in Drive to extract information; and exporting Google Docs content into local text files for further processing.

Example Prompts

1. "Check my emails from the last 7 days and summarize any messages about the project launch."
2. "Append the latest sales figures from the CSV to the 'Reports' sheet in my 'Sales Tracker' document."
3. "List all calendar events for today and export the details of the first event to /tmp/today_plan.txt."

Tips & Limitations

To maximize efficiency, set the GOG_ACCOUNT environment variable to skip the --account flag in every command. For automated pipelines, always utilize --json and --no-input to ensure output is machine-readable and to prevent the agent from hanging on prompt blocks. Note that Google Docs editing is limited to export/cat/copy; in-place document modification is not supported via this interface. Always exercise caution with the gmail send and calendar creation commands, as these execute external actions that cannot be undone. Be mindful of Google's API rate limits when performing large bulk operations on Sheets or Drive.