Google Sheets
JSON →A server for comprehensive Google Sheets integration, requiring Google OAuth credentials.
Install
npx @modelcontextprotocol/inspector Tools · 7
- create-spreadsheet Creates a new Google Sheets spreadsheet. Input: title (required), sheet_names (optional array). Returns: Spreadsheet ID, URL, and created sheet names.
- read-range Reads data from a specific range. Input: spreadsheet_id, range_name (e.g., 'Sheet1!A1:C10'). Returns: 2D array of cell values.
- write-range Writes data to a specific range (overwrites existing data). Input: spreadsheet_id, range_name, values (2D array). Returns: Update statistics.
- append-rows Appends rows to the end of a range. Input: spreadsheet_id, range_name, values (2D array). Returns: Update statistics.
- clear-range Clears all data from a specified range. Input: spreadsheet_id, range_name. Returns: Confirmation of cleared range.
- get-spreadsheet-info Gets metadata about a spreadsheet. Input: spreadsheet_id. Returns: Title, URL, sheet information, dimensions.
- batch-update Performs multiple range updates in a single request. Input: spreadsheet_id, updates (array of range/values pairs). Returns: Total update statistics.