Loading...
This MCP server bridges AI clients to Google Sheets, enabling read/write operations, spreadsheet management, and data manipulation via natural language commands.
Boost this tool
Subscribe to listing upgrades or segmented pushes.
This MCP server bridges AI clients to Google Sheets, enabling read/write operations, spreadsheet management, and data manipulation via natural language commands.
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.
Performance depends on the size of the spreadsheet and the complexity of the operations. Batch operations are generally more efficient than individual API calls.
Google Sheets API usage is subject to rate limits and quotas. High-volume operations may incur costs.
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"
}
}
}
}SERVICE_ACCOUNT_PATHDRIVE_FOLDER_IDCREDENTIALS_CONFIGGOOGLE_APPLICATION_CREDENTIALSlist_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.
Environment Variable
cloud
https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/spreadsheetsThis 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.
Autonomy is limited by the permissions granted to the service account or OAuth credentials. Exercise caution when granting write access to AI agents.
Production Tip
Use tool filtering to limit the scope of operations and reduce the risk of unintended consequences.
Service Accounts (recommended) and OAuth 2.0 via environment variables.
Use the `--include-tools` command-line argument or the `ENABLED_TOOLS` environment variable.
Using a Service Account with restricted permissions is the most secure approach.
The Spreadsheet ID is part of the URL of the spreadsheet.
No, this server primarily focuses on data manipulation and retrieval. Chart creation is not directly supported.
The server will return an error. Implement retry logic in your client application to handle rate limiting.
No, version control and rollback are not directly supported. Consider using Google Sheets' built-in version history or implementing your own backup mechanism.