Easy Sheets

Easy Sheets is a modern, typed javascript library to access Google Sheets. It was made for 2 reasons:

- to be able to do simple sheet operations using terse commands;
- to be able to access Google API credentials as a string (which could be set as an environment variable).

To setup:

- Create a Google Cloud project
- Enable the Google Sheets API
- Create a service account, download the JSON credentials
- Base64 your credentials like so: btoa(JSON.stringify(YOUR CREDENTIALS))
- Create a Google Sheet, note the ID
- Click the sheet's "Share" button and add the service account with "edit" permissions.

To use:

``
import EasySheets from 'easy-sheets'

const easySheets = new EasySheets(SPREADSHEET_ID, BASE64_CREDS)

// add a row
await easySheets.addRow(['this', 'was easy'])

// get a range as multi-dimensional array
await easySheets.getRange('A1:B3')

// get a range as an object
await easySheets.getRange('A1:B3', {headerRow: 'raw'}))

// update range
await easySheets.updateRange('A1:B2', [['First Name', 'Last Name'], ['Tim', 'Jones']])

// clear range
await easySheets.clearRange('A1:B5000000')

// multisheet operations
// you can add {sheet} as an argument to all operations
// example:
await easySheets.getRange('A1:B3', {sheet: 'Sheet2'})
``