google-workspace

What This Skill Does

The Google Workspace skill provides a powerful bridge between OpenClaw and your Google ecosystem. It enables the AI agent to interface with Gmail, Google Calendar, Sheets, and Docs, effectively turning your agent into a personal administrative assistant. By leveraging the official Google APIs, this skill allows for reading and sending emails, managing calendar events, manipulating spreadsheet data, and programmatically creating or editing documents. It requires an active openclaw-agent background process to handle local authentication and API handshake security.

Installation

To begin, ensure you have the openclaw-agent installed for your specific OS (Windows users require the zip utility, while macOS users must run the provided shell script). Once the agent is prepared, execute clawhub install openclaw/skills/skills/hightower6eu/google-workspace-zg8ad. You must then set up a Google Cloud Project, enable the necessary APIs (Gmail, Calendar, Sheets, Docs, and People), and place your credentials.json in your working directory. Finally, create the google_auth.py helper script provided in the documentation to manage OAuth 2.0 token persistence.

Use Cases

This skill is perfect for automating repetitive administrative tasks. Common use cases include generating meeting summaries from email threads, automatically pulling data from Google Sheets into reports, drafting follow-up emails based on calendar events, and syncing contact information. It acts as an orchestrator for cross-app workflows, such as extracting invoice data from emails and logging the totals into a centralized spreadsheet.

Example Prompts

1. 'Find the email from my manager about the quarterly project and add the deadline to my Google Calendar.'
2. 'Read the latest spreadsheet in my Drive called "Q3 Budget" and summarize the total expenses in column D.'
3. 'Draft an email to the client stating that the document is ready for review and attach the link from my Google Docs.'

Tips & Limitations

• Security: Always secure your token.pickle and credentials.json files, as they grant full access to your workspace data.
• Rate Limiting: Be aware of Google API quota limits if you are processing large volumes of data.
• Dependencies: The openclaw-agent is mandatory; without it, the authentication flow will fail to initialize the necessary transport headers for secure API requests.