Google Workspace Skill

Overview

Unified Google Workspace integration for managing email, calendar, files, and communication across three accounts:

Alias	Purpose	Email
`psd`	Work	PSD district email
`kh`	Personal	Personal Gmail
`hrg`	Business	Consulting & real estate

Account Selection

Explicit

"check my psd email"
"send email from hrg"
"kh calendar for tomorrow"

Inferred

Geoffrey will infer the appropriate account from context:

Work-related → psd
Personal matters → kh
Business/real estate → hrg

Available Operations

Gmail

Script	Description	Example
`list_messages.js`	List inbox, unread, by label	"show unread psd emails"
`read_message.js`	Get full message content	"read that email"
`send_message.js`	Compose and send	"send email to John about..."
`send_with_attachment.js`	Send with file attachment	"email report with PDF attached"
`search_messages.js`	Search with Gmail operators	"find emails from Sarah last week"
`get_unread_summary.js`	Unread count + top messages	"how many unread emails?"

Calendar

Script	Description	Example
`list_events.js`	Get upcoming events	"what's on my calendar today"
`create_event.js`	Schedule new events	"schedule meeting tomorrow at 2pm"
`update_event.js`	Modify existing events	"move that meeting to 3pm"
`search_events.js`	Find by criteria	"find meetings with Mike"

Drive

Script	Description	Example
`list_files.js`	Browse/search files	"find budget spreadsheet"
`read_file.js`	Get file content	"show me that document"
`create_file.js`	Create new docs/sheets	"create a new spreadsheet"
`upload_file.js`	Upload local file	"upload this to drive"

Tasks

Script	Description	Example
`list_tasks.js`	Get task lists	"show my google tasks"
`create_task.js`	Add new task	"add task to google tasks"
`complete_task.js`	Mark done	"complete that task"

Chat

Script	Description	Example
`list_spaces.js`	Get available spaces	"list chat spaces"
`send_message.js`	Post to space	"send message to team chat"
`read_messages.js`	Get chat history	"show recent chat messages"

Usage Patterns

Running Scripts

All scripts use the token_manager for authentication:

const { getAuthClient } = require('./auth/token_manager');

async function main() {
  const account = process.argv[2] || 'psd';
  const auth = await getAuthClient(account);

  // Use auth with Google API
  const gmail = google.gmail({ version: 'v1', auth });
  // ...
}

Output Format

All scripts return JSON:

{
  "success": true,
  "account": "psd",
  "data": { ... },
  "metadata": {
    "timestamp": "2024-01-15T10:30:00Z",
    "count": 5
  }
}

Error Handling

{
  "error": "Token expired",
  "account": "psd",
  "action": "Run: node token_manager.js refresh psd"
}

Setup Required

Before using this skill:

Complete Google Cloud Console setup (see auth/GOOGLE_CLOUD_SETUP.md)
Add credentials to ~/Library/Mobile Documents/com~apple~CloudDocs/Geoffrey/secrets/.env
Authenticate all three accounts
For PSD account: allowlist OAuth app in Google Admin

Cross-Account Operations

Some operations work across accounts:

"Forward this to my personal email"
"Copy this file to my work drive"
"Add to both calendars"

Gmail Search Operators

Support standard Gmail search:

from: - sender
to: - recipient
subject: - subject line
has:attachment - with attachments
after: / before: - date range
is:unread - unread only
label: - by label

Example: "search psd email for from:boss@psd.org after:2024-01-01 has:attachment"

Notes

Access tokens expire after 1 hour (auto-refreshed)
Refresh tokens don't expire unless revoked
All API calls are rate-limited by Google
Keep API has limited availability (may not be enabled)

google-workspace

Safety Notice

Copy this and send it to your AI assistant to learn