Nitroglycerin Pickle Machine

    gspread-async

    1.1.0 • Public • Published

    gspread-async

    This module provides a wrapper for the google-spreadsheet module, exposing a subset of the most common used functionalities, using a modern async interface.

    Note: The module relies on the service account authentication method described in the google-spreadsheet module.

    Install

    You can install with [npm]:

    $ npm install --save gspread-async
     
     

    Usage

    You need to define an object with 3 parameters in order to get or write data to an spreadsheet:

    1. The gooogle spreadsheet id.
    2. The name of sheet you want to use.
    3. The path of the JSON file containing the authentication credentials.
    const parameters = {
        docid: '<your spreadsheetid>',
        credspath: '<your path with the google credentials file>',
        sheetid: '<your sheetid>'
    }

    Once you have this object you can use it to either getRows, getCells or addRow to a particular sheet:

     
    const gspreadasync = require('gspread-async')
     
    const parameters = {
        docid: '<your spreadsheetid>',
        credspath: '<your path with the google credentials file>',
        sheetid: '<your sheetid>'
    }
     
    async function test () {
      // Get Rows
      const rows = await gspreadasync.getRows(parameters)
      // Get Cells
      const cells = await gspreadasync.getCells(parameters)
      // Add Row. The column names have to match the ones in the spreadsheet
      const cells = await gspreadasync.getCells(parameters, {col1: 'val1', col2: 'val2'})
    }
     
    test()
     

    License

    Copyright © 2019, Juan Convers. Released under the MIT License.

    Install

    npm i gspread-async

    DownloadsWeekly Downloads

    1

    Version

    1.1.0

    License

    MIT

    Unpacked Size

    7.48 kB

    Total Files

    11

    Last publish

    Collaborators

    • webdacjs