whichguy/gas_mcp

# Clone the repository
git clone https://github.com/whichguy/mcp_gas.git
cd mcp_gas

# Install dependencies
npm install

# Build the project
npm run build

# Copy your OAuth credentials
cp path/to/your/credentials.json oauth-config.json

# Run validation script
./validate-setup.sh

# Start the server
npm start

// 1. Authenticate with Google
await gas_auth({ mode: "start" });

// 2. Create a new project
const project = await gas_project_create({ 
  title: "My First Calculator" 
});

// 3. Add source code
await gas_write({
  path: `${project.scriptId}/calculator`,
  content: `
    function add(a, b) {
      return a + b;
    }
    
    function fibonacci(n) {
      if (n <= 1) return n;
      return fibonacci(n - 1) + fibonacci(n - 2);
    }
  `
});

// 4. Execute code directly
const result = await gas_run({
  scriptId: project.scriptId,
  js_statement: "add(5, 3)"
});
console.log(result); // 8

// 5. Run complex calculations
const fibResult = await gas_run({
  scriptId: project.scriptId,
  js_statement: "fibonacci(10)"
});
console.log(fibResult); // 55

{
  "mcpServers": {
    "mcp-gas": {
      "command": "node",
      "args": ["/path/to/mcp_gas/dist/src/index.js"],
      "env": {
        "NODE_ENV": "production"
      }
    }
  }
}

{
  "oauth": {
    "client_id": "your-oauth-client-id.apps.googleusercontent.com",
    "type": "uwp",
    "redirect_uris": ["http://127.0.0.1/*", "http://localhost/*"],
    "scopes": ["https://www.googleapis.com/auth/script.projects", "..."]
  },
  "projects": {
    "my-project": {
      "scriptId": "1ABC...XYZ",
      "name": "my-project",
      "description": "My project description"
    }
  },
  "environments": {
    "dev": { "scriptId": "1ABC...XYZ", "name": "my-project" }
  },
  "localRoot": {
    "rootPath": "/Users/you/src/mcp_gas/gas-projects",
    "lastUpdated": "2025-06-29T16:47:43.135Z"
  },
  "server": {
    "defaultWorkingDir": "/Users/you/src/mcp_gas",
    "configVersion": "1.0.0",
    "lastModified": "2025-06-29T16:47:43.135Z"
  }
}

# Using npm (recommended)
npm start

# Direct invocation
node dist/src/index.js --config ./mcp-gas-config.json

# Custom config location
node dist/src/index.js --config /path/to/custom-config.json

{
  "mcpServers": {
    "mcp-gas": {
      "command": "node",
      "args": [
        "/Users/you/src/mcp_gas/dist/src/index.js",
        "--config",
        "/Users/you/src/mcp_gas/mcp-gas-config.json"
      ],
      "env": {
        "NODE_ENV": "production"
      }
    }
  }
}

// Check current authentication status
await gas_auth({ mode: "status" });

// Start OAuth flow (opens browser)
await gas_auth({ mode: "start" });

// Logout and clear credentials
await gas_auth({ mode: "logout" });

// Create a new project
const project = await gas_project_create({
  title: "Data Analytics Suite",
  parentId: "optional_drive_folder_id"
});

// List all accessible projects
const projects = await gas_ls({ path: "" });

// Get detailed project information
const info = await gas_info({ 
  projectId: project.scriptId,
  includeContent: true 
});

// Write a new file
await gas_write({
  path: `${scriptId}/utils/helpers`,
  content: `
    function formatDate(date) {
      return new Date(date).toISOString().split('T')[0];
    }
    
    function validateEmail(email) {
      const re = /^[^\s@]+@[^\s@]+\.[^\s@]+$/;
      return re.test(email);
    }
  `,
  position: 0  // Execute first
});

// Read file contents
const content = await gas_cat({
  path: `${scriptId}/utils/helpers`
});

// Copy file to new location
await gas_cp({
  from: `${scriptId}/utils/helpers`,
  to: `${scriptId}/shared/utilities`
});

// Move/rename file
await gas_mv({
  from: `${scriptId}/shared/utilities`,
  to: `${scriptId}/lib/common`
});

// Execute simple expressions
await gas_run({
  scriptId: scriptId,
  js_statement: "Math.PI * 2"
});

// Call custom functions
await gas_run({
  scriptId: scriptId,
  js_statement: "formatDate(new Date())"
});

// Access Google Services
await gas_run({
  scriptId: scriptId,
  js_statement: "DriveApp.getRootFolder().getName()"
});

// Execute complex operations
await gas_run({
  scriptId: scriptId,
  js_statement: `
    const sheet = SpreadsheetApp.create('Analytics Data');
    const id = sheet.getId();
    sheet.getActiveSheet().getRange('A1').setValue('Hello World');
    return id;
  `
});

// Create a version (required for deployment)
const version = await gas_version_create({
  scriptId: scriptId,
  description: "Initial release with analytics functions"
});

// Deploy as web app
const deployment = await gas_deploy_create({
  scriptId: scriptId,
  entryPointType: "WEB_APP",
  webAppAccess: "ANYONE",
  webAppExecuteAs: "USER_ACCESSING",
  versionNumber: version.versionNumber
});

// Deploy as API executable
const apiDeployment = await gas_deploy_create({
  scriptId: scriptId,
  entryPointType: "EXECUTION_API",
  accessLevel: "ANYONE",
  versionNumber: version.versionNumber
});

// Execute via API (requires deployment)
const apiResult = await gas_run_api_exec({
  scriptId: scriptId,
  functionName: "formatDate",
  parameters: [new Date()]
});

{
  "client_id": "your-client-id.apps.googleusercontent.com",
  "client_secret": "your-client-secret",
  "redirect_uris": ["http://localhost:3000/oauth/callback"],
  "auth_uri": "https://accounts.google.com/o/oauth2/auth",
  "token_uri": "https://oauth2.googleapis.com/token"
}

# Optional: Override OAuth client ID
export GOOGLE_OAUTH_CLIENT_ID="your-client-id"

# Optional: Set custom OAuth port
export OAUTH_PORT="3000"

# Optional: Enable debug logging
export DEBUG="mcp:*"

# Optional: Set custom timeout
export REQUEST_TIMEOUT="30000"

{
  "mcpServers": {
    "mcp-gas": {
      "command": "node",
      "args": ["/absolute/path/to/mcp_gas/dist/src/index.js"],
      "env": {
        "NODE_ENV": "production",
        "DEBUG": "mcp:error"
      }
    }
  }
}

// Create analytics project
const project = await gas_project_create({
  title: "Spreadsheet Analytics"
});

// Add analytics functions
await gas_write({
  path: `${project.scriptId}/analytics`,
  content: `
    function analyzeSheet(sheetId) {
      const sheet = SpreadsheetApp.openById(sheetId);
      const data = sheet.getActiveSheet().getDataRange().getValues();
      
      return {
        rows: data.length,
        columns: data[0]?.length || 0,
        lastUpdate: sheet.getLastUpdate().toISOString()
      };
    }
    
    function generateReport(sheetIds) {
      return sheetIds.map(id => ({
        sheetId: id,
        analysis: analyzeSheet(id)
      }));
    }
  `
});

// Execute analytics
const report = await gas_run({
  scriptId: project.scriptId,
  js_statement: `generateReport(["sheet_id_1", "sheet_id_2"])`
});

// Create email automation project
const emailProject = await gas_project_create({
  title: "Email Automation Suite"
});

// Add email functions
await gas_write({
  path: `${emailProject.scriptId}/email`,
  content: `
    function sendWelcomeEmail(recipient, name) {
      const subject = "Welcome to Our Platform!";
      const body = \`
        Hello \${name},
        
        Welcome to our platform! We're excited to have you on board.
        
        Best regards,
        The Team
      \`;
      
      GmailApp.sendEmail(recipient, subject, body);
      return \`Email sent to \${recipient}\`;
    }
    
    function getUnreadCount() {
      return GmailApp.getInboxUnreadCount();
    }
  `
});

// Send welcome email
await gas_run({
  scriptId: emailProject.scriptId,
  js_statement: `sendWelcomeEmail("user@example.com", "John Doe")`
});

// Check unread emails
const unreadCount = await gas_run({
  scriptId: emailProject.scriptId,
  js_statement: "getUnreadCount()"
});

// Find existing spreadsheet and bind script
const driveFiles = await gas_find_drive_script({
  fileName: "Sales Data"
});

if (driveFiles.containers.length > 0) {
  // Bind script to spreadsheet
  const binding = await gas_bind_script({
    containerName: "Sales Data",
    scriptName: "Data Processor"
  });
  
  // Add functions to bound script
  await gas_write({
    path: `${binding.scriptId}/processor`,
    content: `
      function onOpen() {
        const ui = SpreadsheetApp.getUi();
        ui.createMenu('Data Tools')
          .addItem('Process Data', 'processCurrentSheet')
          .addToUi();
      }
      
      function processCurrentSheet() {
        const sheet = SpreadsheetApp.getActiveSheet();
        const data = sheet.getDataRange().getValues();
        
        // Process data logic here
        Browser.msgBox('Data processed successfully!');
      }
    `
  });
}

# Development workflow
npm run dev                # Watch mode compilation
npm run build             # Production build
npm run clean             # Clean build artifacts

# Code quality
npm run lint              # Run ESLint
npm run lint:fix          # Fix linting issues

# Testing
npm test                  # Run core tests
npm run test:unit         # Unit tests only
npm run test:system       # System integration tests
npm run test:workflow     # End-to-end workflow tests
npm run test:all          # Run all test suites

import { BaseTool } from './base.js';

export class MyNewTool extends BaseTool {
  public name = "my_new_tool";
  public description = "Description of what this tool does";
  public inputSchema = {
    type: "object" as const,
    properties: {
      parameter1: {
        type: "string",
        description: "Parameter description"
      }
    },
    required: ["parameter1"]
  };

  async execute(args: any): Promise<any> {
    // Implementation here
  }
}

# Quick validation
npm test

# Comprehensive testing
npm run test:all

# Integration tests (requires OAuth setup)
npm run test:workflow

# Specific test suites
npm run test:unit         # Unit tests only
npm run test:system       # System tests only
npm run test:gas-run      # Execution engine tests

# Enable integration testing
export GAS_INTEGRATION_TEST=true

# Optional: Use custom OAuth credentials
export GOOGLE_OAUTH_CLIENT_ID="test-client-id"

# Solution: Check OAuth configuration
cat oauth-config.json  # Verify credentials exist
./validate-setup.sh    # Run comprehensive validation

# Solution: Check browser setup
export BROWSER=chrome  # Set preferred browser
npm start             # Restart server

# Check Cursor configuration
# Ensure absolute paths in mcpServers config
# Restart Cursor IDE after configuration changes

# Validate Node.js version
node --version  # Should be ≥18.0.0

# Rebuild project
npm run clean && npm install && npm run build

# Check Google Apps Script quota limits
# Verify project permissions
# Try simpler code execution first

# Check project permissions
# Verify file paths (no extensions needed)
# Ensure authentication is valid

# Enable all debug output
export DEBUG=mcp:*
npm start

# Enable specific debug categories
export DEBUG=mcp:auth,mcp:execution
npm start

./validate-setup.sh