为列表中的每个项目创建新工作表的Javascript代码

const { google } = require('googleapis');
const auth = new google.auth.GoogleAuth({
  keyFile: 'credentials.json',
  scopes: ['https://www.googleapis.com/auth/spreadsheets'],
});

async function createNewSheet() {
  const client = await auth.getClient();
  const sheets = google.sheets({ version: 'v4', auth: client });

  const spreadsheetId = 'YOUR_SPREADSHEET_ID';
  const sheetNames = ['Project A', 'Project B', 'Project C']; // 列表中的每个项目

  for (const sheetName of sheetNames) {
    const request = {
      spreadsheetId,
      resource: {
        properties: {
          title: sheetName,
        },
      },
    };

    try {
      const response = await sheets.spreadsheets.sheets.copyTo(request);
      console.log(`New sheet created: ${response.data.title}`);
    } catch (error) {
      console.error(`Failed to create sheet: ${sheetName}`);
      console.error(error);
    }
  }
}

createNewSheet();