Loading...
uvx mcp-google-sheets@latest{
"mcpServers": {
"google-sheets": {
"command": "uvx",
"args": ["mcp-google-sheets@latest"],
"env": {
"SERVICE_ACCOUNT_PATH": "/full/path/to/your/service-account-key.json",
"DRIVE_FOLDER_ID": "your_shared_folder_id_here"
}
}
}
}list_spreadsheetsLists spreadsheets within a specified Google Drive folder.
Read-only operation, no data modification.
create_spreadsheetCreates a new spreadsheet in a specified Google Drive folder.
Creates new data, but doesn't modify existing data.
get_sheet_dataRetrieves data from a specified range within a Google Sheet.
Read-only operation, no data modification.
get_sheet_formulasRetrieves formulas from a specified range within a Google Sheet.
Read-only operation, no data modification.
update_cellsWrites data to a specified range within a Google Sheet, overwriting existing data.
Modifies existing data, but within a defined range.
batch_update_cellsUpdates multiple ranges in a Google Sheet in a single API call.
Modifies existing data, but within defined ranges.
add_rowsAdds empty rows to a Google Sheet at a specified index.
Modifies the structure of the sheet, but doesn't delete data.
list_sheetsLists all sheet/tab names within a spreadsheet.
Read-only operation, no data modification.
create_sheetAdds a new sheet/tab to a spreadsheet.
Creates new data, but doesn't modify existing data.
get_multiple_sheet_dataFetches data from multiple ranges across different sheets in a spreadsheet.
Read-only operation, no data modification.
get_multiple_spreadsheet_summaryRetrieves summaries from multiple spreadsheets.
Read-only operation, no data modification.
add_columnsAdds columns to a sheet.
Modifies the structure of the sheet, but doesn't delete data.
batch_updatePerforms multiple updates to a spreadsheet in a single batch request.
Can modify spreadsheet structure and data.
copy_sheetCopies a sheet within a spreadsheet or to another spreadsheet.
Creates a copy of a sheet, potentially duplicating data.
find_in_spreadsheetFinds a specific value within a spreadsheet.
Read-only operation, no data modification.
list_foldersLists folders in Google Drive.
Read-only operation, no data modification.
rename_sheetRenames a sheet in a spreadsheet.
Modifies the name of a sheet.
search_spreadsheetsSearches for spreadsheets in Google Drive.
Read-only operation, no data modification.
share_spreadsheetShares a spreadsheet with specified users or groups.
Modifies permissions, potentially exposing data to unauthorized users.
This server provides powerful spreadsheet interaction but requires careful configuration. It's safe for read-only operations and controlled write access with tool filtering. Risky when used without proper access controls or when blindly trusting AI-generated commands.