Skip to main content
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

float
default:"30"
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.
str | callable
secret
OAuth access token, or a callable that returns one. Takes precedence over client_id and refresh_token.
str
Google OAuth client ID. Required with refresh_token when access_token is unset; mirage then mints and renews access tokens itself.
str
secret
Google OAuth client secret, sent with the refresh-token grant. Omit it for a PKCE client.
str
secret
User’s OAuth refresh token. Required with client_id when access_token is unset.
str
One base URL that replaces every Google API host and the OAuth token endpoint, such as a test server. Unset uses Google’s hosts.
Fields marked secret are redacted in snapshots.

Authentication

Credentials come from the first of:
  1. access_token, a token or a callable that returns one.
  2. client_id and refresh_token, with client_secret unless the client uses PKCE. Mirage trades the refresh token for access tokens on its own.
The mount needs the Google Sheets API with the 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 the gdrive mount.
  • 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 ls lists again.
  • Rename: on a write mount, mv to 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 write mount, rm deletes the spreadsheet for good, not to the trash. owned/ and shared/ cannot be removed.
  • Edits: reading, writing and appending cell ranges, and raw API calls, go through the gws CLI.

Integration

Google Sheets answers these commands through its own API, so fewer files are read. See Integration.
  • grep -r and rg with -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: -1 in 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.
Virtual FilesystemVFS Layout/<path>
  • <YYYY-MM-DD> is the file’s modifiedTime, so a date glob such as 2026-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 in owned/.
  • A file is the Sheets API spreadsheets.get response with cell data. Tab names: .sheets[].properties.title; first tab’s cells: .sheets[0].data[0].rowData[]?.values[]?.formattedValue.
  • On a write path, rm a file to delete it from Drive, or mv it to a new <title> with the same folder, date and id to rename it.
Supported Unix Commands for VFSUnix commands work on each path as on a local filesystem, as far as the path supports them:Limitations of Unix Commands for VFSWhere a path differs from a local filesystem:Run man <cmd> or <cmd> --help for one command’s usage.