如何从Google Sheets nodejs获取单元格颜色

npm install googleapis

const { google } = require('googleapis');
const auth = new google.auth.GoogleAuth({
  // 这里填写你的Google Sheets API凭证信息
  keyFile: 'path/to/your/credentials.json',
  scopes: ['https://www.googleapis.com/auth/spreadsheets'],
});
const sheets = google.sheets({ version: 'v4', auth });

async function getCellColor(spreadsheetId, sheetName, cellRange) {
  try {
    const response = await sheets.spreadsheets.get({
      spreadsheetId,
      ranges: [`${sheetName}!${cellRange}`],
      fields: 'sheets.data.rowData.values.effectiveFormat.backgroundColor',
    });

    const color = response.data.sheets[0].data[0].rowData[0].values[0].effectiveFormat.backgroundColor;
    return color;
  } catch (error) {
    console.error('Error retrieving cell color:', error);
    return null;
  }
}

// 使用示例
const spreadsheetId = 'your-spreadsheet-id';
const sheetName = 'Sheet1';
const cellRange = 'A1';

getCellColor(spreadsheetId, sheetName, cellRange)
  .then((color) => {
    console.log('Cell color:', color);
  })
  .catch((error) => {
    console.error('Error:', error);
  });