{"slug":"Prajapdh/sheets-mcp-server","name":"Google Sheets","description":"A server for comprehensive Google Sheets integration, requiring Google OAuth credentials.","category":"productivity","tags":[],"official":false,"stars":0,"transport":null,"install":[{"cmd":"npx @modelcontextprotocol/inspector","imports":[]}],"tools":[{"name":"create-spreadsheet","description":"Creates a new Google Sheets spreadsheet. Input: title (required), sheet_names (optional array). Returns: Spreadsheet ID, URL, and created sheet names."},{"name":"read-range","description":"Reads data from a specific range. Input: spreadsheet_id, range_name (e.g., 'Sheet1!A1:C10'). Returns: 2D array of cell values."},{"name":"write-range","description":"Writes data to a specific range (overwrites existing data). Input: spreadsheet_id, range_name, values (2D array). Returns: Update statistics."},{"name":"append-rows","description":"Appends rows to the end of a range. Input: spreadsheet_id, range_name, values (2D array). Returns: Update statistics."},{"name":"clear-range","description":"Clears all data from a specified range. Input: spreadsheet_id, range_name. Returns: Confirmation of cleared range."},{"name":"get-spreadsheet-info","description":"Gets metadata about a spreadsheet. Input: spreadsheet_id. Returns: Title, URL, sheet information, dimensions."},{"name":"batch-update","description":"Performs multiple range updates in a single request. Input: spreadsheet_id, updates (array of range/values pairs). Returns: Total update statistics."}],"env_vars":[],"auth_type":"none","github":"https://github.com/Prajapdh/sheets-mcp-server","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Mon May 25"}