Google Sheets MCP Server

Instructions

Implementation Reference

• src/index.ts:220-245 (handler)

  The handler function that executes the write_sheet tool logic, using Google Sheets API to update values in the specified range.

  async function writeSheet(
    spreadsheetId: string,
    range: string,
    values: string[][]
  ) {
    const authClient = await auth.getClient();
    const sheets = google.sheets({ version: "v4", auth: authClient as any });
  
    const response = await sheets.spreadsheets.values.update({
      spreadsheetId,
      range,
      valueInputOption: "RAW",
      requestBody: {
        values,
      },
    });
  
    return {
      content: [
        {
          type: "text",
          text: `データが正常に書き込まれました。更新されたセル数: ${response.data.updatedCells}`,
        },
      ],
    };
  }

• src/index.ts:59-82 (schema)

  The input schema defining parameters for the write_sheet tool: spreadsheetId, range, and values (2D array).

  inputSchema: {
    type: "object",
    properties: {
      spreadsheetId: {
        type: "string",
        description: "スプレッドシートのID",
      },
      range: {
        type: "string",
        description: "書き込む範囲（例: 'Sheet1!A1:C10'）",
      },
      values: {
        type: "array",
        items: {
          type: "array",
          items: {
            type: "string",
          },
        },
        description: "書き込むデータ（2次元配列）",
      },
    },
    required: ["spreadsheetId", "range", "values"],
  },

• src/index.ts:163-168 (registration)

  The switch case in the CallToolRequestSchema handler that registers and dispatches to the writeSheet function for write_sheet tool calls.

  case "write_sheet":
    return await writeSheet(
      args.spreadsheetId as string,
      args.range as string,
      args.values as string[][]
    );

• src/index.ts:56-83 (registration)

  The tool definition object in the tools array used for ListToolsRequestSchema, registering the write_sheet tool's name, description, and schema.

  {
    name: "write_sheet",
    description: "スプレッドシートの指定された範囲にデータを書き込みます",
    inputSchema: {
      type: "object",
      properties: {
        spreadsheetId: {
          type: "string",
          description: "スプレッドシートのID",
        },
        range: {
          type: "string",
          description: "書き込む範囲（例: 'Sheet1!A1:C10'）",
        },
        values: {
          type: "array",
          items: {
            type: "array",
            items: {
              type: "string",
            },
          },
          description: "書き込むデータ（2次元配列）",
        },
      },
      required: ["spreadsheetId", "range", "values"],
    },
  },