Problem / Motivation
Spreadsheets are where a lot of small tracking data lives: expenses, task lists, inventories. nanobot can't read or update them, so the agent can only talk about a sheet if someone pastes the contents in.
Proposed Solution
A google_sheets tool next to the Drive one. It lists the configured spreadsheets, reads a range, updates a range and appends rows. Only spreadsheet IDs added in Settings > Apps are reachable.
Ranges have to be bounded A1 ranges like Sheet1!A1:C20. Reads are capped at 200 rows and writes at 2000 cells by default. Values are sent as typed JSON, so numbers stay numbers, and formulas work because writes use USER_ENTERED.
It uses the same service account as the Drive tool when that key is already saved, so there is one key to paste and one email to share sheets with. It can also take its own key. Same hot-reload behavior as Drive, and it ships as a sheets extra that installs the same Google client libraries.
This builds on the Google Drive issue (#6187).
Alternatives Considered
Letting the agent download a sheet as CSV through the Drive tool covers reading, but not writing back.
Related Component
Other (agent tool and WebUI settings).
Activity
0No activity yet.