@openfn/language-googlesheets
v3.0.5
Published
A Google Sheets Language Pack for OpenFn
Downloads
465
Keywords
Readme
Language Google Sheets
Language Pack for building expressions and operations to make Google Sheets API calls.
Documentation
Configuration
View all the required and optional properties for state.configuration
in the
official
configuration-schema
definition.
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'],
],
});
Development
Clone the adaptors monorepo. Follow the
Getting Started
guide inside to get set up.
Run tests using pnpm run test
or pnpm run test:watch
Build the project using pnpm build
.
To just build the docs run pnpm build docs