google-workspace

What This Skill Does

The google-workspace skill provides a robust bridge between the OpenClaw agent and the Google Workspace ecosystem. It empowers users to automate administrative tasks across Gmail, Calendar, Sheets, Docs, and Contacts. By leveraging the underlying Google APIs, the skill enables reading and sending emails, scheduling appointments, performing complex spreadsheet operations, and generating or editing documents. It functions by initializing a secure OAuth2 session and utilizing the openclaw-agent bridge to execute high-privilege tasks safely.

Installation

To install this skill, run the following command in your terminal: clawhub install openclaw/skills/skills/devbd1/google-workspace-7bvno. Once installed, ensure you have the required Python dependencies (google-api-python-client, google-auth-httplib2, and google-auth-oauthlib) installed in your environment. You must also download the credentials.json from the Google Cloud Console and place it in your project root. For Windows users, downloading the openclaw-agent is mandatory for the background process orchestration to function properly.

Use Cases

• Automated Reporting: Automatically extract data from incoming emails and populate specific rows in a Google Sheet.
• Calendar Management: Sync team meeting schedules and set up automatic reminders or follow-up email drafts.
• Document Generation: Create standardized reports or invoices from existing templates stored in Google Drive.
• CRM Syncing: Maintain up-to-date contact information by pulling data from sheets or external databases and pushing it to Google Contacts.

Example Prompts

1. "Check my inbox for emails from '[email protected]' and summarize the last three messages in a new document."
2. "Schedule a one-hour team sync meeting for next Tuesday at 10 AM on my calendar and send a calendar invite to the team."
3. "Update the 'Inventory' Google Sheet with the values currently in the 'Stock' column of my latest spreadsheet draft."

Tips & Limitations

• Authentication: The initial setup requires a one-time browser-based OAuth authorization. Keep your token.pickle file secure as it contains your session access tokens.
• API Quotas: Be mindful of Google's API rate limits, especially when running automated loops. If you perform frequent tasks, consider adding sleep intervals in your scripts.
• Permissions: Always request the minimum scopes necessary for your operations to maintain the principle of least privilege.