Google Workspace Skill Skill

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..." | | search_messages.js | Search with Gmail operators | "find emails from Sarah last week" |

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)

Agent Skills: Google Workspace Skill

Skill Files