gh-krishagel-geoffrey/skills/google-workspace/SKILL.md

name, description, triggers, allowed-tools, version

name	description	triggers	allowed-tools	version
google-workspace	Unified Google Workspace integration for managing email, calendar, files, and communication across multiple accounts	check email read email send email search email list emails unread emails inbox check calendar schedule meeting create event what's on my calendar free time upcoming meetings find file search drive list documents open document create document create doc create spreadsheet create presentation edit document google tasks task list send chat check chat	Read, Bash	0.1.0

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:

1. Complete Google Cloud Console setup (see auth/GOOGLE_CLOUD_SETUP.md)
2. Add credentials to ~/Library/Mobile Documents/com~apple~CloudDocs/Geoffrey/secrets/.env
3. Authenticate all three accounts
4. 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)