Google Apps Script MCP Server

Instructions

Implementation Reference

• tools/google-app-script-api/apps-script-api/script-projects-deployments-get.js:12-67 (handler)

  Main handler function that executes the logic to retrieve a specific Apps Script project deployment via the Google API using OAuth authentication, with comprehensive error handling.

  const executeFunction = async ({ scriptId, deploymentId }) => {
    const baseUrl = 'https://script.googleapis.com';
    const url = `${baseUrl}/v1/projects/${scriptId}/deployments/${deploymentId}`;
  
    try {
      // Get OAuth access token
      const token = await getOAuthAccessToken();
      
      // Set up headers for the request
      const headers = {
        'Authorization': `Bearer ${token}`,
        'Accept': 'application/json'
      };
  
      // Perform the fetch request
      const response = await fetch(url, {
        method: 'GET',
        headers
      });
  
      // Check if the response was successful
      if (!response.ok) {
        const errorText = await response.text();
        console.error('API Error Response:', errorText);
        throw new Error(`HTTP ${response.status}: ${errorText}`);
      }
  
      // Parse and return the response data
      const data = await response.json();
      return data;
    } catch (error) {
      const errorDetails = {
        message: error.message,
        stack: error.stack,
        scriptId,
        deploymentId,
        timestamp: new Date().toISOString(),
        errorType: error.name || 'Unknown'
      };
  
      logger.error('DEPLOYMENT_GET', 'Error retrieving deployment', errorDetails);
      
      console.error('❌ Error retrieving deployment:', errorDetails);
      
      // Return detailed error information for debugging
      return { 
        error: true,
        message: error.message,
        details: errorDetails,
        rawError: {
          name: error.name,
          stack: error.stack
        }
      };
    }
  };

• tools/google-app-script-api/apps-script-api/script-projects-deployments-get.js:78-94 (schema)

  JSON schema defining the tool's name, description, input parameters (scriptId and deploymentId as required strings), used for MCP tool validation.

    name: 'script_projects_deployments_get',
    description: 'Get a deployment of an Apps Script project.',
    parameters: {
      type: 'object',
      properties: {
        scriptId: {
          type: 'string',
          description: 'The ID of the script project.'
        },
        deploymentId: {
          type: 'string',
          description: 'The ID of the deployment to retrieve.'
        }
      },
      required: ['scriptId', 'deploymentId']
    }
  }

• tools/google-app-script-api/apps-script-api/script-projects-deployments-get.js:73-96 (registration)

  The apiTool object that registers the handler function and schema definition for the MCP tool system, exported for import into central tool registry.

  const apiTool = {
    function: executeFunction,
    definition: {
      type: 'function',
      function: {
        name: 'script_projects_deployments_get',
        description: 'Get a deployment of an Apps Script project.',
        parameters: {
          type: 'object',
          properties: {
            scriptId: {
              type: 'string',
              description: 'The ID of the script project.'
            },
            deploymentId: {
              type: 'string',
              description: 'The ID of the deployment to retrieve.'
            }
          },
          required: ['scriptId', 'deploymentId']
        }
      }
    }
  };

• tools/paths.js:9-9 (helper)

  Path listing used likely for dynamic import and registration of all Apps Script API tools in the MCP system.

  'google-app-script-api/apps-script-api/script-projects-deployments-get.js',