A sample AWS Lambda function that retrieves rows from a Google Sheet.

getGoogleSheetRowsLambda.js

'use strict';

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

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

exports.handler = (event, context, callback) => {
  return spreadsheet.getInfo((sheetError, info) => {
    if (sheetError) {
      console.error(sheetError);

      return callback(sheetError);
    }

    const sheet = info.worksheets[0];

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

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

        return callback(rowsError);
      }

      return callback(null, rows);
    });
  });
};