google-workspace

Automate Gmail, Calendar, Drive, Contacts, Sheets, and Docs tasks via Python scripts.

1.2k|116|Updated Mar 19, 2026
One-click install
npx skills add https://github.com/math-inc/OpenGauss --skill google-workspace-math-inc
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: google-workspace
Source: https://github.com/math-inc/OpenGauss/tree/main/skills/productivity/google-workspace
Command: npx skills add https://github.com/math-inc/OpenGauss --skill google-workspace-math-inc

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires google-api-python-client, google-auth-oauthlib, google-auth-httplib2, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Gmail, Calendar, Drive, Contacts, Sheets, and Docs are often managed with manual, repetitive workflows. This Skill provides a Python-based interface in Gauss to automate common Google Workspace tasks across these services, reducing manual effort and errors.

Core Features & Use Cases

  • OAuth2-based authentication with automatic token refresh for all Google Workspace services.
  • Unified CLI/agent API to read, create, update, and query data across Gmail, Calendar, Drive, Contacts, Sheets, and Docs without external binaries.
  • Real-world use cases include auto-archiving unread Gmail summaries, syncing calendar events to a sheet, and exporting contacts to a CRM workflow.

Quick Start

Authenticate with OAuth2 using the included setup, then issue API commands through the Gauss agent to manage Gmail, Calendar, Drive, Contacts, Sheets, and Docs.

Frequently Asked Questions about google-workspace

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Gmail and Google Calendar tasks with Python?

You can automate Gmail and Google Calendar tasks with Python by using scripts that apply the Google API client libraries to read, create, update, and query emails and events. This approach runs in a virtual environment and outputs structured JSON.

How does OAuth2 authentication work for Google Workspace APIs?

OAuth2 authentication for Google Workspace APIs requires an initial setup to authorize access, followed by automatic token refresh during subsequent requests. This ensures continuous access to Gmail, Drive, and Calendar services without manual re-authentication.

Can I use Python to sync Google Calendar events to Google Sheets?

Yes, you can use Python to sync Google Calendar events to Google Sheets. The scripts interact with both services to query calendar events and create or update corresponding rows in a spreadsheet, outputting the results as structured JSON.

Do I need to install external binaries to read and update Google Contacts?

No, you do not need external binaries to read and update Google Contacts. The automation runs entirely within the virtual environment using Python dependencies like google-api-python-client, directly querying contacts and exporting structured JSON.

What is the best way to manage Google Drive files without manual uploads?

The best way to manage Google Drive files without manual uploads is using Python scripts with the Google API client library. This method allows you to programmatically create, read, and update files directly within your automated workflow.

Why does my Google Workspace automation require structured JSON outputs?

Google Workspace automation requires structured JSON outputs to enable downstream processing within your workflow. This format standardizes the data returned from querying emails, events, or files, making it consumable by CLI tools, chatbots, or embedded agents.