Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PORT | No | HTTP server port | 3000 |
| LOG_LEVEL | No | Logging verbosity (e.g., info, debug, warn, error) | info |
| ENABLE_METRICS | No | Whether to enable Prometheus metrics | false |
| ENABLE_TRACING | No | Whether to enable distributed tracing | false |
| CONTEXT_MAX_TOKENS | No | Maximum tokens allowed in context | 100000 |
| ENABLE_SELF_HEALING | No | Whether to enable the circuit breaker and self-healing capabilities | true |
| ENABLE_AUDIT_LOGGING | No | Whether to enable audit logs | true |
| CIRCUIT_BREAKER_TIMEOUT | No | Reset timeout for the circuit breaker in milliseconds | 30000 |
| GOOGLE_CREDENTIALS_PATH | Yes | Path to OAuth JSON credentials file | ./credentials.json |
| CIRCUIT_BREAKER_THRESHOLD | No | Failure threshold for the circuit breaker | 5 |
| RATE_LIMIT_REQUESTS_PER_MINUTE | No | Rate limit per minute for the server | 60 |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {} |
| resources | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| create_spreadsheet | Create a new Google Spreadsheet with optional sheets |
| get_spreadsheet_metadata | Get metadata for a Google Spreadsheet including sheet info |
| get_values | Get values from a range in a spreadsheet (raw values) |
| get_values_formatted | Get values from a range with formatting applied |
| update_values | Update values in a range of cells |
| append_values | Append values to the next available row in a sheet |
| batch_update_values | Update multiple ranges in a single request |
| clear_values | Clear values from a range of cells |
| create_sheet | Create a new sheet in an existing spreadsheet |
| delete_sheet | Delete a sheet from a spreadsheet |
| update_sheet_properties | Update properties of a sheet (title, grid properties) |
| update_cells_format | Apply formatting to a range of cells |
| add_data_validation | Add data validation rules to a range |
| copy_sheet | Copy a sheet to another spreadsheet or within the same spreadsheet |
| find_and_replace | Find and replace text in a range or entire sheet |
| sort_range | Sort a range by one or more columns |
| create_protected_range | Protect a range from editing |
| execute_script_function | Execute a function in a Google Apps Script project |
| execute_script_batch | Execute multiple Apps Script functions in batch |
| get_script_metadata | Get metadata about an Apps Script project |
| list_script_deployments | List all deployments of an Apps Script project |
| create_script_deployment | Create a new deployment for an Apps Script project |
| get_auth_url | Get OAuth URL for authentication (for initial setup) |
| set_script_id | Set the Apps Script project ID for subsequent operations |
| get_server_status | Get current server status including authentication and rate limits |
| reset_circuit_breaker | Reset the circuit breaker after it has opened |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| Server Health Status | Current health status of the MCP server |
| Server Configuration | Current server configuration (sanitized) |
| Rate Limit Status | Current rate limit state |