Skip to main content

googlesheets Adaptor developer README.md

Source: https://github.com/OpenFn/adaptors/tree/main/packages/googlesheets

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