mcp-gsheets
mcp-gsheets is an MCP server. It reaches google and googlesheets. It needs GOOGLE_APPLICATION_CREDENTIALS, GOOGLE_PRIVATE_KEY and GOOGLE_SERVICE_ACCOUNT_KEY to authenticate. Its repository has 105 GitHub stars and is licensed under MIT; we last read it on 2026-10-22.
This software connects to Google Sheets, allowing read, write, and manipulation of spreadsheets through Claude Desktop.
Install
MCP servers are packaged differently from each other -- some run via npx, some as a Docker image, some as a plain script you clone and run. mcp-gsheets’s own README did not state one plainly enough for this page to quote it rather than guess, so it will not guess. The repository below states it.
What it reaches, and what it needs
What it connects to
Unverified means a mention in the server’s own description, not a citation. A wrong claim here costs nothing to correct and nothing to trust yet.
Maintenance
MCP server for Google Sheets - Read, write and manipulate spreadsheets through Claude Desktop
What mcp-gsheets can do
19 tools documented in its README. An AI client calls these by name.
sheets_get_values- Read cell values from a single range
sheets_batch_get_values- Read cell values from multiple ranges in one request
sheets_get_metadata- Get spreadsheet metadata: title, locale, sheets list with IDs, row/column counts
sheets_check_access- Verify that the service account can access a spreadsheet
sheets_update_values- Write values to a single range (overwrites existing content)
sheets_batch_update_values- Write values to multiple ranges in one request
sheets_append_values- Append rows after the last row of an existing table. **Default `insertDataOption` is `OVERWRITE`** — set `INSERT_ROWS` to push existing rows down
sheets_clear_values- Clear all values in a range (preserves formatting)
sheets_insert_rows- Insert blank or pre-filled rows at a specific position
sheets_delete_columns- Delete one or more columns using a full-column A1 range
sheets_delete_rows- Delete one or more rows using a full-row A1 range
sheets_insert_link- Insert a hyperlink formula into a cell
sheets_insert_date- Insert a date/datetime value formatted correctly into a cell
sheets_create_spreadsheet- Create a new Google Sheets file
sheets_insert_sheet- Add a new sheet tab to an existing spreadsheet
sheets_delete_sheet- Remove a sheet tab by its numeric sheet ID
sheets_duplicate_sheet- Copy a sheet within the same spreadsheet
sheets_copy_to- Copy a sheet to a different spreadsheet
sheets_update_sheet_properties- Rename a sheet, change tab colour, toggle grid lines, etc.
Read from the README; names are kept only if the README contains them.
Common questions about mcp-gsheets
- What does mcp-gsheets do?
- This software connects to Google Sheets, allowing read, write, and manipulation of spreadsheets through Claude Desktop.
- How do I install mcp-gsheets?
- Its README did not state an install command plainly enough for us to quote one, so we do not guess. The repository has the instructions: https://github.com/freema/mcp-gsheets
- What does mcp-gsheets connect to, and what does it need?
- It reaches google and googlesheets. The credentials we found in its source are GOOGLE_APPLICATION_CREDENTIALS, GOOGLE_PRIVATE_KEY and GOOGLE_SERVICE_ACCOUNT_KEY.
- Which AI clients can use mcp-gsheets?
- Its own description mentions Claude Desktop. That is a mention in its description, not a test we ran.
- Is mcp-gsheets official and is it maintained?
- We found nothing naming it as a vendor’s official server. Its repository has 105 GitHub stars and its state in our directory is listed. Its last commit we recorded was on 2026-10-04.
- What licence does mcp-gsheets use?
- The repository declares the MIT licence.