majiayu000 Google Workspace Skill
Overview
Unified Google Workspace integration for managing email, calendar, files, and communication across three accounts:
| Alias | Purpose | |
|---|---|---|
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:- senderto:- recipientsubject:- subject linehas:attachment- with attachmentsafter:/before:- date rangeis:unread- unread onlylabel:- 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)