create_sheet
Create a new sheet within an existing Google Spreadsheet to organize data, add tabs for different datasets, or structure information in separate sections.
Instructions
新しいシートを作成します
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheetName | Yes | 作成するシート名 | |
| spreadsheetId | Yes | スプレッドシートのID |
Implementation Reference
- src/index.ts:309-336 (handler)The main handler function `createSheet` that creates a new sheet in the specified spreadsheet using the Google Sheets API's batchUpdate method with an addSheet request.async function createSheet(spreadsheetId: string, sheetName: string) { const authClient = await auth.getClient(); const sheets = google.sheets({ version: "v4", auth: authClient as any }); const response = await sheets.spreadsheets.batchUpdate({ spreadsheetId, requestBody: { requests: [ { addSheet: { properties: { title: sheetName, }, }, }, ], }, }); return { content: [ { type: "text", text: `シート "${sheetName}" が正常に作成されました。`, }, ], }; }
- src/index.ts:126-139 (schema)Input schema definition for the create_sheet tool, specifying required parameters: spreadsheetId and sheetName.inputSchema: { type: "object", properties: { spreadsheetId: { type: "string", description: "スプレッドシートのID", }, sheetName: { type: "string", description: "作成するシート名", }, }, required: ["spreadsheetId", "sheetName"], },
- src/index.ts:123-140 (registration)Tool definition object for create_sheet included in the tools array, used for listing available tools.{ name: "create_sheet", description: "新しいシートを作成します", inputSchema: { type: "object", properties: { spreadsheetId: { type: "string", description: "スプレッドシートのID", }, sheetName: { type: "string", description: "作成するシート名", }, }, required: ["spreadsheetId", "sheetName"], }, },
- src/index.ts:180-181 (registration)Switch case in CallToolRequestHandler that dispatches execution of create_sheet to the handler function.case "create_sheet": return await createSheet(args.spreadsheetId as string, args.sheetName as string);