Summary
A tracking sheet becomes writable from the conversation, one cell at a time.
Three of the four tools read and the fourth writes a single cell by range and value, which keeps an agent's edits small enough to check rather than letting it replace a sheet wholesale. Everything begins at gdrive_search, since the read and write tools address files by ID — a session that cannot find the file cannot do anything else with it.
What it is
A four-tool server over Google Drive and Google Sheets: search and read for files, range reads and single-cell writes for spreadsheets.
What you get
- Drive search with a query and paging, returning the fileId the other tools take
- The contents of a file read by fileId
- Spreadsheet data read by ranges, with options for how ranges and formatting come back
- One spreadsheet cell updated in place, addressed by range and given a value
Requirements
CLIENT_ID, CLIENT_SECRET and GDRIVE_CREDS_DIR — a Google client credential pair and a directory the server keeps its credentials in — plus a Drive account holding the files you mean to reach.
Setup effort
One command plus a key — npx -y @isaacphi/mcp-gdrive, then supply credentials