A simple library to go fetch data from Google Sheets without having to use OAuth or any configuration other than having made the sheet public.
const googleSheetData = require('./index');
const data = await googleSheetData({
// https://developers.google.com/sheets/api/guides/concepts
sheetId: [google sheet id],
// json, csv, html
format: 'json',
// >= 0
sheetNumber: 0,
});
Requires request-promise library
npm i request-promise
- Make the sheet public
- Record the sheetId
- Doesn't require OAuth or any other authentication.
- Profit!