README
gsheets
Get public Google Sheets as plain JavaScript/JSON.
:point_right: Try gsheets in your browser
Usage
Google Sheets Api Key
Starting with version 3.0.0, gsheets uses the official Google Sheets API v4, which requires an API key. To get an API key follow these instructions.
Node.js
Node.js >= 12 is required.
npm install gsheets
const gsheets = require('gsheets');
gsheets.getWorksheet('SPREADSHEET_KEY', 'WORKSHEET_TITLE', 'GSHEETS_API_KEY')
.then(res => console.log(res), err => console.error(err));
In the Command Line
gsheets --key --title [--apiKey] [--out] [--pretty] [--dsv]
--key Spreadsheet Key (ID), required
--title Worksheet title, required
--apiKey Google Sheets v4 API key,
--out Output file; defaults to /dev/stdout
--dsv Format as delimiter-separated values
--csv Shortcut for --dsv=,
--tsv Shortcut for --dsv=