The Apps Script deployment does the authenticating, which is what makes setup short and also what concentrates everything into one URL. Good for your own workbook, provided you treat that URL the way you treat a password.
A Python MCP server that talks to a Google Apps Script Web App you deploy yourself. The script runs under your own Google session, so the sheet is reached without handing OAuth credentials or tokens to the server.
- Single cells and whole ranges read back from a sheet
- Values written to one cell or across a range
- A range cleared
- The sheets in the workbook listed by name
- A connection test that says whether the Apps Script side is answering
Python 3.8+, a Google account with access to Sheets and Apps Script, and a Web App deployment whose /exec URL goes in APPS_SCRIPT_URL. That deployment publishes with execute-as-you and access-for-anyone, so whoever holds the URL can read and write the sheet: keep it out of commits, and for anything past testing make the Apps Script require a shared secret parameter.
Build from source — clone the repository and build it, then point your client at the binary