根据行中单元格中的值将特定行复制到新的google sheet (JavaScript)

const { google } = require('googleapis');

async function copyRowsToNewSheet() {
  // 通过服务账号密钥进行身份验证
  const auth = new google.auth.GoogleAuth({
    keyFile: 'path/to/service-account-key.json',
    scopes: ['https://www.googleapis.com/auth/spreadsheets'],
  });
  const client = await auth.getClient();

  // 创建 Google Sheets API 客户端
  const sheets = google.sheets({ version: 'v4', auth: client });

  try {
    // 读取源表格的数据
    const sourceSpreadsheetId = 'source-spreadsheet-id';
    const sourceSheetName = 'source-sheet-name';
    const sourceRange = `${sourceSheetName}!A1:Z`;
    const response = await sheets.spreadsheets.values.get({
      spreadsheetId: sourceSpreadsheetId,
      range: sourceRange,
    });
    const sourceData = response.data.values;

    // 根据特定条件筛选出需要复制的行
    const targetRows = sourceData.filter(row => {
      // 根据行中特定单元格的值进行筛选，可以根据实际需求修改条件
      const targetCellValue = row[0]; // 假设需要根据第一列的值进行筛选
      return targetCellValue === '特定值';
    });

    // 创建新的目标表格
    const targetSpreadsheetId = 'target-spreadsheet-id';
    const targetSheetName = 'target-sheet-name';
    const targetRange = `${targetSheetName}!A1:Z`;
    await sheets.spreadsheets.values.update({
      spreadsheetId: targetSpreadsheetId,
      range: targetRange,
      valueInputOption: 'USER_ENTERED',
      resource: { values: targetRows },
    });

    console.log('复制成功！');
  } catch (error) {
    console.error('复制失败：', error);
  }
}

copyRowsToNewSheet();