CHANGELOG

All notable changes to this project will be documented in this file. See standard-version for commit guidelines.

2.3.0 (2026-03-31)

Features

• add public read-only mode via Google Visualization API (b171dbe), closes #27

2.2.2 (2026-03-31)

Bug Fixes

• ci: stabilize npm trusted publishing in release workflow (78d3159)

2.2.1 (2026-03-31)

Bug Fixes

• ci: use trusted publishing auth flow for npm release (2be2617)

2.2.0 (2026-03-31)

Features

• implement delete/update operations with Template Method refactor (#26) (dcda0e5), closes #24 #25

2.1.0 (2024-12-29)

Bug Fixes

• update findAll function to handle headers and data more robustly (3581c28)

Features

• add findAll function to retrieve all records from a specified sheet #12 (759a974)
• add includeEmptyRows option to findAll function (29bfec3)
• enhance findAll function to optionally include empty rows in results #12 (2c21398)

2.0.0 (2024-12-08)

Breaking Changes

• Authentication: Authentication method with credentials has been updated. (5bc4510, 34b2a11)

Features

• Implement result sanitization for CRUD operations and add getSheetId method #10 (8a60d1e)
• Add optional configs parameter to CRUD operations for enhanced flexibility #10 (adb31f4)
• Skip tests for fetching, clearing, and deleting multiple records #10 (2733e57)
• Add validation to ensure row is a number before deletion #10 (29b105d)
• Add support for optional metadata and improve error handling #10 (f82dee4)
• Enhance updateMany function to support optional metadata and improve error handling #10 (44032f2)
• Enhance insert function to support optional metadata and improve error handling #10 (6723bf3)
• Enhance deleteMany function to support optional metadata and improve error handling #10 (f6d6ff3)
• Enhance clearMany function to support optional metadata and improve error handling #10 (8b2e0ce)
• Enhance findMany function to include metadata in results and update tests accordingly #10 (dc6d69a)
• Enhance deleteFirst function with optional metadata support and improved error handling #10 (8ed0e15)
• Enhance clearFirst function with optional metadata support and improved error handling #10 (8958314)
• Enhance updateFirst function with optional metadata support and improved error handling #10 (57e1dee)
• Enhance findFirst function with metadata support and improved error handling #10 (a250462)
• Add OperationError and NotFoundError classes, and IMetadataService interface for operation metadata management #10 (c25d237)
• Streamline authentication by using auth parameter directly (d9843f8), closes #5
• Add use example for OAuth (f07ad7b), closes #5
• Add JWT authentication example and environment configuration (b63e481), closes #5

Bug Fixes

• update: uses spreadsheets.values.update to update data for updateFirst and updateMany #7 (c93fb6e)

1.1.0 (2024-12-08)

Bug Fixes

• update: uses spreadsheets.values.update to update data for updateFirst and updateMany #7 (c93fb6e)

Features

• add JWT authentication example and environment configuration (b63e481), closes #5
• add optional configs parameter to CRUD operations for enhanced flexibility #10 (adb31f4)
• add use example for OAuth (f07ad7b), closes #5
• clearFirst: enhance clearFirst function with optional metadata support and improved error handling #10 (8958314)
• clearMany: enhance clearMany function to support optional metadata and improve error handling #10 (8b2e0ce)
• deleteFirst: add validation to ensure row is a number before deletion #10 (29b105d)
• deleteFirst: enhance deleteFirst function with optional metadata support and improved error handling #10 (8ed0e15)
• deleteMany: enhance deleteMany function to support optional metadata and improve error handling #10 (f6d6ff3)
• findFirst: enhance findFirst function with metadata support and improved error handling #10 (a250462)
• findMany: enhance findMany function to include metadata in results and update tests accordingly #10 (dc6d69a)
• getSheetId: add support for optional metadata and improve error handling #10 (f82dee4)
• holysheets main class: streamline authentication by using auth parameter directly (d9843f8), closes #5
• implement result sanitization for CRUD operations and add getSheetId method #10 (8a60d1e)
• insert: enhance insert function to support optional metadata and improve error handling #10 (6723bf3)
• metadata: add OperationError and NotFoundError classes, and IMetadataService interface for operation metadata management #10 (c25d237)
• tests: skip tests for fetching, clearing, and deleting multiple records #10 (2733e57)
• updateFirst: enhance updateFirst function with optional metadata support and improved error handling #10 (57e1dee)
• updateMany: enhance updateMany function to support optional metadata and improve error handling #10 (44032f2)