A Node snippet to get a Google Sheet's rows using the google-spreadsheet module.

getGoogleSheetRows.js

'use strict';

const GoogleSpreadsheet = require('google-spreadsheet');

const spreadsheet = new GoogleSpreadsheet('1tVc-GnBIAAWbdCX7Zn9n-9V8j_rnv7meU22EubLN6G0'); // Sheet ID (visible in URL)

spreadsheet.getInfo((sheetError, info) => {
  if (sheetError) {
    console.error(sheetError);

    return sheetError;
  }

  const sheet = info.worksheets[0];

  const rowOptions = {
    limit  : 100000,
    offset : 0
  }

  return sheet.getRows(rowOptions, (rowsError, rows) => {
    if (rowsError) {
      console.error(rowsError);

      return rowsError;
    }

    return console.log(rows);
  });
});