Google Spread Sheets

A simplified class for calling google spread sheets api.

Installation

npm i git+https://github.com/AoiYamada/google-sheets --save-dev

Then create a credential for accessing your sheet, See Step 1:

https://developers.google.com/sheets/api/quickstart/nodejs

Examples

Case: auto authorization

const spreadsheetId = '1cEVGbJm3A8GGY4OpGrnpNDCQXs_rTWVZClECuDsCTzg';
const Spreadsheets = require('google-sheets');

const credentials = {
    "installed": {
        "client_id": "195616641908-k7bf7tvfk970lpf3dk2q37rni56cadub.apps.googleusercontent.com",
        "project_id": "midyear-guild-198804",
        "auth_uri": "https://accounts.google.com/o/oauth2/auth",
        "token_uri": "https://accounts.google.com/o/oauth2/token",
        "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
        "client_secret": "SczdqnZApf9Ow8MUYs0IdmZE",
        "redirect_uris": ["urn:ietf:wg:oauth:2.0:oob", "http://localhost"]
    }
}

const sheets = new Spreadsheets({ spreadsheetId, credentials });
const sheet = sheets.get({
    sheet: 'test',
    range: 'A1:AL',
})

sheet
    .then(rows => console.log(rows))
    .catch(err => console.log(err));

Case: use static method to authorize

const spreadsheetId = '1cEVGbJm3A8GGY4OpGrnpNDCQXs_rTWVZClECuDsCTzg';
const Spreadsheets = require('google-sheets');

const credentials = {
    "installed": {
        "client_id": "195616641908-k7bf7tvfk970lpf3dk2q37rni56cadub.apps.googleusercontent.com",
        "project_id": "midyear-guild-198804",
        "auth_uri": "https://accounts.google.com/o/oauth2/auth",
        "token_uri": "https://accounts.google.com/o/oauth2/token",
        "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
        "client_secret": "SczdqnZApf9Ow8MUYs0IdmZE",
        "redirect_uris": ["urn:ietf:wg:oauth:2.0:oob", "http://localhost"]
    }
}

const auth = Spreadsheets.auth(credentials);
const sheets = new Spreadsheets({ spreadsheetId }, auth);

const sheet = sheets.get({
    sheet: 'test',
    range: 'A1:AL',
})

sheet
    .then(rows => console.log(rows))
    .catch(err => console.log(err));