The write side is why you would install it, because appending a row is the natural way for an agent to record what it did. clear_range is in the same set, so hand it a workbook rather than an account, and note that the OAuth client and the token are both yours and stay on your machine.
A Google Sheets server authenticated with your own OAuth credentials. Five tools cover reading a range, writing or updating one, appending rows, describing the workbook and clearing cells. Every tool accepts either a full Google Sheets URL or a bare spreadsheet ID.
- Data read from any range in a spreadsheet (read_sheet)
- Data written or updated in place (write_sheet)
- New rows appended to the end of a sheet (append_rows)
- Sheet names, row counts and column counts for a workbook (get_sheet_info)
- A range of cells cleared (clear_range)
- A full Sheets URL accepted anywhere an ID would be, so a link pasted into chat works as-is
Node.js 18 or later, a Google account, and a free Google Cloud project with the Google Sheets API and Google Drive API enabled. Create Desktop app OAuth credentials, save them as credentials.json, and run node auth.js once to produce a local token.json; the server refreshes the access token itself after that.