hermes-gsheets

Google Sheets plugin for Hermes Agent. Read/write spreadsheet metadata, worksheet lists, cell ranges, search rows, create worksheets, append rows, and execute batch updates.

Install

From PyPI

pip install hermes-gsheets

Hermes auto-discovers the plugin on next start via the hermes_agent.plugins entry point.

From GitHub

hermes plugins install dataengineergaurav/hermes-gsheets

Enable

hermes plugins enable google_sheets

Setup

Set one of these environment variables (in ~/.hermes/.env or your shell):

Service account (full read/write)

GOOGLE_SHEETS_CREDENTIALS=/path/to/service-account-key.json

Or paste the JSON inline:

GOOGLE_SHEETS_CREDENTIALS='{"type": "service_account", ...}'

API key (read-only, public sheets only)

GOOGLE_SHEETS_API_KEY=AIza...

Tools

Tool	Description
get_spreadsheet_metadata	Title, locale, timezone, URL + all worksheet details
list_worksheets	Sheet IDs, types, row/column counts
read_range	Read cell values as 2D array from an A1 range
search_rows	Client-side substring search across rows
add_worksheet	Create a brand-new worksheet tab (requires service account)
update_cells	Write values to a specified range
append_row	Append a single row of values
batch_update	Multiple operations (update, append, delete/insert rows, rename sheets, add sheets) in one API call

Platform access

To make google_sheets available on Telegram (or other gateway platforms), add it to your config.yaml:

platform_toolsets:
  telegram:
    - google_sheets
  cli:
    - google_sheets

License

MIT