A comprehensive automation tool for managing Gmail, Calendar, Drive, and Sheets through the Openclaw Skills framework.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install fr3k-google-workspace
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install fr3k-google-workspace using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Google Workspace Automation?
This skill enables deep integration with the Google Workspace ecosystem, allowing developers and AI agents to interact with professional tools programmatically. By leveraging Openclaw Skills, you can bridge the gap between autonomous agents and core productivity apps, facilitating automated communication, data management, and scheduling without manual intervention. It utilizes the official Google API Python client to ensure secure and reliable access through Service Accounts or OAuth2 authentication.
Whether you need to send automated reports via Gmail, sync project deadlines to Google Calendar, or manage large-scale data in Google Sheets, this skill provides the necessary interface to do so efficiently. It is designed to be a foundational component for any developer looking to build advanced workflows within the Openclaw Skills ecosystem.
Google Workspace Automation Use Cases
- Automated email reporting and personalized draft generation via Gmail.
- Synchronizing project milestones and team standups with Google Calendar events.
- Programmatic data entry, retrieval, and append operations for Google Sheets analytics.
- Managing document storage, file uploads, and granular sharing permissions within Google Drive.
- Advanced search and filtering across massive email inboxes or drive directories using AI-driven queries.
How Google Workspace Automation Works
- The skill authenticates with Google Cloud using either a Service Account JSON string or OAuth credentials stored in environment variables.
- Users or AI agents issue commands via the python script to target specific services like Gmail, Drive, Calendar, or Sheets.
- The skill processes command-line arguments (such as file IDs, search queries, or event timestamps) and sends authorized requests to the Google API.
- Results, including message bodies, file metadata, or spreadsheet ranges, are returned in a structured format.
- This structured data is then ready for further automation or processing within the broader Openclaw Skills architecture.
Google Workspace Automation Setup
To get started with this skill in Openclaw Skills, follow these installation steps:
- Install the required Python dependencies:
pip install google-api-python-client google-auth google-auth-httplib2
- Configure your authentication. For automation, a Service Account is recommended. Export your JSON key as an environment variable:
export GOOGLE_SERVICE_ACCOUNT_JSON='{"type":"service_account", ...}'
- Alternatively, if using OAuth, set the paths to your credentials and token files:
export GOOGLE_CREDENTIALS_FILE="/path/to/credentials.json"
export GOOGLE_TOKEN_FILE="/path/to/token.json"
- Ensure you have enabled the Gmail API, Calendar API, Drive API, and Sheets API in your Google Cloud Console.
Google Workspace Automation Data Schema & Taxonomy
The skill interacts with the Google API using standard data structures. Below is how the data is organized across different services:
| Service | Data Entities | Metadata Managed |
|---|---|---|
| Gmail | Messages, Labels, Drafts | Thread IDs, Labels, To/From headers |
| Calendar | Events, ACLs | RFC3339 Timestamps, Timezones |
| Drive | Files, Folders | File IDs, MimeTypes, Permissions |
| Sheets | Values, Ranges | A1 Notation, Append logic |
All interactions within Openclaw Skills are designed to return clean JSON that can be piped into other scripts or parsed by language models.
Google Workspace Automation Advanced Features
- Support for Domain-Wide Delegation to allow service accounts to impersonate workspace users.
- Batch writing and row appending for Google Sheets to handle high-volume data logging.
- Granular Drive sharing controls including public link generation or specific email role assignments.
- Full attachment support for Gmail, enabling automated document distribution.
- Complex query support for Gmail and Drive, allowing for precise data retrieval based on dates, senders, or file content.
SKILL.md
Loading
Related Openclaw Skills
Pesquisa Profunda
A comprehensive 8-phase research framework designed to transform raw data into verified, high-authority reports with professional citations.
Persistent Browser Scraper
A specialized web scraping tool for AI agents that maintains logged-in sessions across major platforms using persistent browser contexts.
Exa Research
An advanced web intelligence skill that enables AI agents to perform grounded searches, fetch page contents, and discover similar links with high precision.
AUSUB Gold Investment Tracking
A specialized tool for tracking Gold ETF market conditions and generating rule-based dynamic investment suggestions.
TikTok Ad Script Generator for Shopify
An elite TikTok performance marketing assistant that crafts viral-ready ad scripts, hook variations, and UGC content specifically for Shopify e-commerce brands.
SeggWat CLI
A command-line interface for the SeggWat platform that enables developers to manage user feedback, triage issues, and monitor satisfaction metrics directly from the terminal.
Featured*
