使用node.js查询谷歌工作表并返回行

npm install googleapis

const { google } = require('googleapis');
const key = require('./path/to/service-account-key.json');

const client = new google.auth.JWT(
  key.client_email,
  null,
  key.private_key,
  ['https://www.googleapis.com/auth/spreadsheets']
);

client.authorize(function(err, tokens) {
  if (err) {
    console.error(err);
    return;
  }
  // 授权成功，可以进行查询操作
});

const sheets = google.sheets({ version: 'v4', auth: client });

sheets.spreadsheets.values.get({
  spreadsheetId: 'your-spreadsheet-id',
  range: 'Sheet1!A1:C',
}, (err, res) => {
  if (err) {
    console.error(err);
    return;
  }
  const rows = res.data.values;
  if (rows.length) {
    console.log('行数据：');
    rows.forEach(row => {
      console.log(`${row[0]}, ${row[1]}, ${row[2]}`);
    });
  } else {
    console.log('没有找到数据。');
  }
});