What's Changed

• Fix public API auth snippet by @Jayy001 in #1545
• Clarify the first step: authentication by @hraftery in #1546
• Fix typo in community.rst by @s2t2 in #1547
• rearrange flow to remove reference to creds by @alifeee in #1525
• switch safety for pip-audit by @alifeee in #1551
• Include the duplicate column names in error message by @NickCrews in #1548

New Contributors

• @Jayy001 made their first contribution in #1545
• @hraftery made their first contribution in #1546
• @s2t2 made their first contribution in #1547

Full Changelog: v6.2.0...v6.2.1

What's Changed

• Add property expiry in gspread client by @lavigne958 in #1453
• Bump typing-extensions from 4.11.0 to 4.12.0 by @dependabot in #1471
• Fix code block formatting typo in README by @agrvz in #1474
• ignore jinja CVE by @lavigne958 in #1481
• Type part of test suite utils by @lavigne958 in #1483
• Remove passing exception as args to super in APIError by @mike-flowers-airbnb in #1477
• Bump mypy from 1.10.0 to 1.10.1 by @dependabot in #1488
• Update advanced.rst by @yatender-rjliving in #1492
• Bump bandit from 1.7.8 to 1.7.9 by @dependabot in #1485
• Bump flake8 from 7.0.0 to 7.1.0 by @dependabot in #1486
• Bump typing-extensions from 4.12.0 to 4.12.2 by @dependabot in #1480
• Bump mypy from 1.10.1 to 1.11.1 by @dependabot in #1497
• Bump black from 24.4.2 to 24.8.0 by @dependabot in #1499
• Bump flake8 from 7.1.0 to 7.1.1 by @dependabot in #1501
• Fix docstring about BackOffHTTPClient by @pataiji in #1502
• Fix comment to reflect correct google-auth package version requirement by @ikmals in #1503
• Doc/community addons orm package by @lavigne958 in #1506
• fix: fix type annotation for default_blank by @hiro-o918 in #1505
• Bump mypy from 1.11.1 to 1.11.2 by @dependabot in #1508
• better handler API error parsing. by @lavigne958 in #1510
• Add test on receiving an invalid JSON in the APIError exception handler. by @lavigne958 in #1512
• [feature] Add 'expand_table' feature by @lavigne958 in #1475
• Bump bandit from 1.7.9 to 1.7.10 by @dependabot in #1514
• Created a batch_merge function [Issue #1473] by @muddi900 in #1498
• Added a range option to Worksheet.get_notes [Issue #1482] by @muddi900 in #1487
• Documentation update for gspread.worksheet.Worksheet.get_all_records by @levon003 in #1529
• add example for batch_merge by @alifeee in #1542
• explicitly list exported package symbols by @alinsavix in #1531

New Contributors

• @agrvz made their first contribution in #1474
• @mike-flowers-airbnb made their first contribution in #1477
• @yatender-rjliving made their first contribution in #1492
• @pataiji made their first contribution in #1502
• @ikmals made their first contribution in #1503
• @hiro-o918 made their first contribution in #1505
• @levon003 made their first contribution in #1529
• @alinsavix made their first contribution in #1531

Full Changelog: v6.1.4...v6.2.0

Full Changelog: v6.1.3...v6.1.4

Bugfix to catch JSONDecodeError better from Google.

What's Changed

• ignore jinja CVE by @lavigne958 in #1481
• Remove passing exception as args to super in APIError by @mike-flowers-airbnb in #1477
• better handler API error parsing. by @lavigne958 in #1510
• Add test on receiving an invalid JSON in the APIError exception handler. by @lavigne958 in #1512

New Contributors

• @mike-flowers-airbnb made their first contribution in #1477

Full Changelog: v6.1.2...v6.1.3

Full Changelog: v6.1.2...v6.1.3-alpha1

What's Changed

• add note about runnings tests to contrib guide by @alifeee in #1465
• Some updates on get_notes by @nbwzx in #1461

Full Changelog: v6.1.1...v6.1.2

What's Changed

• Add some missing typing in code by @lavigne958 in #1448
• More fixes for Worksheet.update argument ordering & single cell updating (i.e. now Worksheet.update_acell) by @alexmalins in #1449
• Added 'add_data_validationtoWorkhsheet` [Issue #1420] by @muddi900 in #1444
• Bump typing-extensions from 4.10.0 to 4.11.0 by @dependabot in #1450
• Bump black from 23.3.0 to 24.4.0 by @dependabot in #1452
• Fix incorrect version number in HISTORY.rst from 6.0.1 to 6.1.0 by @yhay81 in #1455
• add get_notes by @nbwzx in #1451
• Bump mypy from 1.9.0 to 1.10.0 by @dependabot in #1459
• Bump black from 24.4.0 to 24.4.2 by @dependabot in #1460
• bugfix: handle domain name in spreadsheet copy permissions by @lavigne958 in #1458
• Fix/api key auth version by @alifeee in #1463
• Ignore pip vulnerabilities in CI. by @lavigne958 in #1464
• Remove StrEnum dependency and added custom class[issue #1462] by @muddi900 in #1469

New Contributors

• @alexmalins made their first contribution in #1449
• @yhay81 made their first contribution in #1455
• @nbwzx made their first contribution in #1451

Full Changelog: v6.1.0...v6.1.1

Major changes

• types can be obtained using mypy to type code using gspread
• Add a new method to authenticate using API key for public spreadsheets

What's Changed

• Add py.typed marker by @lavigne958 in #1422
• Improve back-off client by @lavigne958 in #1415
• Add new auth method API key by @lavigne958 in #1428
• Bugfix/add set timeout by @lavigne958 in #1417
• Fix wrapper cast_to_a1_notation by @lavigne958 in #1427
• Bump bandit from 1.7.5 to 1.7.8 by @dependabot in #1433
• Bump mypy from 1.6.1 to 1.9.0 by @dependabot in #1432
• Bump typing-extensions from 4.8.0 to 4.10.0 by @dependabot in #1424
• Bump flake8 from 5.0.4 to 7.0.0 by @dependabot in #1375
• fix error message readability by @imrehg in #1435
• Add missing method import_csv() by @lavigne958 in #1426
• update readme examples by @alifeee in #1431
• Add user friendly message when we can't override a test cassette by @lavigne958 in #1438
• Allow "warning" type protected ranges by @alifeee in #1439
• Improce README and documentation with value render options by @lavigne958 in #1446

New Contributors

• @imrehg made their first contribution in #1435

Full Changelog: v6.0.2...v6.1.0

What's Changed

• Fixup gspread client init arguments by @lavigne958 in #1412

Full Changelog: v6.0.1...v6.0.2

What's Changed

• Allow client to use external Session object by @lavigne958 in #1384
• Remove-py-3.7-support by @alifeee in #1396
• bugfix/client export by @lavigne958 in #1392
• Fix oauth flow typo by @alifeee in #1397
• check oauth creds type using isinstance by @alifeee in #1398
• Fix type hints at find method in worksheet.py by @deftfitf in #1407
• Fixup get empty cell value is None by @lavigne958 in #1404
• Fix missing attribute spreadsheet in Worksheet. by @lavigne958 in #1402
• update migration guide by @alifeee in #1409

New Contributors

• @deftfitf made their first contribution in #1407

Full Changelog: v6.0.0...v6.0.1