⚠️ MOVED TO OpenFn/adaptors! ⚠️

N.B.: New versions are available at: https://github.com/OpenFn/adaptors/tree/main/packages/googlesheets

Language Google Sheets (Archived)

Language Pack for building expressions and operations to make Google Sheets API calls.

Documentation

sample configuration

{
  "accessToken": "nu-uh"
}

appendValues()

Add rows to an existing sheet: https://sheets.googleapis.com/v4/spreadsheets/spreadsheetId/values/Sheet1!A1:E1:append?valueInputOption=USER_ENTERED

appendValues({
  spreadsheetId: "1O-a4_RgPF_p8W3I6b5M9wobA3-CBW8hLClZfUik5sos",
  range: "Sheet1!A1:E1",
  values: [
    ["From expression", "$15", "2", "3/15/2016"],
    ["Really now!", "$100", "1", "3/20/2016"],
  ],
});

Docs

Development

Clone the repo, run npm install.

Run tests using npm run test or npm run test:watch

Build the project using make.

To build the docs for this repo, run ./node_modules/.bin/jsdoc --readme ./README.md ./lib -d docs.