Which integrations are available for this server?

Enables automation and workflow integration by allowing AI agents to interact with and execute Google Apps Script. Provides tools for spreadsheet operations, data engineering, and dataset management, allowing AI agents to read, write, and analyze data within Google Sheets.

How do I use GAS MCP Server Advanced?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@GAS MCP Server Advanced Create a pivot table and summary chart for the sales data in my current sheet" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

GAS MCP Server Advanced

by devfinprojects

Overview Schema Related Servers Score Discussions

TypeScript

Remote

flowchart LR
    subgraph "🤖 AI Agents"
        A[MCP Client]
    end
    
    subgraph "🔷 MCP Server"
        B[Tool Registry]
        C[Rate Limiter]
        D[Context Engine]
        E[Security Layer]
    end
    
    subgraph "📊 Google APIs"
        F[Sheets API]
        G[Apps Script]
        H[Drive API]
    end
    
    A -->|JSON-RPC| B
    B --> C --> D --> E --> F
    E --> G
    E --> H
    
    style A fill:#1a1a2e,stroke:#00d9ff,color:#fff
    style B fill:#16213e,stroke:#a855f7,color:#fff
    style C fill:#0f3460,stroke:#22c55e,color:#fff
    style D fill:#1a1a2e,stroke:#f59e0b,color:#fff
    style E fill:#0f0f23,stroke:#ef4444,color:#fff
    style F fill:#1e3a5f,stroke:#3b82f6,color:#fff
    style G fill:#1e3a5f,stroke:#3b82f6,color:#fff
    style H fill:#1e3a5f,stroke:#3b82f6,color:#fff

⭐ Star us on GitHub	📖 Read the Docs	💬 Join Discord	🐛 Report Issues

✨ Features

Context Intelligence

Token estimation • Compression • Semantic search • Dataset management

100K+ tokens supported

100+ MCP Tools

Spreadsheet ops • AI analysis • Automation workflows • Data pipelines

Comprehensive coverage

Self-Healing

Circuit breaker • Auto-retry • Error recovery • Health checks

99.9% uptime

Adaptive Rate Limiting

Per-agent limits • Per-API quotas • Sliding windows • Backoff strategy

Smart throttling

Enterprise Security

RBAC • AES-256 encryption • OAuth2 • Audit logging • SOC2 ready

Bank-grade protection

Complete Observability

Metrics • Tracing • Health checks • Alerting • Audit logs

Full visibility

🏗️ Architecture

╔═══════════════════════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                                          GOOGLE APPS SCRIPT MCP SERVER                                              ║
║                                                  HIGH-LEVEL ARCHITECTURE                                             ║
╠═══════════════════════════════════════════════════════════════════════════════════════════════════════════════════════╣
║                                                                                                                                 ║
║      ┌──────────────────────────────────────────────────────────────────────────────────────────────────────────────┐   ║
║      │                                                    🤖 MCP CLIENT (AI AGENT)                                   │   ║
║      │                                                         ┌──────────────┐                                       │   ║
║      │                                                         │ JSON-RPC 2.0 │                                       │   ║
║      │                                                         │  SSE Stream  │                                       │   ║
║      │                                                         └──────┬───────┘                                       │   ║
║      └───────────────────────────────────────────────────────────────┼───────────────────────────────────────────────┘   ║
║                                                                  │                                                    ║
║                                                                  ▼                                                    ║
║      ┌──────────────────────────────────────────────────────────────────────────────────────────────────────────────┐   ║
║      │                                                   🔷 MCP SERVER                                                │   ║
║      │  ┌──────────────────────────────────────────────────────────────────────────────────────────────────────────┐  │   ║
║      │  │                                     📦 SERVER MANAGEMENT LAYER                                          │  │   ║
║      │  │  ┌────────────────┐     ┌───────────────────┐     ┌────────────────────────┐     ┌─────────────────┐   │  │   ║
║      │  │  │   ⚙️ Config   │     │   🖥️ Server        │     │     🗂️ Tool            │     │   🔒 Auth       │   │  │   ║
║      │  │  │   Manager     │     │   Manager          │     │     Registry          │     │   Manager       │   │  │   ║
║      │  │  └────────────────┘     └───────────────────┘     └────────────────────────┘     └─────────────────┘   │  │   ║
║      │  └──────────────────────────────────────────────────────────────────────────────────────────────────────────┘  │   ║
║      │                                                                                                                 │   ║
║      │  ┌──────────────────────────────────────────────────────────────────────────────────────────────────────────┐  │   ║
║      │  │                                🧠 CONTEXT INTELLIGENCE LAYER                                              │  │   ║
║      │  │  ┌────────────────┐     ┌───────────────────┐     ┌────────────────────────┐     ┌─────────────────┐   │  │   ║
║      │  │  │   📊 Context  │     │   🎯 Token        │     │     💾 Dataset         │     │   🗄️ Embedding │   │  │   ║
║      │  │  │   Manager     │     │   Estimator       │     │     Store              │     │   Store         │   │  │   ║
║      │  │  └────────────────┘     └───────────────────┘     └────────────────────────┘     └─────────────────┘   │  │   ║
║      │  │  ┌────────────────┐     ┌───────────────────┐     ┌────────────────────────┐     ┌─────────────────┐   │  │   ║
║      │  │  │   🗜️ Compress │     │   💨 Memory      │     │     🔍 Semantic        │     │   📐 Truncator │   │  │   ║
║      │  │  │   or          │     │   Cache          │     │     Search             │     │                 │   │  │   ║
║      │  │  └────────────────┘     └───────────────────┘     └────────────────────────┘     └─────────────────┘   │  │   ║
║      │  └──────────────────────────────────────────────────────────────────────────────────────────────────────────┘  │   ║
║      │                                                                                                                 │   ║
║      │  ┌──────────────────────────────────────────────────────────────────────────────────────────────────────────┐  │   ║
║      │  │                                     🔌 MIDDLEWARE LAYER                                                     │  │   ║
║      │  │  ┌────────────────┐     ┌───────────────────┐     ┌────────────────────────┐     ┌─────────────────┐   │  │   ║
║      │  │  │   ⏱️ Rate     │     │   🔄 Interceptor  │     │     ⚠️ Error           │     │   📝 Prompt    │   │  │   ║
║      │  │  │   Limiter     │     │   Chain           │     │     Handler           │     │   Manager       │   │  │   ║
║      │  │  └────────────────┘     └───────────────────┘     └────────────────────────┘     └─────────────────┘   │  │   ║
║      │  └──────────────────────────────────────────────────────────────────────────────────────────────────────────┘  │   ║
║      │                                                                                                                 │   ║
║      │  ┌──────────────────────────────────────────────────────────────────────────────────────────────────────────┐  │   ║
║      │  │                                     🔐 SECURITY LAYER                                                       │  │   ║
║      │  │  ┌────────────────┐     ┌───────────────────┐     ┌────────────────────────┐     ┌─────────────────┐   │  │   ║
║      │  │  │   🛡️ Access  │     │   🔏 Encryption  │     │     🔎 Threat          │     │   ✅ Compliance │   │  │   ║
║      │  │  │   Control     │     │                   │     │     Detection          │     │                 │   │  │   ║
║      │  │  └────────────────┘     └───────────────────┘     └────────────────────────┘     └─────────────────┘   │  │   ║
║      │  └──────────────────────────────────────────────────────────────────────────────────────────────────────────┘  │   ║
║      │                                                                                                                 │   ║
║      │  ┌──────────────────────────────────────────────────────────────────────────────────────────────────────────┐  │   ║
║      │  │                                    📈 OBSERVABILITY LAYER                                                  │  │   ║
║      │  │  ┌──────────┐  ┌──────────┐  ┌──────────┐  ┌───────────┐  ┌───────────┐  ┌────────────────┐           │  │   ║
║      │  │  │  📊      │  │  ❤️       │  │  🔍      │  │   📋      │  │   🔔       │  │    📜         │           │  │   ║
║      │  │  │ Metrics  │  │ Health   │  │ Tracing  │  │  Audit    │  │ Alerting   │  │    Logging    │           │  │   ║
║      │  │  └──────────┘  └──────────┘  └──────────┘  └───────────┘  └───────────┘  └────────────────┘           │  │   ║
║      │  └──────────────────────────────────────────────────────────────────────────────────────────────────────────┘  │   ║
║      │                                                                                                                 │   ║
║      │  ┌──────────────────────────────────────────────────────────────────────────────────────────────────────────┐  │   ║
║      │  │                                    💚 SELF-HEALING LAYER                                                   │  │   ║
║      │  │  ┌────────────────┐     ┌───────────────────┐     ┌────────────────────────┐                          │  │   ║
║      │  │  │   🔄 Circuit │     │   🔁 Auto        │     │     🩺 Health          │                          │  │   ║
║      │  │  │   Breaker    │     │   Retry         │     │     Monitor            │                          │  │   ║
║      │  │  └────────────────┘     └───────────────────┘     └────────────────────────┘                          │  │   ║
║      │  └──────────────────────────────────────────────────────────────────────────────────────────────────────────┘  │   ║
║      └───────────────────────────────────────────────────────────────────────────────────────────────────────────────┘   ║
║                                                                  │                                                    ║
║                                                                  ▼                                                    ║
║      ┌───────────────────────────────────────────────────────────────────────────────────────────────────────────────┐   ║
║      │                                                📱 GOOGLE APIS                                                │   ║
║      │   ┌──────────────────────┐     ┌────────────────────────┐     ┌─────────────────────────────────────────┐    │   ║
║      │   │       📊            │     │        📜              │     │              📁                       │    │   ║
║      │   │    Sheets API       │     │    Apps Script API     │     │            Drive API                   │    │   ║
║      │   └──────────────────────┘     └────────────────────────┘     └─────────────────────────────────────────┘    │   ║
║      └───────────────────────────────────────────────────────────────────────────────────────────────────────────────┘   ║
╚═══════════════════════════════════════════════════════════════════════════════════════════════════════════════════════╝

Request Flow

┌──────────┐     ┌───────────────┐     ┌────────────────┐     ┌──────────────┐     ┌────────────────┐
│  Client  │────►│     Tool      │────►│      Rate     │────►│    Context   │────►│     Auth       │
│ Request  │     │    Registry   │     │    Limiter    │     │    Engine    │     │    Layer       │
└──────────┘     └───────────────┘     └────────────────┘     └──────────────┘     └───────┬────────┘
                                                                                                │
      ┌───────────────────────────────────────────────────────────────────────────────────────┘
      │
      ▼
┌──────────────┐     ┌────────────────┐     ┌─────────────┐
│   Google     │────►│   Response     │────►│    Client   │
│     APIs     │     │    Builder     │     │   Response  │
└──────────────┘     └────────────────┘     └─────────────┘

Circuit Breaker State Machine

                            ┌───────────────────┐
                            │   🔴 CLOSED       │
                            │    (Normal Ops)   │
                            └─────────┬─────────┘
                                      │
                     failures > threshold
                                      │
                                      ▼
                            ┌───────────────────┐
                            │   🟠 OPEN STATE   │
                            │ (Rejecting Reqs)  │
                            └─────────┬─────────┘
                                      │
                           timer expires
                                      │
                                      ▼
                            ┌───────────────────┐
                            │  🟡 HALF-OPEN     │
                            │   (Test Mode)     │
                            └─────────┬─────────┘
                                      │
           ┌──────────────────────────┼──────────────────────────┐
           │                          │                          │
      success ✓                   success ✓                failure ✗
           │                          │                          │
           ▼                          ▼                          ▼
    ┌─────────────┐           ┌─────────────┐           ┌─────────────┐
    │   CLOSED    │           │   CLOSED    │           │    OPEN     │
    │   ✅        │           │   ✅        │           │     🔴      │
    └─────────────┘           └─────────────┘           └─────────────┘

🚀 Quick Start

Prerequisites

Installation

# Clone the repository
git clone https://github.com/devfinprojects/GAS-MCPSERVER.git
cd GAS-MCPSERVER

# Install dependencies
npm install

# Build the project
npm run build

Environment Setup

# Copy example environment file
cp env.example .env

# Edit configuration
#nano .env  # Linux/Mac
#notepad .env  # Windows

🔧 Configuration

Variable	Description	Default	Required
`GOOGLE_CREDENTIALS_PATH`	Path to OAuth JSON	`./credentials.json`	✅ Yes
`PORT`	HTTP server port	`3000`	❌ No
`LOG_LEVEL`	Logging verbosity	`info`	❌ No
`RATE_LIMIT_REQUESTS_PER_MINUTE`	Rate limit per minute	`60`	❌ No
`CONTEXT_MAX_TOKENS`	Max context tokens	`100000`	❌ No
`ENABLE_SELF_HEALING`	Enable circuit breaker	`true`	❌ No
`ENABLE_METRICS`	Enable Prometheus metrics	`false`	❌ No
`ENABLE_TRACING`	Enable distributed tracing	`false`	❌ No
`ENABLE_AUDIT_LOGGING`	Enable audit logs	`true`	❌ No
`CIRCUIT_BREAKER_THRESHOLD`	Failure threshold	`5`	❌ No
`CIRCUIT_BREAKER_TIMEOUT`	Reset timeout (ms)	`30000`	❌ No

🛠️ Tools Reference

╔══════════════════════════════════════════════════════════════════════════════════════════════════════════╗
║                                    100+ MCP TOOLS BREAKDOWN                                             ║
╠══════════════════════════════════════════════════════════════════════════════════════════════════════════╣
║                                                                                                          ║
║   ┌──────────────┐  ┌──────────────┐  ┌──────────────┐  ┌──────────────┐  ┌──────────────┐             ║
║   │      🤖      │  │      ⚡      │  │      📊     │  │      🧠     │  │      📝      │             ║
║   │      AI      │  │  AUTOMATION  │  │ DATA ENGR   │  │   CONTEXT   │  │ CODE QUALITY │             ║
║   │    TOOLS     │  │    TOOLS     │  │    TOOLS    │  │    TOOLS    │  │    TOOLS     │             ║
║   │              │  │              │  │             │  │             │  │              │             ║
║   │ • Analysis   │  │ • Jobs       │  │ • ETL       │  │ • Datasets  │  │ • Analysis   │             ║
║   │ • Anomaly    │  │ • Workflows  │  │ • Import    │  │ • Query     │  │ • Review     │             ║
║   │ • Patterns   │  │ • Webhooks   │  │ • Export    │  │ • Control   │  │ • Doc Gen    │             ║
║   │ • Transform  │  │ • Triggers   │  │ • Mapping   │  │             │  │ • Test Gen   │             ║
║   │ • NLQ       │  │ • Notifs     │  │ • Pipeline  │  │             │  │ • Types      │             ║
║   │ • Recommen-  │  │ • Scheduled  │  │ • Validation│  │             │  │              │             ║
║   │   dations   │  │              │  │             │  │             │  │              │             ║
║   │              │  │              │  │             │  │             │  │              │             ║
║   │    35+       │  │     25+      │  │     25+     │  │     15+     │  │     25+      │             ║
║   └──────────────┘  └──────────────┘  └──────────────┘  └──────────────┘  └──────────────┘             ║
║                                                                                                          ║
╚══════════════════════════════════════════════════════════════════════════════════════════════════════════╝

🤖 AI Analysis Tools (35+ tools)

Tool Category	Tools	Description
📈 Analysis	8 tools	Data analysis, column analysis, summaries
🔍 Anomaly Detection	4 tools	Outlier detection, unusual values
🔁 Pattern Recognition	5 tools	Patterns, sequences, cycles, distributions
🔮 Recommendations	4 tools	Improvements, chart suggestions
🧹 Transformation	5 tools	Data cleaning, reshaping, aggregation
💬 Natural Language	5 tools	NL to spreadsheet, formula generation

Analysis Tools

Tool Name	Parameters	Return Type	Example
`analyze_sheet_data`	`spreadsheetId, range`	`{ analysis }`	`{ "name": "analyze_sheet_data", "args": { "spreadsheetId": "abc" } }`
`analyze_column`	`spreadsheetId, range, column`	`{ stats }`	`{ "name": "analyze_column", "args": { "spreadsheetId": "abc", "column": "A" } }`
`get_data_summary`	`spreadsheetId`	`{ summary }`	`{ "name": "get_data_summary", "args": { "spreadsheetId": "abc" } }`

Anomaly Detection

Tool Name	Parameters	Return Type	Example
`detect_outliers`	`spreadsheetId, range, method`	`{ outliers }`	`{ "name": "detect_outliers", "args": { "spreadsheetId": "abc" } }`
`analyze_anomalies`	`spreadsheetId, timeRange`	`{ anomalies }`	`{ "name": "analyze_anomalies", "args": { "spreadsheetId": "abc" } }`
`find_unusual_values`	`spreadsheetId, column`	`{ values }`	`{ "name": "find_unusual_values", "args": { "spreadsheetId": "abc" } }`

Pattern Recognition

Tool Name	Parameters	Return Type	Example
`detect_patterns`	`spreadsheetId, range`	`{ patterns }`	`{ "name": "detect_patterns", "args": { "spreadsheetId": "abc" } }`
`find_sequences`	`spreadsheetId, column`	`{ sequences }`	`{ "name": "find_sequences", "args": { "spreadsheetId": "abc" } }`
`detect_cycles`	`spreadsheetId, range`	`{ cycles }`	`{ "name": "detect_cycles", "args": { "spreadsheetId": "abc" } }`

Transformation

Tool Name	Parameters	Return Type	Example
`clean_sheet_data`	`spreadsheetId, rules`	`{ cleaned }`	`{ "name": "clean_sheet_data", "args": { "spreadsheetId": "abc" } }`
`transform_data`	`spreadsheetId, transforms`	`{ result }`	`{ "name": "transform_data", "args": { "spreadsheetId": "abc" } }`
`reshape_data`	`spreadsheetId, pivotConfig`	`{ reshaped }`	`{ "name": "reshape_data", "args": { "spreadsheetId": "abc" } }`

Natural Language Query

Tool Name	Parameters	Return Type	Example
`nl_to_spreadsheet_action`	`query, spreadsheetId`	`{ action }`	`{ "name": "nl_to_spreadsheet_action", "args": { "query": "add column" } }`
`generate_formula`	`description, context`	`{ formula }`	`{ "name": "generate_formula", "args": { "description": "sum of column" } }`
`query_data_nl`	`query, spreadsheetId`	`{ results }`	`{ "name": "query_data_nl", "args": { "query": "sales > 1000" } }`

⚡ Automation Tools (25+ tools)

Tool Category	Tools	Description
📅 Job Scheduler	8 tools	Create, manage, trigger scheduled jobs
🔀 Workflows	7 tools	Multi-step automation workflows
🪝 Webhooks	9 tools	Event-driven triggers
⏰ Triggers	6 tools	Spreadsheet trigger management
🔔 Notifications	12 tools	Alerts and notifications

Job Scheduler

Tool Name	Parameters	Return Type
`create_scheduled_job`	`name, schedule, action`	`{ jobId }`
`list_scheduled_jobs`	`filters`	`{ jobs }`
`get_scheduled_job`	`jobId`	`{ job }`
`update_scheduled_job`	`jobId, updates`	`{ updated }`
`delete_scheduled_job`	`jobId`	`{ deleted }`
`trigger_job_now`	`jobId`	`{ triggered }`
`pause_scheduled_job`	`jobId`	`{ paused }`
`resume_scheduled_job`	`jobId`	`{ resumed }`

Workflows

Tool Name	Parameters	Return Type
`create_workflow`	`name, steps`	`{ workflowId }`
`list_workflows`	`filters`	`{ workflows }`
`get_workflow`	`workflowId`	`{ workflow }`
`run_workflow`	`workflowId, inputs`	`{ result }`
`stop_workflow`	`workflowId`	`{ stopped }`
`validate_workflow`	`workflow`	`{ valid }`

Webhooks

Tool Name	Parameters	Return Type
`register_webhook`	`url, events, secret`	`{ webhookId }`
`list_webhooks`	`filters`	`{ webhooks }`
`delete_webhook`	`webhookId`	`{ deleted }`
`test_webhook`	`webhookId`	`{ result }`
`enable_webhook`	`webhookId`	`{ enabled }`
`disable_webhook`	`webhookId`	`{ disabled }`

📊 Data Engineering Tools (25+ tools)

Tool Category	Tools	Description
🔄 ETL	5 tools	Extract, transform, load pipelines
📥 Import/Export	6 tools	CSV, JSON, batch operations
🗺️ Mapping	5 tools	Schema detection and mapping
📦 Pipeline	5 tools	Data pipeline management
✅ Validation	5 tools	Data quality and schema validation

ETL Tools

Tool Name	Parameters	Return Type
`extract_spreadsheet_data`	`spreadsheetId, range, options`	`{ data }`
`transform_data_batch`	`data, transforms`	`{ transformed }`
`load_to_spreadsheet`	`spreadsheetId, data, options`	`{ loaded }`
`run_etl_pipeline`	`config`	`{ result }`

Import/Export

Tool Name	Parameters	Return Type
`import_csv`	`url, spreadsheetId, options`	`{ imported }`
`export_csv`	`spreadsheetId, range, options`	`{ url }`
`import_json`	`data, spreadsheetId`	`{ imported }`
`export_json`	`spreadsheetId, range`	`{ data }`
`convert_format`	`source, targetFormat`	`{ converted }`
`batch_export`	`spreadsheetIds, format`	`{ results }`

Pipeline

Tool Name	Parameters	Return Type
`create_pipeline`	`config`	`{ pipelineId }`
`run_pipeline`	`pipelineId, inputs`	`{ result }`
`get_pipeline_status`	`pipelineId`	`{ status }`
`list_pipelines`	`filters`	`{ pipelines }`
`delete_pipeline`	`pipelineId`	`{ deleted }`

🧠 Context Tools (15+ tools)

Tool Category	Tools	Description
💾 Dataset	5 tools	Store, query, manage datasets
🔍 Query	4 tools	Search and retrieve context
🎛️ Control	6 tools	Context mode and optimization

Dataset Tools

Tool Name	Parameters	Return Type
`store_dataset`	`name, data, schema`	`{ datasetId }`
`query_dataset`	`datasetId, filters`	`{ rows }`
`list_datasets`	`filters`	`{ datasets }`
`delete_dataset`	`datasetId`	`{ deleted }`
`update_dataset`	`datasetId, data`	`{ updated }`

Query Tools

Tool Name	Parameters	Return Type
`semantic_search`	`query, datasetId`	`{ results }`
`get_dataset_stats`	`datasetId`	`{ stats }`
`get_token_usage`	`sessionId`	`{ usage }`
`dataset_exists`	`datasetId`	`{ exists }`

Context Control

Tool Name	Parameters	Return Type
`estimate_context_cost`	`spreadsheetId, range`	`{ tokens, cost }`
`set_context_mode`	`mode`	`{ mode }`
`get_context_config`	—	`{ config }`
`reset_session_tokens`	`sessionId`	`{ reset }`
`process_through_context`	`data, options`	`{ processed }`

📝 Code Quality Tools (25+ tools)

Tool Category	Tools	Description
📊 Analysis	5 tools	Code quality and complexity
👀 Review	3 tools	Automated code reviews
📚 Documentation	4 tools	JSDoc generation
🧪 Test Generation	3 tools	Unit test creation
✅ Type Checking	3 tools	Type validation

Analysis Tools

Tool Name	Parameters	Return Type
`analyze_code_quality`	`code, includeComplexity`	`{ metrics }`
`analyze_complexity`	`code`	`{ complexity }`
`analyze_dependencies`	`code`	`{ deps }`

Code Review

Tool Name	Parameters	Return Type
`perform_code_review`	`code`	`{ issues }`
`check_best_practices`	`code`	`{ violations }`
`suggest_improvements`	`code`	`{ suggestions }`

Documentation

Tool Name	Parameters	Return Type
`generate_jsdoc`	`code`	`{ docs }`
`generate_readme`	`project`	`{ readme }`
`update_comments`	`code`	`{ updated }`

Test Generation

Tool Name	Parameters	Return Type
`generate_unit_tests`	`code, framework`	`{ tests }`
`generate_integration_tests`	`code`	`{ tests }`
`generate_mocks`	`code`	`{ mocks }`

🔐 Security

┌─────────────────────────────────────────────────────────────────────────────────────┐
│                              🔐 SECURITY ARCHITECTURE                                │
├─────────────────────────────────────────────────────────────────────────────────────┤
│                                                                                     │
│   ┌─────────────┐     ┌─────────────┐     ┌─────────────┐     ┌─────────────┐     │
│   │   🔒 OAuth2 │────►│   🛡️ RBAC   │────►│  🔏 AES-256 │────►│   📋 Audit  │     │
│   │  + Token    │     │  + Roles    │     │  Encryption │     │   Logging   │     │
│   │   Refresh   │     │  + Perms    │     │  + at Rest   │     │   + SOC2    │     │
│   └─────────────┘     └─────────────┘     └─────────────┘     └─────────────┘     │
│                                                                                     │
└─────────────────────────────────────────────────────────────────────────────────────┘

✅ OAuth2 with automatic token refresh
✅ Role-Based Access Control (RBAC)
✅ AES-256 encryption at rest
✅ Comprehensive audit logging
✅ SOC2 and GDPR ready
✅ Threat detection and prevention

📈 Observability

┌─────────────────────────────────────────────────────────────────────────────────────┐
│                           📈 OBSERVABILITY DASHBOARD                               │
├─────────────────────────────────────────────────────────────────────────────────────┤
│                                                                                     │
│   ┌────────────────┐  ┌────────────────┐  ┌────────────────┐  ┌────────────────┐│
│   │     📊        │  │      ❤️        │  │      🔍       │  │      🔔       ││
│   │   METRICS     │  │    HEALTH      │  │   TRACING     │  │   ALERTING    ││
│   │                │  │                │  │                │  │                ││
│   │ Prometheus    │  │  Liveness     │  │  Distributed  │  │  Rule-based   ││
│   │  Compatible   │  │  + Readiness  │  │    Spans      │  │  Notifications││
│   │                │  │                │  │                │  │                ││
│   │ • Request     │  │  • /health    │  │ • Jaeger      │  │ • Email       ││
│   │   Rate        │  │  • /ready      │  │   Compatible  │  │ • Slack       ││
│   │ • Latency     │  │  • Custom      │  │ • Custom      │  │ • Webhook     ││
│   │ • Errors      │  │    Checks      │  │   Tags        │  │ • PagerDuty   ││
│   └────────────────┘  └────────────────┘  └────────────────┘  └────────────────┘│
│                                                                                     │
│   ┌─────────────────────────────────────────────────────────────────────────────────┐│
│   │                              📜 AUDIT LOGGING                                  ││
│   │                                                                                 ││
│   │  • Every API call logged    • User/agent tracking    • Immutable records    ││
│   │  • Queryable logs           • Export to SIEM          • Retention policies    ││
│   └─────────────────────────────────────────────────────────────────────────────────┘│
└─────────────────────────────────────────────────────────────────────────────────────┘

💚 Self-Healing

┌─────────────────────────────────────────────────────────────────────────────────────┐
│                          💚 SELF-HEALING MECHANISMS                                 │
├─────────────────────────────────────────────────────────────────────────────────────┤
│                                                                                     │
│   ┌────────────────┐  ┌────────────────┐  ┌────────────────┐                      │
│   │  🔄 CIRCUIT    │  │  🔁 AUTO       │  │  🩺 HEALTH    │                      │
│   │   BREAKER     │  │    RETRY       │  │   MONITOR     │                      │
│   │                │  │                │  │                │                      │
│   │  • Open       │  │  • Exponential │  │  • Periodic   │                      │
│   │  • Half-Open │  │    Backoff     │  │    Checks     │                      │
│   │  • Closed    │  │  • Max Attempts│  │  • Recovery   │                      │
│   │                │  │  • Jitter     │  │    Actions    │                      │
│   └────────────────┘  └────────────────┘  └────────────────┘                      │
│                                                                                     │
│   ═══════════════════════════════════════════════════════════════════════════════   │
│                                                                                     │
│   Configuration:                                                                     │
│   ┌─────────────────────────────────────────────────────────────────────────────┐   │
│   │  circuitBreaker: { failureThreshold: 5, resetTimeoutMs: 30000 }           │   │
│   │  maxRetries: 3, backoffMultiplier: 2, maxBackoffMs: 30000                  │   │
│   │  healthCheckInterval: 10000, recoveryThreshold: 3                          │   │
│   └─────────────────────────────────────────────────────────────────────────────┘   │
└─────────────────────────────────────────────────────────────────────────────────────┘

📦 Examples

import { createClient } from '@modelcontextprotocol/sdk';

const client = await createClient({
  serverUrl: 'http://localhost:3000',
  auth: { token: process.env.MCP_TOKEN }
});

// Create a new spreadsheet
const spreadsheet = await client.tools.create_spreadsheet({
  title: 'Sales Dashboard 2024',
  sheets: [
    { title: 'Q1 Data', rowCount: 1000, columnCount: 26 },
    { title: 'Q2 Data', rowCount: 1000, columnCount: 26 },
    { title: 'Summary', rowCount: 100, columnCount: 10 }
  ]
});

console.log(`Created: ${spreadsheet.spreadsheetId}`);

// Add data to the spreadsheet
await client.tools.update_values({
  spreadsheetId: spreadsheet.spreadsheetId,
  range: 'Q1 Data!A1',
  values: [
    ['Product', 'Revenue', 'Quantity'],
    ['Widget A', 15000, 150],
    ['Widget B', 23000, 230],
    ['Widget C', 18000, 180]
  ]
});

// Analyze spreadsheet data with AI
const analysis = await client.tools.analyze_sheet_data({
  spreadsheetId: 'abc123',
  range: 'Sales!A1:Z1000',
  includeCharts: true,
  generateInsights: true
});

console.log('Analysis Results:');
console.log(`- Total Rows: ${analysis.summary.rowCount}`);
console.log(`- Columns: ${analysis.summary.columns.join(', ')}`);
console.log(`- Insights: ${analysis.insights.length}`);

// Detect anomalies in the data
const anomalies = await client.tools.detect_outliers({
  spreadsheetId: 'abc123',
  range: 'Sales!B1:B1000',
  method: 'iqr',
  threshold: 1.5
});

console.log(`Found ${anomalies.outliers.length} outliers`);

// Create and run an ETL pipeline
const pipeline = await client.tools.create_pipeline({
  name: 'Daily Sales ETL',
  schedule: '0 2 * * *',  // 2 AM daily
  steps: [
    {
      id: 'extract',
      type: 'extract',
      source: {
        type: 'spreadsheet',
        spreadsheetId: 'source-id',
        range: 'Raw Data!A1:Z'
      }
    },
    {
      id: 'transform',
      type: 'transform',
      operations: [
        { type: 'filter', condition: { column: 'status', equals: 'active' } },
        { type: 'map', mappings: { old_col: 'new_col' } },
        { type: 'aggregate', groupBy: 'region', operations: ['sum', 'avg', 'count'] }
      ]
    },
    {
      id: 'load',
      type: 'load',
      destination: {
        type: 'spreadsheet',
        spreadsheetId: 'dest-id',
        sheet: 'Processed'
      }
    }
  ]
});

// Run the pipeline
const result = await client.tools.run_pipeline({
  pipelineId: pipeline.pipelineId,
  inputs: {}
});

console.log(`Processed ${result.rowsProcessed} rows in ${result.duration}ms`);

🤝 Contribution

# 1. Fork the repository
# 2. Clone your fork
git clone https://github.com/YOUR_USERNAME/GAS-MCPSERVER.git

# 3. Create a feature branch
git checkout -b feature/amazing-feature

# 4. Install dependencies
npm install

# 5. Make your changes
# 6. Run tests
npm test

# 7. Build the project
npm run build

# 8. Commit and push
git commit -m 'Add amazing feature'
git push origin feature/amazing-feature

# 9. Open a Pull Request

Development Scripts

Script	Description
`npm run build`	Compile TypeScript
`npm run start`	Start production server
`npm run dev`	Start development server
`npm test`	Run tests
`npm run test:watch`	Run tests in watch mode

📄 License

Install Server

license - not found

quality

maintenance

How are these scores calculated?

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

View all tools

Latest Blog Posts

Lightport: Open-Sourcing Glama's AI Gateway
By punkpeye on April 27, 2026.
open source
OpenAI
Tool Definition Quality Score (TDQS)
By punkpeye on April 3, 2026.
mcp
The Hackers Who Tracked My Sleep Cycle
By punkpeye on March 26, 2026.
security

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