Read and edit spreadsheet cells: ranges, appends, and structural changes like tabs, formatting, and frozen rows, via the Sheets REST API.
Connect it
$ lanes link connect sheets --profile personal --workspace localA browser opens and you approve. The OAuth client is operated by Lanes, so no client secret of theirs is stored on your machine. Pass --own-client to use an application you registered yourself instead, which the Google guide walks through.
What your agent can do
Capabilities are generated from an OpenAPI document vendored into Lanes Link, so the surface is reviewable in a diff and a change upstream cannot widen what your agents can reach without a commit here.
The scopes it asks for
Each provider asks for the narrowest set that makes its capabilities work, because a scope on a consent screen that no tool can spend is a grant asked for and never noticed.
| Scope | What it allows |
|---|---|
https://www.googleapis.com/auth/drive.readonly | read every file in the account |
https://www.googleapis.com/auth/drive.file | only files this app creates or you pick |
https://www.googleapis.com/auth/spreadsheets | every spreadsheet in the account; read, edit, create, and delete (broad) |
A scope marked broad reaches further than the rest, so connect stops and asks for an explicit yes before requesting it.
How to narrow or widen any of this is on Scopes and permissions.
What is recorded
Every call is recorded, allowed or refused. The rule is to keep the shape and withhold the words: an audit log that reproduced the content would be a second copy of the thing it was meant to make accountable.
Identifiers such as spreadsheetId, ranges, includeGridData, range, majorDimension, and pathRange are kept. Everything that carries your words is withheld.
What an entry holds and how to read one is on the audit log.
Narrowing what it may do
Connecting grants the read bundle. Tightening it happens on your machine and takes effect at once:
$ lanes link policy deny 'sheets.*' --connection sheets.main --profile personal --workspace localA deny always beats an allow, whatever the order in the file. See Scopes and permissions for widening, and for what can and cannot be set per connection.
Next: every provider, or Connections for what a connection is and the methods behind one.