Skip to main content

Changelog for the googlesheets adaptor

@openfn/language-googlesheets

5.1.0 - 03 August 2026​

Minor Changes​

  • 7dd37fc: Add support for Google Service Account credential

5.0.0 - 09 July 2026​

Major Changes​

  • 3138733: Updated appendValues(), batchUpdateValues(), and getValues() to use positional arguments instead of a single params object.

    Migration Guide​

    appendValues

    // Before
    appendValues({
      spreadsheetId: '1abc...',
      range: 'Sheet1!A1:E1',
      values: [['a', 'b']],
    });

    // Now
    appendValues('1abc...', 'Sheet1!A1:E1', [['a', 'b']]);

    batchUpdateValues

    // Before
    batchUpdateValues({
      spreadsheetId: '1abc...',
      range: 'Sheet1!A1',
      values: [['a']],
      valueInputOption: 'RAW',
    });

    // Now
    batchUpdateValues('1abc...', [{ range: 'Sheet1!A1', values: [['a']] }], {
      valueInputOption: 'RAW',
    });

    Callback parameter has been removed from appendValues(), batchUpdateValues(), and getValues() in favor of a promise-based API.

4.1.2 - 30 June 2026​

Patch Changes​

  • Updated dependencies [c5f8728]
    • @openfn/language-common@3.3.4

4.1.1 - 27 May 2026​

Patch Changes​

  • Updated dependencies [5276a86]
    • @openfn/language-common@3.3.3

4.1.0 - 21 May 2026​

Minor Changes​

  • bf26881: export log function from common

4.0.13 - 20 May 2026​

Patch Changes​

  • Updated dependencies [9d1e1ae]
    • @openfn/language-common@3.3.2

4.0.12 - 17 April 2026​

Patch Changes​

  • c226622: Update googleapis library

4.0.11 - 07 April 2026​

Patch Changes​

  • Updated dependencies [add9748]
  • Updated dependencies [a9b7597]
    • @openfn/language-common@3.3.1

4.0.10 - 30 March 2026​

Patch Changes​

  • Updated dependencies [295655f]
    • @openfn/language-common@3.3.0

4.0.9 - 24 February 2026​

Patch Changes​

  • Updated dependencies [856f85c]
    • @openfn/language-common@3.2.3

4.0.8 - 09 February 2026​

Patch Changes​

  • Updated dependencies [8ad6b98]
  • Updated dependencies [8ad6b98]
    • @openfn/language-common@3.2.2

4.0.7 - 02 December 2025​

Patch Changes​

  • e8f7f2d: Security update

4.0.6 - 28 November 2025​

Patch Changes​

  • Updated dependencies [cfc66df]
    • @openfn/language-common@3.2.1

4.0.5 - 12 November 2025​

Patch Changes​

  • Updated dependencies [4d7a833]
    • @openfn/language-common@3.2.0

4.0.4 - 04 November 2025​

Patch Changes​

  • Updated dependencies
    • @openfn/language-common@3.1.2

4.0.3 - 16 October 2025​

Patch Changes​

  • Updated dependencies [408a3a2]
    • @openfn/language-common@3.1.1

4.0.2 - 18 September 2025​

Patch Changes​

  • Updated dependencies [e2bc436]
    • @openfn/language-common@3.1.0

4.0.1 - 01 September 2025​

Patch Changes​

  • Updated dependencies [1d60531]
    • @openfn/language-common@3.0.3

4.0.0 - 11 August 2025​

Major Changes​

  • a5cea4e: removed http export from @openfn/language-common

    Migration Guide​

    The http export has been removed from @openfn/language-common. If you were using it, you should remove it from your code and create a new step that uses http adaptor. See example below.

    Before

    Step 1: Fetch and post data using postgresql adaptor

    sql('select * from foo');
    http.post('/example', { body: $.data }),

    Now

    Step 1: Fetch data using postgresql adaptor

    sql('select * from foo');

    Step 2: Post data using http adaptor

    post('/example', { body: $.data });

3.0.17 - 14 July 2025​

Patch Changes​

  • Updated dependencies [9b5a4f8]
    • @openfn/language-common@3.0.2

3.0.16 - 10 July 2025​

Patch Changes​

  • Updated dependencies [cf9c09f]
    • @openfn/language-common@3.0.1

3.0.15 - 10 July 2025​

Patch Changes​

  • Updated dependencies [ea85695]
  • Updated dependencies [3fce58f]
  • Updated dependencies [19f2d7e]
  • Updated dependencies [f26bd2b]
  • Updated dependencies [19f2d7e]
    • @openfn/language-common@3.0.0

3.0.14 - 20 June 2025​

Patch Changes​

  • Updated dependencies [28c2e8b]
    • @openfn/language-common@2.5.0

3.0.13 - 22 April 2025​

Patch Changes​

  • Updated dependencies [99e4b48]
  • Updated dependencies [13bf08f]
    • @openfn/language-common@2.4.0

3.0.12 - 16 April 2025​

Patch Changes​

  • Updated dependencies [b089c56]
    • @openfn/language-common@2.3.3

3.0.11 - 11 April 2025​

Patch Changes​

  • Updated dependencies [d7105c0]
    • @openfn/language-common@2.3.2

3.0.10 - 14 March 2025​

Patch Changes​

  • Updated dependencies [23ccb01]
    • @openfn/language-common@2.3.1

3.0.9 - 27 January 2025​

Patch Changes​

  • update() and append() will exit early with a gentle warning if an empty array is passed. This allows a no-op update to be error free.

3.0.8 - 16 January 2025​

Patch Changes​

  • Updated dependencies [b3d7f59]
  • Updated dependencies [2d709ff]
  • Updated dependencies [41e8cc3]
    • @openfn/language-common@2.3.0

3.0.7 - 16 January 2025​

Patch Changes​

  • Updated dependencies [6dffdbd]
    • @openfn/language-common@2.2.1

3.0.6 - 09 January 2025​

Patch Changes​

  • Updated dependencies [a47d8d5]
  • Updated dependencies [9240428]
    • @openfn/language-common@2.2.0

3.0.5 - 28 October 2024​

Patch Changes​

  • Updated docs for each()
  • Updated dependencies
    • @openfn/language-common@2.1.1

3.0.4 - 18 October 2024​

Patch Changes​

  • Updated dependencies [03a1a74]
    • @openfn/language-common@2.1.0

3.0.3 - 15 October 2024​

Patch Changes​

  • Fixed security vulnerability in jsonpath-plus [33973a2]
    • @openfn/language-common@2.0.3

3.0.2 - 24 September 2024​

Patch Changes​

  • Updated dependencies [77a690f]
    • @openfn/language-common@2.0.2

3.0.1 - 16 August 2024​

Patch Changes​

  • 8146c23: Fix typings in package.json
  • Updated dependencies [8146c23]
    • @openfn/language-common@2.0.1

3.0.0 - 01 August 2024​

Major Changes​

  • Export new common http helpers (http namespace)

2.5.2​

Patch Changes​

  • Updated dependencies [4fe527c]
    • @openfn/language-common@2.0.0

2.5.1 - 25 July 2024​

Patch Changes​

  • 73d0a02: Make documentation public
  • Updated dependencies [4c08444]
  • Updated dependencies [73d0a02]
    • @openfn/language-common@1.15.1

2.5.0 - 13 June 2024​

Minor Changes​

  • 73433c20: Add fnIf operation

Patch Changes​

  • Updated dependencies [106ecf6d]
    • @openfn/language-common@1.14.0

2.4.0 - 12 April 2024​

Minor Changes​

  • bae5d3b6: Add the cursor() function from common. See the job writing guide for more information.

Patch Changes​

  • Updated dependencies [1ad86651]
    • @openfn/language-common@1.13.0

2.3.1 - 08 April 2024​

Patch Changes​

  • 4594a324: add callback jsdocs

2.3.0 - 03 April 2024​

Minor Changes​

  • 8405fc9a: - Add getValues() function
    • Improve connection handling
    • Improve error logs

2.2.2 - 30 June 2023​

Patch Changes​

  • aad9549: Ensure that standard OAuth2 credentials with snake-cased "access_token" keys can be used for OAuth2-reliant adaptors
  • Updated dependencies [aad9549]
    • @openfn/language-common@1.10.0

2.2.1 - 19 June 2023​

Patch Changes​

  • Update lock files
  • Updated dependencies
    • @openfn/language-common@1.8.1

2.2.0​

Minor Changes​

  • 2c1d603: Remove parameter reassignment to ensure proper functioning inside an each block; add eslint

    The packages receiving a major bump here exposed functions that didn't work as expected inside each blocks. Users were previously wrapping these functions inside their own custom fn blocks, and this change will ensure that they can be used inside a standard each.

    See https://github.com/OpenFn/adaptors/issues/275 for more details.

Patch Changes​

  • Updated dependencies [2c1d603]
    • @openfn/language-common@1.8.0

2.1.6 - 30 March 2023​

Patch Changes​

  • 14f481e: mark execute as private
  • Updated dependencies [2b4c61a]
    • @openfn/language-common@1.7.6

2.1.5 - 15 February 2023​

Patch Changes​

  • f7ebd3c: remove sample configuration

2.1.4 - 15 February 2023​

Patch Changes​

  • f2aed32: add examples

2.1.3 - 13 January 2023​

Patch Changes​

  • 6d8de03: change @constructor to @function and remove /*_ @module Adaptor _/

2.1.2 - 11 November 2022​

Patch Changes​

  • f2a91a4: Update package exports
  • Updated dependencies [f2a91a4]
    • @openfn/language-common@1.7.5

2.1.1 - 04 November 2022​

Patch Changes​

  • 9a2755e: Update dependency on language-common
  • 8566b26: Fix typings
  • b3d45ff: Fix CJS export of npm package.
  • ecf5d30: remove sinon since it was not being used
  • Updated dependencies [8566b26]
  • Updated dependencies [b3d45ff]
  • Updated dependencies [b5eb665]
  • Updated dependencies [ecf5d30]
    • @openfn/language-common@1.7.4

2.1.0 - 25 October 2022​

Minor Changes​

  • 9e7d458: Migrate googlesheets