update_script_content
Modify Google Apps Script project files by updating their source code and content directly through the MCP server integration.
Instructions
Updates the content of a specified Google Apps Script project.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| scriptId | Yes | The ID of the script project to update. | |
| files | Yes | The files to be updated in the script project. |
Implementation Reference
- The core handler function `executeFunction` that performs the HTTP PUT request to the Google Apps Script API to update project content. Handles OAuth token retrieval, request construction, API call, error handling, and logging.
const executeFunction = async ({ scriptId, files }) => { const baseUrl = 'https://script.googleapis.com'; const startTime = Date.now(); try { logger.info('SCRIPT_UPDATE_CONTENT', 'Starting script content update', { scriptId, filesCount: files?.length || 0 }); // Get OAuth access token const token = await getOAuthAccessToken(); // Construct the URL for the request const url = `${baseUrl}/v1/projects/${scriptId}/content`; // Set up headers for the request const headers = { 'Authorization': `Bearer ${token}`, 'Content-Type': 'application/json', 'Accept': 'application/json' }; // Prepare the body of the request const requestBody = { scriptId, files }; 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, filesCount: files?.length || 0, timestamp: new Date().toISOString() }; logger.error('SCRIPT_UPDATE_CONTENT', '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('SCRIPT_UPDATE_CONTENT', 'Successfully updated script content', { scriptId, filesCount: files?.length || 0, duration: Date.now() - startTime }); console.log('✅ Successfully updated script content'); return data; } catch (error) { const errorDetails = { message: error.message, stack: error.stack, scriptId, filesCount: files?.length || 0, duration: Date.now() - startTime, timestamp: new Date().toISOString(), errorType: error.name || 'Unknown' }; logger.error('SCRIPT_UPDATE_CONTENT', 'Error updating script project content', errorDetails); console.error('❌ Error updating script project content:', errorDetails); // Return detailed error information for debugging return { error: true, message: error.message, details: errorDetails, rawError: { name: error.name, stack: error.stack } }; } }; - Input schema (JSON Schema) defining required parameters: `scriptId` (string) and `files` (array of file objects with properties like name, type, source).
parameters: { type: 'object', properties: { scriptId: { type: 'string', description: 'The ID of the script project to update.' }, files: { type: 'array', items: { type: 'object', properties: { name: { type: 'string', description: 'The name of the file.' }, lastModifyUser: { type: 'object', properties: { photoUrl: { type: 'string' }, domain: { type: 'string' }, name: { type: 'string' }, email: { type: 'string' } } }, type: { type: 'string', description: 'The type of the file.' }, updateTime: { type: 'string' }, source: { type: 'string' }, createTime: { type: 'string' }, functionSet: { type: 'object', properties: { values: { type: 'array', items: { type: 'object', properties: { parameters: { type: 'array', items: { type: 'object', properties: { value: { type: 'string' } } } }, name: { type: 'string' } } } } } } } }, description: 'The files to be updated in the script project.' } }, required: ['scriptId', 'files'] } - tools/google-app-script-api/apps-script-api/script-projects-update-content.js:126-197 (registration)Local tool registration as `apiTool` export, containing the handler function reference and full tool definition including name 'update_script_content' and schema.
const apiTool = { function: executeFunction, definition: { type: 'function', function: { name: 'update_script_content', description: 'Updates the content of a specified Google Apps Script project.', parameters: { type: 'object', properties: { scriptId: { type: 'string', description: 'The ID of the script project to update.' }, files: { type: 'array', items: { type: 'object', properties: { name: { type: 'string', description: 'The name of the file.' }, lastModifyUser: { type: 'object', properties: { photoUrl: { type: 'string' }, domain: { type: 'string' }, name: { type: 'string' }, email: { type: 'string' } } }, type: { type: 'string', description: 'The type of the file.' }, updateTime: { type: 'string' }, source: { type: 'string' }, createTime: { type: 'string' }, functionSet: { type: 'object', properties: { values: { type: 'array', items: { type: 'object', properties: { parameters: { type: 'array', items: { type: 'object', properties: { value: { type: 'string' } } } }, name: { type: 'string' } } } } } } } }, description: 'The files to be updated in the script project.' } }, required: ['scriptId', 'files'] } } } }; - lib/tools.js:8-64 (registration)Central dynamic registration/discovery of all tools: imports modules from toolPaths, validates apiTool export, wraps handler with logging, and returns array of registered tools.
export async function discoverTools() { logger.info('DISCOVERY', `Starting tool discovery for ${toolPaths.length} tool paths`); const toolPromises = toolPaths.map(async (file) => { try { logger.debug('DISCOVERY', `Loading tool from: ${file}`); const module = await import(`../tools/${file}`); if (!module.apiTool) { logger.warn('DISCOVERY', `Tool file missing apiTool export: ${file}`); return null; } const toolName = module.apiTool.definition?.function?.name; if (!toolName) { logger.warn('DISCOVERY', `Tool missing function name: ${file}`); return null; } // Wrap the original function with logging const originalFunction = module.apiTool.function; const wrappedFunction = withLogging(toolName, originalFunction); logger.debug('DISCOVERY', `Successfully loaded tool: ${toolName}`, { file, toolName, description: module.apiTool.definition?.function?.description }); return { ...module.apiTool, function: wrappedFunction, path: file, }; } catch (error) { logger.error('DISCOVERY', `Failed to load tool: ${file}`, { file, error: { message: error.message, stack: error.stack } }); return null; } }); const tools = (await Promise.all(toolPromises)).filter(Boolean); logger.info('DISCOVERY', `Tool discovery completed`, { totalPaths: toolPaths.length, successfullyLoaded: tools.length, failed: toolPaths.length - tools.length, toolNames: tools.map(t => t.definition?.function?.name).filter(Boolean) }); return tools; } - tools/paths.js:1-18 (registration)Configuration file listing all tool file paths for discovery, including the path to the update_script_content tool implementation.
export const toolPaths = [ 'google-app-script-api/apps-script-api/script-projects-deployments-delete.js', 'google-app-script-api/apps-script-api/script-projects-create.js', 'google-app-script-api/apps-script-api/script-projects-versions-create.js', 'google-app-script-api/apps-script-api/script-projects-deployments-create.js', 'google-app-script-api/apps-script-api/script-projects-deployments-update.js', 'google-app-script-api/apps-script-api/script-projects-deployments-list.js', 'google-app-script-api/apps-script-api/script-projects-update-content.js', 'google-app-script-api/apps-script-api/script-projects-deployments-get.js', 'google-app-script-api/apps-script-api/script-scripts-run.js', 'google-app-script-api/apps-script-api/script-projects-get.js', 'google-app-script-api/apps-script-api/script-processes-list-script-processes.js', 'google-app-script-api/apps-script-api/script-projects-get-metrics.js', 'google-app-script-api/apps-script-api/script-projects-get-content.js', 'google-app-script-api/apps-script-api/script-projects-versions-list.js', 'google-app-script-api/apps-script-api/script-projects-versions-get.js', 'google-app-script-api/apps-script-api/script-processes-list.js' ];