GSheetsVFS mounts the Google Sheets an account can see: each spreadsheet
becomes a .gsheet.json file holding the Sheets API’s JSON, split into the
spreadsheets it owns and those shared with it. Set up the credentials as in Google Workspace setup.
Install
Configure
access_token replaces the client and refresh token with a token or a
callable that returns one. A MountMode.WRITE mount also allows mv and rm.
Fields
Seconds a request may wait to connect, or between two reads of its answer, before it fails; a download that keeps flowing is never cut off.
OAuth access token, or a callable that returns one. Takes precedence over
client_id and refresh_token.Google OAuth client ID. Required with
refresh_token when access_token is unset; mirage then mints and renews access tokens itself.One base URL that replaces every Google API host and the OAuth token endpoint, such as a test server. Unset uses Google’s hosts.
Authentication
Credentials come from the first of:access_token, a token or a callable that returns one.client_idandrefresh_token, withclient_secretunless the client uses PKCE. Mirage trades the refresh token for access tokens on its own.
https://www.googleapis.com/auth/spreadsheets scope, and the Drive API with the
https://www.googleapis.com/auth/drive scope, since the listing comes from
Drive. A read-only mount can use the readonly variants of both scopes.
Layout
owned/holds the spreadsheets the account owns, shared or not;shared/holds those others shared with it.- A file is named
<YYYY-MM-DD>_<title>__<spreadsheet-id>.gsheet.json. The date is the last modified day and is left out when Drive gives none. - A file holds the Sheets API’s JSON for the spreadsheet: its properties and every sheet with its cell values.
Behavior
- Shared Drives: a spreadsheet in a Shared Drive has no owner, so it is
listed under
shared/, as on thegdrivemount. - Date globs: a glob on the date prefix, such as
2026-05-*, asks Drive only for the spreadsheets modified on those days. - Incomplete listings: Drive may skip part of the account’s files and say
so. The short listing is still shown, and the next
lslists again. - Rename: on a
writemount,mvto a new name in the same folder changes the title. The date and the id must stay, and the title is spelled as the listing spells it (spaces become_). - Delete: on a
writemount,rmdeletes the spreadsheet for good, not to the trash.owned/andshared/cannot be removed. - Edits: reading, writing and appending cell ranges, and raw API calls,
go through the
gwsCLI.
Integration
Google Sheets answers these commands through its own API, so fewer files are read. See Integration.grep -randrgwith-w: Drive full-text search names the spreadsheets to read. Every one is read when the search fails or finds nothing, and when the word may be in any spreadsheet’s JSON whatever the text says: a word with a digit, a Sheets API name or value (formattedValue,NUMBER), or a word every spreadsheet carries (https,arial). Drive indexes a write some time after it lands and searches the spreadsheet’s text, so it can leave out one whose JSON holds the word only in another value (a formula, the time zone, a sheet title, a link, an id).walk_limit: -1in the mount’s"@all"command limit turns the search off and reads every file.
VFS.md
The VFS.md an agent reads with Google Sheets mounted at/<path>. <mode> is the mount’s mode: read, write or exec. The
commands shown are those of a write mount.
- Rendered
- Raw
Virtual Filesystem
VFS Layout
/<path><YYYY-MM-DD>is the file’smodifiedTime, so a date glob such as2026-05-*narrows the query;<title>turns spaces and characters outside[A-Za-z0-9_.-]into_, at most 100 characters.shared/holds sheets others shared; sheets owned and shared out stay inowned/.- A file is the Sheets API
spreadsheets.getresponse with cell data. Tab names:.sheets[].properties.title; first tab’s cells:.sheets[0].data[0].rowData[]?.values[]?.formattedValue. - On a
writepath,rma file to delete it from Drive, ormvit to a new<title>with the same folder, date and id to rename it.
Limitations of Unix Commands for VFSWhere a path differs from a local filesystem:
Run
man <cmd> or <cmd> --help for one command’s usage.