spreadsheet.js

// const creds = require('./google-sheets-node/client_secret.json');
// const { promisify } = require('util');
//
//
// async function accesssSpreadsheet(){
//   const doc = new GoogleSpreadsheet('1kU4AhgzqQWYGxvbK8Fj4wA6eSO_IWcBZJYcTVcEUhEY')
//   await promisify(doc.useServiceAccountAuth)(creds);
//   const info = await promisify(doc.getInfo)();
//   const sheet = info.worksheets[0];
//   console.log(`Title: ${sheet.title}, Rows: ${sheet.rowCount}`);
// }
//
// accesssSpreadsheet();
const { GoogleSpreadsheet } = require('google-spreadsheet');
const creds = require('./client_secret.json');

// spreadsheet key is the long id in the sheets URL
const doc = new GoogleSpreadsheet('1kU4AhgzqQWYGxvbK8Fj4wA6eSO_IWcBZJYcTVcEUhEY');

async function accessSpreadsheet() {
  await doc.useServiceAccountAuth({
    client_email: creds.client_email,
    private_key: creds.private_key,
  });

  await doc.loadInfo(); // loads document properties and worksheets
  console.log(doc.title);


  const sheet = doc.sheetsByIndex[0]; // or use doc.sheetsById[id]
  const rows = await sheet.getRows();
  const c6 = sheet.getCellByA1
  // const testCell = await sheet.getCell(0, 0);
  console.log(sheet.title);
  console.log(sheet.rowCount);

  await sheet.loadCells('A1:F31'); // loads a range of cells
  console.log(sheet.cellStats); // total cells, loaded, how many non-empty
  const a1 = sheet.getCell(1, 0); // access cells using a zero-based index
  console.log(sheet.getCell(1, 0).value);
  for(let i = 0; i < rows.length; i++){
    let currentCell = sheet.getCell(i,0)
    if(currentCell.value == "Ellen"){
      console.log(sheet.getCell(i,1).value);
    }
      }

  // for(let i = 0; i < rows.length; i++){
  // if(rows[13]._rawData[0] = "jfjj"){
  //     console.log(i);
  //   }
  // }
  // if(rows[i]._rawData[0] = "dfdfd"){
  //   console.log(rows[i]);
}

accessSpreadsheet();