打开文档前更新Google工作表数据

const { google } = require('googleapis');
const sheets = google.sheets('v4');

async function updateData(spreadsheetId, range, valueInputOption, values) {
  const auth = await getAuth();
  const response = await sheets.spreadsheets.values.update({
    auth,
    spreadsheetId,
    range,
    valueInputOption,
    resource: { values }
  });
  console.log(`${response.data.updatedCells} cells updated.`);
}

async function getAuth() {
  const authClient = new google.auth.GoogleAuth({
    scopes: ['https://www.googleapis.com/auth/spreadsheets']
  });
  const authClientConfig = {
    projectId: 'your-project-id',
    clientId: 'your-client-id',
    clientSecret: 'your-client-secret'
  };
  await authClient.loadAuthFromCookieAndToken(authClientConfig);
  return authClient;
}

// 示例调用
updateData('your-spreadsheet-id', 'Sheet1!A1:B2', 'RAW', [['New Value1', 'New Value2']]);