2.0.0

gspread_asyncio brings compatibility with gspread 6.0 and removes some deprecated functions. See the migration guide for gspread.

Breaking Changes

• The order of arguments for AsyncioGspreadWorksheet.update() has changed! Previously, you called it as update("B2:C2", [["54", "55"]]), it is now update([["54", "55"]], "B2:C2") or update(range_name="B2:C2", values=[["54", "55"]])
• The AsyncioGspreadSpreadsheet.sheet1 property has been removed, use get_sheet1() instead.
• The AsyncioGspreadSpreadsheet.get_title() method has been removed, use the property .title instead.
• The AsyncioGspreadWorksheet.delete_row() method has been removed, use the method .delete_rows() instead.
• The AsyncioGspreadWorksheet.duplicate() method has been removed, use the method AsyncioGspreadSpreadsheet.duplicate_sheet() instead.
• Python 3.8+ is required.

New functionality:

• combine_merged_cells is now an argument for get() and get_values(). Thanks to @Sethis for the implementation and @sergoutre for the feature request.

1.9.0

• Bump to gspread 5.10.x
• Fix AsyncioGspreadSpreadsheet.sheet1 property. Thanks to @Syriiin
• Fix duplicate(). The function works correctly but has some fundamental issues. Please avoid using it as it will be removed in the future. Thanks to @Yu-Vitaqua-fer-Chronos
• Fix export()

1.8.1

• Add AsyncioGspreadSpreadsheet.fetch_sheet_metadata(). Thanks to @Mat0mba24 for the PR.

1.8.0

• Bump version of gspread
• Add support for new functions cut_range / copy_range
• Add the case_sensitive parameter to find(). Thanks to @Neonnaut for the bug report
• Fix the default parameter for get(). Thanks to @asergeenko for the bug report
• Add Python 3.11 to CI

1.7.1

• Fix #48 , a bug in Worksheet.get_all_records(). Thanks to @githuberto for the report

1.7.0

• Update to gspread 5.5.0
• Reverted first_row et al changes to Worksheet.range(). Thanks to @user318 for the report!

1.6.0

• Require Python 3.7+ and gspread 5.3.
• Many, many new APIs added!
• Removed the first_row/first_col/last_row/last_col params from the docs. These were never implemented anyway! If you're working with offsets and need to convert to A1 notation there is a gspread.utils.rowcol_to_a1 function that can handle the conversion for you.

1.5.3

• Fix an issue with the update() method's handling of raw input types. Thanks to @alexdelorenzo
• Add, document and fix several other omitted kwargs in various functions

1.5.2

Fixes to CI with the 1.5.1 release.

1.5.1

• Fix worksheet.get_values(). Thanks to @bryzgaloff