Gspread

------------------

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

------------------

* remove dependency on requests-2.27.0

------------------

* ignore jinja CVE by lavigne958 in https://github.com/burnash/gspread/pull/1481
* Remove passing exception as args to super in APIError by mike-flowers-airbnb in https://github.com/burnash/gspread/pull/1477
* better handler API error parsing. by lavigne958 in https://github.com/burnash/gspread/pull/1510
* Add test on receiving an invalid JSON in the APIError exception handler. by lavigne958 in https://github.com/burnash/gspread/pull/1512

------------------

* add note about runnings tests to contrib guide by alifeee in https://github.com/burnash/gspread/pull/1465
* Some updates on `get_notes` by nbwzx in https://github.com/burnash/gspread/pull/1461

------------------

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

------------------

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