GAS MCP Server Advanced
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_spreadsheetB | Create a new Google Spreadsheet with optional sheets |
| get_spreadsheet_metadataC | Get metadata for a Google Spreadsheet including sheet info |
| get_valuesC | Get values from a range in a spreadsheet (raw values) |
| get_values_formattedC | Get values from a range with formatting applied |
| update_valuesC | Update values in a range of cells |
| append_valuesB | Append values to the next available row in a sheet |
| batch_update_valuesC | Update multiple ranges in a single request |
| clear_valuesC | Clear values from a range of cells |
| create_sheetC | Create a new sheet in an existing spreadsheet |
| delete_sheetC | Delete a sheet from a spreadsheet |
| update_sheet_propertiesC | Update properties of a sheet (title, grid properties) |
| update_cells_formatC | Apply formatting to a range of cells |
| add_data_validationC | Add data validation rules to a range |
| copy_sheetC | Copy a sheet to another spreadsheet or within the same spreadsheet |
| find_and_replaceC | Find and replace text in a range or entire sheet |
| sort_rangeC | Sort a range by one or more columns |
| create_protected_rangeC | Protect a range from editing |
| execute_script_functionC | Execute a function in a Google Apps Script project |
| execute_script_batchC | Execute multiple Apps Script functions in batch |
| get_script_metadataB | Get metadata about an Apps Script project |
| list_script_deploymentsB | List all deployments of an Apps Script project |
| create_script_deploymentC | Create a new deployment for an Apps Script project |
| get_auth_urlB | Get OAuth URL for authentication (for initial setup) |
| set_script_idB | Set the Apps Script project ID for subsequent operations |
| get_server_statusB | Get current server status including authentication and rate limits |
| reset_circuit_breakerB | 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 |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/devfinprojects/GAS_MCPSERVER_ADAVANCED'
If you have feedback or need assistance with the MCP directory API, please join our Discord server