google-sheet-data
v1.0.0
Published
Returns google sheet data in either json, csv or html formats
Downloads
3
Maintainers
Readme
Google Sheet Data
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.
Getting Started
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,
});
Installing
Requires request-promise library
npm i request-promise
Prereqs
- Make the sheet public
- Record the sheetId
- Doesn't require OAuth or any other authentication.
- Profit!