Google Apps Script MCP Server

Instructions

Implementation Reference

• tools/google-app-script-api/apps-script-api/script-projects-deployments-update.js:15-123 (handler)

  Main handler function that executes the deployment update via Google Apps Script API using fetch PUT request with error handling and logging.

  const executeFunction = async ({ scriptId, deploymentId, deploymentConfig }) => {
    const baseUrl = 'https://script.googleapis.com';
    const token = process.env.GOOGLE_APP_SCRIPT_API_API_KEY;
    const apiKey = process.env.GOOGLE_APP_SCRIPT_API_API_KEY;
    const startTime = Date.now();
  
    try {
      logger.info('DEPLOYMENT_UPDATE', 'Starting deployment update', { 
        scriptId, 
        deploymentId, 
        versionNumber: deploymentConfig?.versionNumber 
      });
  
      // Construct the URL for the request
      const url = `${baseUrl}/v1/projects/${scriptId}/deployments/${deploymentId}?key=${apiKey}&prettyPrint=true`;
  
      // Set up headers for the request
      const headers = {
        'Content-Type': 'application/json',
        'Accept': 'application/json',
        'Authorization': `Bearer ${token}`
      };
  
      // Prepare the body of the request
      const requestBody = { deploymentConfig };
      const body = JSON.stringify(requestBody);
  
      logger.logAPICall('PUT', url, headers, requestBody);
  
      // Perform the fetch request
      const fetchStartTime = Date.now();
      const response = await fetch(url, {
        method: 'PUT',
        headers,
        body
      });
      
      const fetchDuration = Date.now() - fetchStartTime;
      const responseSize = response.headers.get('content-length') || 'unknown';
      
      logger.logAPIResponse('PUT', url, response.status, fetchDuration, responseSize);
  
      // Check if the response was successful
      if (!response.ok) {
        const errorText = await response.text();
        let errorData;
        
        try {
          errorData = JSON.parse(errorText);
        } catch (parseError) {
          errorData = { message: errorText };
        }
  
        const detailedError = {
          status: response.status,
          statusText: response.statusText,
          url,
          errorResponse: errorData,
          duration: Date.now() - startTime,
          scriptId,
          deploymentId,
          timestamp: new Date().toISOString()
        };
  
        logger.error('DEPLOYMENT_UPDATE', 'API request failed', detailedError);
        
        console.error('❌ API Error Details:', JSON.stringify(detailedError, null, 2));
        
        throw new Error(`API Error (${response.status}): ${errorData.error?.message || errorData.message || 'Unknown error'}`);
      }
  
      // Parse and return the response data
      const data = await response.json();
      
      logger.info('DEPLOYMENT_UPDATE', 'Successfully updated deployment', {
        scriptId,
        deploymentId,
        duration: Date.now() - startTime
      });
      
      console.log('✅ Successfully updated deployment');
      return data;
    } catch (error) {
      const errorDetails = {
        message: error.message,
        stack: error.stack,
        scriptId,
        deploymentId,
        duration: Date.now() - startTime,
        timestamp: new Date().toISOString(),
        errorType: error.name || 'Unknown'
      };
  
      logger.error('DEPLOYMENT_UPDATE', 'Error updating deployment', errorDetails);
      
      console.error('❌ Error updating 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-update.js:133-169 (schema)

  JSON schema defining the tool's name, description, input parameters (scriptId, deploymentId, deploymentConfig with subproperties), and required fields.

    function: {
      name: 'script_projects_deployments_update',
      description: 'Updates a deployment of an Apps Script project.',
      parameters: {
        type: 'object',
        properties: {
          scriptId: {
            type: 'string',
            description: 'The ID of the script to update.'
          },
          deploymentId: {
            type: 'string',
            description: 'The ID of the deployment to update.'
          },
          deploymentConfig: {
            type: 'object',
            properties: {
              manifestFileName: {
                type: 'string',
                description: 'The name of the manifest file.'
              },
              versionNumber: {
                type: 'integer',
                description: 'The version number of the deployment.'
              },
              description: {
                type: 'string',
                description: 'A description of the deployment.'
              }
            },
            required: ['manifestFileName', 'versionNumber', 'description']
          }
        },
        required: ['scriptId', 'deploymentId', 'deploymentConfig']
      }
    }
  }

• tools/paths.js:6-6 (registration)

  The tool file path is listed in the central paths export, likely used for dynamic registration or loading of tools.

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