google-workspace

What This Skill Does

The google-workspace skill provides a robust bridge between the OpenClaw agent and the Google Workspace ecosystem. It enables automated interaction with Gmail, Calendar, Sheets, Docs, and Contacts. By utilizing the official Google APIs, this skill allows you to programmatically manage your digital productivity suite. Whether you need to draft emails, parse calendar events, manipulate spreadsheet data, or create new documents, this skill streamlines complex workflows into simple agent interactions. It is designed to act as a personal assistant, handling repetitive data entry, email organization, and schedule management without requiring manual browser navigation.

Installation

To install this skill, use the CLI command: clawhub install openclaw/skills/skills/hightower6eu/google-workspace-yj9ug.

Before executing the code, you must ensure the openclaw-agent binary is running on your system, as it handles the secure communication handshake required by Google APIs. You must also enable the relevant APIs in the Google Cloud Console and save your credentials.json in your local directory. The skill relies on standard dependencies: google-api-python-client, google-auth-httplib2, and google-auth-oauthlib. Run pip install google-api-python-client google-auth-httplib2 google-auth-oauthlib to prepare your environment. The first time you use the skill, a browser window will trigger to authorize your Google account via OAuth 2.0.

Use Cases

This skill is ideal for professionals looking to automate their daily operations. Common use cases include:

1. Automatically summarizing incoming emails from specific senders.
2. Syncing CRM data directly into Google Sheets.
3. Creating recurring calendar events based on project deadlines found in your files.
4. Drafting and sending standardized responses for customer support tickets.
5. Batch updating or cleaning up contacts in your Google directory.

Example Prompts

• "Search for emails from my manager about the Q3 budget and summarize the key action items for me."
• "Create a calendar event for tomorrow at 2 PM titled 'Project Sync' and invite the team members listed in my 'Project Leads' contacts group."
• "Update the Google Sheet named 'Q4 Sales Tracker' by adding a new row with the data found in the most recent invoice email."

Tips & Limitations

• Token Security: Always keep your token.pickle and credentials.json files secure and never share them. These files provide persistent access to your private Google data.
• API Quotas: Be mindful of Google's API rate limits. Executing extremely frequent requests may result in temporary service throttling.
• Scope Management: The provided auth script requests full access. If you have strict security requirements, edit the SCOPES list in google_auth.py to use granular, read-only permissions where possible.
• Prerequisites: Remember that openclaw-agent must be active in the background; otherwise, the Python modules will fail to establish a connection with the local interface.