buildoak/fieldwork-skills/google-workspace-ops

brew tap steipete/tap
brew install gogcli
gog login YOUR_EMAIL --services all

gog auth status
gog gmail search "is:unread" --max 5 --json --no-input
gog gmail thread get THREAD_ID --json --no-input

Need to interact with Google Workspace?
  |
  +-- Is it email? (read, search, send, labels, drafts)
  |     YES --> gog gmail ...
  |
  +-- Is it calendar? (events, create, conflicts, freebusy)
  |     YES --> gog calendar ...
  |
  +-- Is it files? (search, upload, download, share)
  |     YES --> gog drive ...
  |
  +-- Is it document editing? (create, read, write Google Docs)
  |     YES --> gog docs ...
  |
  +-- Is it presentations? (create from markdown, export)
  |     YES --> gog slides ...
  |
  +-- Is it spreadsheets? (read cells, update, append)
  |     YES --> gog sheets ...
  |
  +-- Is it people? (contacts, directory search, tasks)
        YES --> gog contacts / gog tasks / gog people ...

# Get last 5 unread emails with full content
gog gmail search "is:unread" --max 5 --json | jq '.[].messages[0] | {subject: .subject, from: .from, snippet: .snippet}'
 
# Get a specific thread with all messages
gog gmail thread get THREAD_ID --json

# Preview first (dry-run)
gog send --to "person@example.com" --subject "Meeting notes" --body "Here are the notes..." --dry-run
 
# Then send
gog send --to "person@example.com" --subject "Meeting notes" --body "Here are the notes..." --no-input

# Today's events across all calendars
gog cal events --today --all --json
 
# This week
gog cal events --week --json
 
# Next 3 days
gog cal events --days 3 --json

# The agent translates natural language to RFC3339 times
gog cal create primary \
  --summary "Team standup" \
  --from "2026-02-18T09:00:00+00:00" \
  --to "2026-02-18T09:30:00+00:00" \
  --description "Daily sync" \
  --with-meet \
  --json

# Full-text search
gog search "quarterly report" --max 5 --json | jq '.[].webViewLink'
 
# List files in a folder
gog ls --parent FOLDER_ID --json

# Create doc with markdown content
gog docs create "Meeting Notes 2026-02-17" --file notes.md --json
 
# Or write markdown to existing doc
gog docs write DOC_ID --file notes.md --replace --markdown

# Dump doc as text (great for agent consumption)
gog docs cat DOC_ID
 
# Read specific tab
gog docs cat DOC_ID --tab "Notes"
 
# All tabs
gog docs cat DOC_ID --all-tabs

# One command: markdown -> Google Slides
gog slides create-from-markdown "Q1 Review" --content-file presentation.md --json

# Read a range
gog sheets get SHEET_ID "Sheet1!A1:D10" --json
 
# Append a row
gog sheets append SHEET_ID "Sheet1!A:D" "value1" "value2" "value3" "value4"
 
# Update specific cells
gog sheets update SHEET_ID "Sheet1!B2" "new value"

# Find a doc, read it, email a summary
DOC_ID=$(gog search "project brief" --max 1 --json | jq -r '.[0].id')
CONTENT=$(gog docs cat "$DOC_ID")
gog send --to "team@example.com" --subject "Project Brief Summary" --body "$CONTENT" --no-input

# Only get subject and date from emails
gog gmail search "is:unread" --json --select "subject,date,from"

gog gmail search "is:unread" --json --fail-empty
EXIT=$?
if [ $EXIT -eq 3 ]; then echo "No unread emails"; fi
if [ $EXIT -eq 4 ]; then echo "Auth expired -- run: gog login EMAIL"; fi
if [ $EXIT -eq 7 ]; then sleep 5 && retry; fi

# List authenticated accounts
gog auth list
 
# Target specific account
gog gmail search "is:unread" -a work@company.com --json
gog cal events --today -a personal@gmail.com --json
 
# Set default account
gog config set default_account work@company.com