google-workspace
Skill136 starsChanged 3 months agoMITView on GitHub
google-workspace — Gmail, Calendar, Drive, Docs, Sheets via gws CLI or Python.
We split this skill into the rules it gives an agent
11 rules. 0 are common, 3 are distinctive, and 8 are very specific to this project.
0
Common
Most of the 40 edited versions we read keep these.
3
Distinctive
This author's own choices. Worth a look.
8
Very specific
Tied to their project's names, files or tools. Probably skip.
- Common
- Distinctive
- Very specific
- Very specific: line 64
If it prints AUTHENTICATED, skip to Usage — setup is already done.
- Distinctive: line 68
Before starting OAuth setup, ask the user TWO questions:
- Very specific: line 126
If they paste the raw client ID / client secret values instead of a file path, write a valid Desktop OAuth JSON file for them yourself, …
- Distinctive: line 133
Use the service set chosen in Step 1.
- Very specific: line 148
If the user gets Error 403: access_denied, send them directly to https://console.cloud.google.com/auth/audience to add themselves as a test …
- Very specific: line 161
If --auth-code fails because the code expired, was already used, or came from an older browser tab, it now returns a fresh fresh_auth_url.
- Very specific: line 172
Should print AUTHENTICATED.
- Very specific: line 178
If gws is installed, google_api.py points it at the same ~/.hermes/google_token.json credentials file.
- Distinctive: line 271
Known calendars: ask the user for their calendar IDs (or enumerate with the raw API fallback above).
- Very specific: line 347
All commands return JSON. Parse with jq or read directly.
- Very specific: line 392
When google_api.py or macOS Calendar.app hangs, query the Google Calendar API directly with a quick Python one-liner using …
“Common” is measured: kept by at least 6 in 10 of the 40 edited versions of this file we could read. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Files
Google Workspace
Installed-script caveat: The current
scripts/setup.pyin this environment does not accept a--servicesargument. Its configured scope list is broad (including Gmail read/send/modify plus Calendar, Drive, Contacts, Sheets, and Docs). Do not run a new OAuth authorization until the requested service scope has been reviewed or a narrower setup path is implemented.
Gmail, Calendar, Drive, Contacts, Sheets, and Docs — through Hermes-managed OAuth and a thin CLI wrapper. When gws is installed, the skill uses it as the execution backend for broader Google Workspace coverage; otherwise it falls back to the bundled Python client implementation.
References
references/gmail-search-syntax.md— Gmail search operators (is:unread, from:, newer_than:, etc.)
Scripts
scripts/setup.py— OAuth2 setup (run once to authorize)scripts/google_api.py— compatibility wrapper CLI. It prefersgwsfor operations when available, while preserving Hermes' existing JSON output contract.
First-Time Setup
The setup is fully non-interactive — you drive it step by step so it works on CLI, Telegram, Discord, or any platform.
Define a shorthand first:
GSETUP="python ${HERMES_HOME:-$HOME/.hermes}/skills/productivity/google-workspace/scripts/setup.py"Step 0: Check if already set up
$GSETUP --checkIf it prints AUTHENTICATED, skip to Usage — setup is already done.
Step 1: Triage — ask the user what they need
Before starting OAuth setup, ask the user TWO questions:
Question 1: "What Google services do you need? Just email, or also Calendar/Drive/Sheets/Docs?"
- Email only → They don't need this skill at all. Use the
himalayaskill instead — it works with a Gmail App Password (Settings → Security → App Passwords) and takes 2 minutes to set up. No Google Cloud project needed. Load the himalaya skill and follow its setup instructions. - Email + Calendar → Continue with this skill, but use
--services email,calendarduring auth so the consent screen only asks for the scopes they actually need. - Calendar/Drive/Sheets/Docs only → Continue with this skill and use a
narrower
--servicesset likecalendar,drive,sheets,docs. - Full Workspace access → Continue with this skill and use the default
allservice set.
Question 2: "Does your Google account use Advanced Protection (hardware security keys required to sign in)? If you're not sure, you probably don't — it's something you would have explicitly enrolled in."
- No / Not sure → Normal setup. Continue below.
- Yes → Their Workspace admin must add the OAuth client ID to the org's allowed apps list before Step 4 will work. Let them know upfront.
Step 2: Create OAuth credentials (one-time, ~5 minutes)
Tell the user:
You need a Google Cloud OAuth client. This is a one-time setup:
- Create or select a project: https://console.cloud.google.com/projectselector2/home/dashboard
- Enable the required APIs from the API Library: https://console.cloud.google.com/apis/library Enable: Gmail API, Google Calendar API, Google Drive API, Google Sheets API, Google Docs API, People API
- Create the OAuth client here: https://console.cloud.google.com/apis/credentials Credentials → Create Credentials → OAuth 2.0 Client ID
- Application type: "Desktop app" → Create
- If the app is still in Testing, add the user's Google account as a test user here: https://console.cloud.google.com/auth/audience Audience → Test users → Add users
- Download the JSON file and tell me the file path
Important Hermes CLI note: if the file path starts with
/, do NOT send only the bare path as its own message in the CLI, because it can be mistaken for a slash command. Send it in a sentence instead, like:The JSON file path is: <user-home>/Downloads/client_secret_....json
Once they provide the path:
$GSETUP --client-secret /path/to/client_secret.jsonIf they paste the raw client ID / client secret values instead of a file path,
write a valid Desktop OAuth JSON file for them yourself, save it somewhere
explicit (for example ~/Downloads/hermes-google-client-secret.json), then run
--client-secret against that file.
Step 3: Get authorization URL
Use the service set chosen in Step 1. Examples:
$GSETUP --auth-url --services email,calendar --format json
$GSETUP --auth-url --services calendar,drive,sheets,docs --format json
$GSETUP --auth-url --services all --format jsonThis returns JSON with an auth_url field and also saves the exact URL to
~/.hermes/google_oauth_last_url.txt.
Agent rules for this step:
- Extract the
auth_urlfield and send that exact URL to the user as a single line. - Tell the user that the browser will likely fail on
http://localhost:1after approval, and that this is expected. - Tell them to copy the ENTIRE redirected URL from the browser address bar.
- If the user gets
Error 403: access_denied, send them directly tohttps://console.cloud.google.com/auth/audienceto add themselves as a test user.
Step 4: Exchange the code
The user will paste back either a URL like http://localhost:1/?code=4/0A...&scope=...
or just the code string. Either works. The --auth-url step stores a temporary
pending OAuth session locally so --auth-code can complete the PKCE exchange
later, even on headless systems:
$GSETUP --auth-code "THE_URL_OR_CODE_THE_USER_PASTED" --format jsonIf --auth-code fails because the code expired, was already used, or came from
an older browser tab, it now returns a fresh fresh_auth_url. In that case,
immediately send the new URL to the user and have them retry with the newest
browser redirect only.
Step 5: Verify
$GSETUP --checkShould print AUTHENTICATED. Setup is complete — token refreshes automatically from now on.
Notes
- Token is stored at
~/.hermes/google_token.jsonand auto-refreshes. - Pending OAuth session state/verifier are stored temporarily at
~/.hermes/google_oauth_pending.jsonuntil exchange completes. - If
gwsis installed,google_api.pypoints it at the same~/.hermes/google_token.jsoncredentials file. Users do not need to run a separategws auth loginflow. - To revoke:
$GSETUP --revoke
Usage
Preferred: use a gapi wrapper if one is installed on PATH. It routes through the correct Python:
gapi calendar list
gapi gmail search "flight friday" --max 5Quick auth check: just run gapi calendar list --max 1 (or $GAPI calendar list --max 1). If it returns JSON, auth is working. Do not waste time on setup.py --check or ls google_token.json — go straight to the query.
Fallback (if gapi is missing): set GAPI as a shorthand:
GAPI="python ${HERMES_HOME:-$HOME/.hermes}/skills/productivity/google-workspace/scripts/google_api.py"Gmail
# Search (returns JSON array with id, from, subject, date, snippet)
$GAPI gmail search "is:unread" --max 10
$GAPI gmail search "from:boss@company.com newer_than:1d"
$GAPI gmail search "has:attachment filename:pdf newer_than:7d"
# Read full message (returns JSON with body text)
$GAPI gmail get MESSAGE_ID
# Send
$GAPI gmail send --to user@example.com --subject "Hello" --body "Message text"
$GAPI gmail send --to user@example.com --subject "Report" --body "<h1>Q4</h1><p>Details...</p>" --html
$GAPI gmail send --to user@example.com --subject "Hello" --from '"Research Agent" <user@example.com>' --body "Message text"
# Reply (automatically threads and sets In-Reply-To)
$GAPI gmail reply MESSAGE_ID --body "Thanks, that works for me."
$GAPI gmail reply MESSAGE_ID --from '"Support Bot" <user@example.com>' --body "Thanks"
# Labels
$GAPI gmail labels
$GAPI gmail modify MESSAGE_ID --add-labels LABEL_ID
$GAPI gmail modify MESSAGE_ID --remove-labels UNREADCalendar
# List events (defaults to next 7 days, primary calendar)
$GAPI calendar list
$GAPI calendar list --start 2026-03-01T00:00:00Z --end 2026-03-07T23:59:59Z
# Target a specific calendar by ID (use --calendar)
$GAPI calendar list --start 2026-06-17T00:00:00-04:00 --end 2026-06-17T23:59:59-04:00 --calendar work@example.com
# Discover available calendars — google_api.py has NO built-in calendar listing.
# Use the raw API fallback (see below) or hardcode known IDs:
# primary = default personal calendar
# <work-email> = the user's work calendar
# <id>@group.calendar.google.com = any shared calendar
# Create event (ISO 8601 with timezone required)
$GAPI calendar create --summary "Team Standup" --start 2026-03-01T10:00:00-06:00 --end 2026-03-01T10:30:00-06:00
$GAPI calendar create --summary "Lunch" --start 2026-03-01T12:00:00Z --end 2026-03-01T13:00:00Z --location "Cafe"
$GAPI calendar create --summary "Review" --start 2026-03-01T14:00:00Z --end 2026-03-01T15:00:00Z --attendees "alice@co.com,bob@co.com"
# Delete event
$GAPI calendar delete EVENT_IDDiscover all calendars (raw API fallback): google_api.py has no calendar list-calendars command. To enumerate calendars:
import json, urllib.request, time
with open('~/.hermes/google_token.json') as f:
tok = json.load(f)
now = time.time()
if now > tok.get('expiry_time', 0):
req = urllib.request.Request('https://oauth2.googleapis.com/token',
data=json.dumps({'grant_type': 'refresh_token',
'client_id': tok['client_id'],
'client_secret': tok['client_secret'],
'refresh_token': tok['refresh_token']}).encode(),
headers={'Content-Type': 'application/json'})
tok['token'] = json.loads(urllib.request.urlopen(req).read())['access_token']
url = 'https://www.googleapis.com/calendar/v3/users/me/calendarList'
resp = urllib.request.urlopen(urllib.request.Request(url,
headers={'Authorization': f'Bearer {tok["token"]}'}))
for c in json.loads(resp.read())['items']:
print(f"{c['id']} | {c['summary']}")Known calendars: ask the user for their calendar IDs (or enumerate with the raw API fallback above). Do not assume an organization's calendar is synced to Google or Apple Calendar — it may live in Outlook/Teams.
Drive
# Search existing files
$GAPI drive search "quarterly report" --max 10
$GAPI drive search "mimeType='application/pdf'" --raw-query --max 5
# Get metadata for a single file
$GAPI drive get FILE_ID
# Upload a local file (auto-detects MIME type)
$GAPI drive upload /path/to/report.pdf
$GAPI drive upload /path/to/image.png --name "Logo.png" --parent FOLDER_ID
# Download (binary files download as-is; Google-native files export to a
# sensible default — Docs→pdf, Sheets→csv, Slides→pdf, Drawings→png)
$GAPI drive download FILE_ID
$GAPI drive download DOC_ID --output ~/doc.pdf
$GAPI drive download DOC_ID --export-mime text/plain --output ~/doc.txt
# Create a folder
$GAPI drive create-folder "Reports"
$GAPI drive create-folder "Q4" --parent FOLDER_ID
# Share
$GAPI drive share FILE_ID --email alice@example.com --role reader
$GAPI drive share FILE_ID --email alice@example.com --role writer --notify
$GAPI drive share FILE_ID --type anyone --role reader # anyone with link
$GAPI drive share FILE_ID --type domain --domain example.com --role reader
# Delete — defaults to trash (reversible). Use --permanent to skip the trash.
$GAPI drive delete FILE_ID
$GAPI drive delete FILE_ID --permanentContacts
$GAPI contacts list --max 20Sheets
# Create a new spreadsheet
$GAPI sheets create --title "Q4 Budget"
$GAPI sheets create --title "Inventory" --sheet-name "Stock"
# Read
$GAPI sheets get SHEET_ID "Sheet1!A1:D10"
# Write
$GAPI sheets update SHEET_ID "Sheet1!A1:B2" --values '[["Name","Score"],["Alice","95"]]'
# Append rows
$GAPI sheets append SHEET_ID "Sheet1!A:C" --values '[["new","row","data"]]'Docs
# Read
$GAPI docs get DOC_ID
# Create a new Doc (optionally seeded with body text)
$GAPI docs create --title "Meeting Notes"
$GAPI docs create --title "Draft" --body "First paragraph..."
# Append text to the end of an existing Doc
$GAPI docs append DOC_ID --text "Additional content to append"Output Format
All commands return JSON. Parse with jq or read directly. Key fields:
- Gmail search:
[{id, threadId, from, to, subject, date, snippet, labels}] - Gmail get:
{id, threadId, from, to, subject, date, labels, body} - Gmail send/reply:
{status: "sent", id, threadId} - Calendar list:
[{id, summary, start, end, location, description, htmlLink}] - Calendar create:
{status: "created", id, summary, htmlLink} - Drive search:
[{id, name, mimeType, modifiedTime, webViewLink}] - Drive get:
{id, name, mimeType, modifiedTime, size, webViewLink, parents, owners} - Drive upload:
{status: "uploaded", id, name, mimeType, webViewLink} - Drive download:
{status: "downloaded", id, name, path, mimeType} - Drive create-folder:
{status: "created", id, name, webViewLink} - Drive share:
{status: "shared", permissionId, fileId, role, type} - Drive delete:
{status: "trashed" | "deleted", fileId, permanent} - Contacts list:
[{name, emails: [...], phones: [...]}] - Sheets get:
[[cell, cell, ...], ...] - Sheets create:
{status: "created", spreadsheetId, title, spreadsheetUrl} - Docs create:
{status: "created", documentId, title, url} - Docs append:
{status: "appended", documentId, inserted_at, characters}
Rules
- Never send email, create/delete calendar events, delete Drive files, share files, or modify Docs/Sheets without confirming with the user first. Show what will be done (recipients, file IDs, content, share role) and ask for approval. For
drive delete, prefer the default trash (reversible) over--permanent. - Check auth with
gapi calendar list --max 1— if it returns JSON events, auth is working. Do NOT runsetup.py --checkorls google_token.jsonunless the query actually fails with an auth error. The token file exists and is valid. - Use the Gmail search syntax reference for complex queries — load it with
skill_view("google-workspace", file_path="references/gmail-search-syntax.md"). - Calendar times must include timezone — always use ISO 8601 with offset (e.g.,
2026-03-01T10:00:00-06:00) or UTC (Z). - Respect rate limits — avoid rapid-fire sequential API calls. Batch reads when possible.
Troubleshooting
| Problem | Fix | |
NOT_AUTHENTICATED | Run setup Steps 2-5 above | |
REFRESH_FAILED | Token revoked or expired — redo Steps 3-5 | |
HttpError 403: Insufficient Permission | Missing API scope — $GSETUP --revoke then redo Steps 3-5 | |
AUTHENTICATED (partial) or "Token missing scopes" | New write capabilities (Drive write/delete, Docs create/edit) require re-authorization. $GSETUP --revoke then redo Steps 3-5 to grant the upgraded scopes. | |
HttpError 403: Access Not Configured | API not enabled — user needs to enable it in Google Cloud Console | |
ModuleNotFoundError | Run $GSETUP --install-deps | |
TypeError: unsupported operand type(s) for |: | Script loaded by system Python — use the Hermes venv Python, not bare python3. See row below. | |
TypeError: unsupported operand type(s) for \ | `: 'type' and 'object'` | System Python too old (pre-3.10 union syntax). Always use Hermes venv Python: ~/.hermes/hermes-agent/venv/bin/python — not python3 or python. Applies to both setup.py and google_api.py. |
| Advanced Protection blocks auth | Workspace admin must allowlist the OAuth client ID | |
| macOS Calendar.app hangs / won't render windows | Calendar.app may launch but never draw a window or respond to AppleScript (AppleEvent timed out, -1712). Do not waste time debugging it. Use the Google API via google_api.py instead — it writes directly to the Gmail calendar and syncs to macOS. As emergency fallback: insert events directly into ~/Library/Group Containers/group.com.apple.calendar/Calendar.sqlitedb via sqlite3. |
Fallback: Direct Calendar API (no CLI)
When google_api.py or macOS Calendar.app hangs, query the Google Calendar API directly with a quick Python one-liner using ~/.hermes/google_token.json:
import json, urllib.request, time
with open('~/.hermes/google_token.json') as f:
tok = json.load(f)
# Refresh if expired
now = time.time()
if now > tok.get('expiry_time', 0):
req = urllib.request.Request('https://oauth2.googleapis.com/token',
data=json.dumps({'grant_type': 'refresh_token',
'client_id': tok['client_id'],
'client_secret': tok['client_secret'],
'refresh_token': tok['refresh_token']}).encode(),
headers={'Content-Type': 'application/json'})
tok['token'] = json.loads(urllib.request.urlopen(req).read())['access_token']
# Query events
url = "https://www.googleapis.com/calendar/v3/calendars/primary/events?timeMin=2026-06-15T00:00:00-04:00&timeMax=2026-06-15T23:59:59-04:00&singleEvents=true&orderBy=startTime"
resp = urllib.request.urlopen(urllib.request.Request(url,
headers={'Authorization': f'Bearer {tok["token"]}'}))
for e in json.loads(resp.read())['items']:
print(f"{e['summary']} ({e['start'].get('dateTime', '')})")Note: macOS Calendar.app can hang on AppleScript queries — if osascript doesn't return within 5 seconds, skip to the API path above.
Browser Automation Pitfall
browser_navigate to calendar.google.com redirects to the public marketing page. The browser automation session does not carry over the user's logged-in Chrome cookies, so navigating directly to Google Calendar via the browser tool will always land on the unauthenticated /intl/en-US/products/calendar/ landing page. Use the CLI/API path (google_api.py) for all calendar operations instead of trying browser automation.
Revoking Access
$GSETUP --revokePublic support files
references/gmail-search-syntax.mdscripts/_hermes_home.pyscripts/google_api.pyscripts/gws_bridge.pyscripts/setup.py
Other versions45 projects use a version of this.
Word for word · 1
- AtlasOmnia/hermes-custom-pack★ 75100% same
Edited · 19
- NousResearch/hermes-agent★ 259k89% same
- math-inc/OpenGauss★ 1.3k71% same
- Tommy-yw/RunbookHermes★ 54691% same
- aivrar/portable-hermes-agent★ 23994% same
- RedWoodOG/Hermes-Desktop★ 17773% same
- wundercorp/loki★ 2891% same
- delorenj/skills★ 1697% same
- gquthier/CLAWG★ 1671% same
- Samin12/skills★ 893% same
- Chere3/hermes-automation-stack★ 293% same
9 more not listed
Wrote their own version · 25
- google/adk-recipes★ 11ksame name
- google/adk-samples★ 11ksame name
- mitsuhiko/agent-commands★ 3.2ksame name
- mitsuhiko/agent-stuff★ 3.2ksame name
- HybridAIOne/hybridclaw★ 159same name
- amanaiproduct/amans-skills★ 79same name
- ariffazil/arifOS★ 54same name
- amanning3390/hermeshub★ 48same name
- bakissation/mcp-google-multi★ 19same name
- ScriptingApp/skills★ 15same name
15 more not listed
How matches are found. Word for word: the exact same text. Edited: shares passages with this file (“99% same” means 99% of its five-word phrases also appear here; 10% or more counts). Their own version: similar meaning, or, weakest, the same name. We can’t tell which project had it first. Projects are counted among the 200 most-starred candidates, and mentions are links to the repository we found, up to 50 per site, so both counts are a floor.
Used alongsideProjects with it also use heartmula, findmy and 6 more.
Other files people use alongside this one.
Files found in the same public projects as a version of this one, more often than they turn up anywhere else. Each project counts once, large collections count for less, and this file's own repository is left out.
math-incSkillheartmula
Set up and run HeartMuLa, the open-source music generation model family (Suno-like). Generates full songs from lyrics + tags with multilingual support.
Also in 6 projects that use this
math-incSkillfindmy
Track Apple devices and AirTags via FindMy.app on macOS using AppleScript and screen capture.
Also in 9 projects that use this
Tommy-ywSkillsongwriting-and-ai-music
Songwriting craft, AI music generation prompts (Suno focus), parody/adaptation techniques, phonetic tricks, and lessons learned. These are tools and ideas, not rules. Break any of them when the art calls for it.
Also in 7 projects that use this
john-data-chenSkillteams-meeting-pipeline
Operate the Teams meeting summary pipeline via Hermes CLI — summarize meetings, inspect pipeline status, replay jobs, manage Microsoft Graph subscriptions.
Also in 5 projects that use this
MicrosoftSkillpowerpoint
PowerPoint slide deck generation and management using python-pptx with YAML-driven content and styling
Also in 10 projects that use this
- +3 more from math-inc
In this repository72 other files it gives its agents.
- AGENTS.mdAGENTS.md
- apple-remindersSkill
- imessageSkill
- macos-app-automationSkill
- macos-storage-managementSkill
- hermes-agentSkill
- hermes-config-editingSkill
- hermes-context-optimizationSkill
- hermes-overnight-autonomySkill
- hermes-plugin-evaluationSkill
- hermes-session-maintenanceSkill
- local-model-selectionSkill
- opencodeSkill
- computer-useSkill
- claude-designSkill
- content-styleSkill
- marketing-collateral-designSkill
- dogfoodSkill
- codebase-inspectionSkill
- github-authSkill
- github-code-reviewSkill
- github-issuesSkill
- github-pre-push-gatesSkill
- github-pr-workflowSkill
- github-readme-maintenanceSkill
- github-repo-managementSkill
- github-workflowsSkill
- local-app-github-publishingSkill
- meal-trackerSkill
- hermes-desktop-pluginsSkill
- hermes-mnemosyneSkill
- hermes-self-evaluationSkill
- hermes-starter-onboardingSkill
- messaging-gateway-troubleshootingSkill
- mnemosyne-maintenanceSkill
- hermes-nightly-self-check-decisionsSkill
- hermes-plugin-developmentSkill
- skill-auditorSkill
- hermes-themesSkill
- notes-automation-workflowsSkill
- daily-note-wrapupSkill
- obsidianSkill
- vault-organizationSkill
- product-competitor-analysisSkill
- destination-trip-planningSkill
- discord-connectSkill
- domestic-trip-planningSkill
- mapsSkill
- notionSkill
- office-document-reviewSkill
- session-artifact-indexingSkill
- daily-news-digestsSkill
- dynamic-content-extractionSkill
- evidence-based-repliesSkill
- external-model-reviewSkill
- hf-model-card-researchSkill
- local-discoverySkill
- marketplace-purchase-vettingSkill
- site-mappingSkill
- source-verificationSkill
- The first 60 shown.
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
Reviews can't be read right now.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

