📊 MCP Google Sheets Server
A Model Context Protocol (MCP) server for interacting with Google Sheets.
MCP Endpoint
/api/mcpAvailable Tools
- get_sheet_data
- get_sheet_formulas
- update_cells
- batch_update_cells
- add_rows
- add_columns
- list_sheets
- copy_sheet
- rename_sheet
- get_multiple_sheet_data
- get_multiple_spreadsheet_summary
- create_spreadsheet
- create_sheet
- list_spreadsheets
- share_spreadsheet
- list_folders
- batch_update
Configuration
Set the following environment variables in your Vercel project:
CREDENTIALS_CONFIG- Base64 encoded service account JSONGOOGLE_SERVICE_ACCOUNT_KEY- Direct JSON string (alt)GOOGLE_CLIENT_EMAIL+GOOGLE_PRIVATE_KEY- Individual fields (alt)DRIVE_FOLDER_ID- Default folder ID (optional)