.

Select "Anyone" for "Who has access to the app:". In this sample, a simple approach allows requests without an access token. However, a custom API key is used for accessing the Web App.

Click "Deploy".

On the script editor, at the top right, click "Deploy" -> "Test deployments".

Copy the Web App URL. It will be similar to https://script.google.com/macros/s/###/exec.

It is important to note that when you modify the Google Apps Script for the Web App, you must modify the deployment as a new version. This ensures the modified script is reflected in the Web App. Please be careful about this. Also, you can find more details on this in my report "Redeploying Web Apps without Changing URL of Web Apps for new IDE".

5. Prepare for testing: Claude Desktop

To test this Web App, Claude Desktop is used. Ref In this case, the claude_desktop_config.json is configured as follows. Please replace https://script.google.com/macros/s/###/exec with your Web App URL.

In this sample, a value of sample is used as an access key for accessing the Web App. In the current stage, it seems that to use the MCP server through the HTTP request with Claude Desktop, mcp-remote is required to be used.

{
  "mcpServers": {
    "gas_web_apps": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "https://script.google.com/macros/s/###/exec?accessKey=sample"
      ],
      "env": {}
    }
  }
}

I could also test the MCP server with the Web Apps using Copilot for Visual Studio Code. In that case, the following setting is used.

"mcp": {
  "inputs": [],
  "servers": {
    "gas_web_apps": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "https://script.google.com/macros/s/###/exec?accessKey=sample"
      ],
      "env": {}
    }
  }
}

6. Testing

When Claude Desktop is run, you can see that gas_web_apps of the MCP server is installed as follows.

The function search_files_on_Google_Drive is called by the tools/call method from the MCP client.

The function search_schedule_on_Google_Calendar is called by the tools/call method from the MCP client.

The function search_files_from_Google_Drive is called by the prompts/get method from the MCP client.

The function get_today_schedule is called by the resources/read method from the MCP client. In this sample, the 3 events above are loaded.

Options

1. Logging

The following logging options are available in this library.

If you want to see the logs between the MCP client and the MCP server, please use the following script. Please prepare a sample Spreadsheet and set the Spreadsheet ID to spreadsheetId. Doing this will create a "Log" sheet in the Spreadsheet, and the logs will be stored there. This will be useful for understanding the communication between the MCP client and the MCP server.

/**
 * This function is automatically run when the MCP client accesses Web Apps.
 */
function doPost(eventObject) {
  const spreadsheetId = "###"; // Please set the Spreadsheet ID.

  const object = {

Categories

Current Category: gas-library

MCPApp