Google Sheets MCP Server

Instructions

Implementation Reference

• src/index.ts:200-217 (handler)

  The main handler function that executes the read_sheet tool by fetching the specified range of values from a Google Spreadsheet using the Google Sheets API v4 and returning the data as JSON.

  async function readSheet(spreadsheetId: string, range: string) {
    const authClient = await auth.getClient();
    const sheets = google.sheets({ version: "v4", auth: authClient as any });
  
    const response = await sheets.spreadsheets.values.get({
      spreadsheetId,
      range,
    });
  
    return {
      content: [
        {
          type: "text",
          text: JSON.stringify(response.data.values || [], null, 2),
        },
      ],
    };
  }

• src/index.ts:38-55 (schema)

  The tool definition including name, description, and input schema for validating parameters spreadsheetId and range.

  {
    name: "read_sheet",
    description: "スプレッドシートの指定された範囲のデータを読み取ります",
    inputSchema: {
      type: "object",
      properties: {
        spreadsheetId: {
          type: "string",
          description: "スプレッドシートのID",
        },
        range: {
          type: "string",
          description: "読み取る範囲（例: 'Sheet1!A1:C10'）",
        },
      },
      required: ["spreadsheetId", "range"],
    },
  },

• src/index.ts:160-162 (registration)

  The dispatch case in the CallToolRequestSchema handler that registers and invokes the readSheet function for the 'read_sheet' tool.

  case "read_sheet":
    return await readSheet(args.spreadsheetId as string, args.range as string);