gspread v4.0.0 Release Notes

Release Date: 2021-08-01 // 3 months ago
    • ๐Ÿ”„ Changed Worksheet.find() method returns None if nothing is found (#899 by @GastonBC)

    • โž• Add Worksheet.batch_clear() to clear multiple ranges. (#897 by @lavigne958)

    • ๐Ÿ›  Fix copy_permission argument comparison in Client.copy() method (#898 by @lavigne958)

    • ๐Ÿ‘ Allow creation of spreadhsheets in a shared drive (#895 by @lavigne958)

    • ๐Ÿ‘ Allow gspread.oauth() to accept a custom credential file (#891 by @slmtpz)

    • โšก๏ธ Update tox.ini, remove python2 from env list (#887 by @cclaus)

    • Add SpreadSheet.get_worksheet_by_id() method (#857 by @a-crovetto)

    • Fix store_credentials() when authorized_user_filename is passed (#884 by @neuenmuller)

    • โœ‚ Remove python2 (#879 by @lavigne958)

    • โœ… Use Makefile to run tests (#883 by @lavigne958)

    • ๐Ÿ“š Update documentation Authentication:For End Users using OAuth Client ID (#835 by @ManuNaEira)

    • ๐Ÿ‘ Allow fetching named ranges from Worksheet.range() (#809 by @agatti)

    • โšก๏ธ Update README to only mention python3.3+ (#877 by @lavigne958)

    • โšก๏ธ Fetch creation and lastUpdate time from SpreadSheet on open (#872 by @lavigne958)

    • Fix bug with Worksheet.insert_row() with value_input_option argument (#873 by @elijabesu)

    • ๐Ÿ›  Fix typos in doc and comments (#868 by @cclauss)

    • Auto cast numeric values from sheet cells to python int or float (#866 by @lavigne958)

    • โž• Add Worksheet.get_values() method (#775 by @burnash)

    • ๐Ÿ‘ Allow gspread.oauth() to accept a custom filename (#847 by @bastienboutonnet)

    • Document dictionary credentials auth (#860 by @dmytrostriletskyi)

    • โž• Add Worksheet.get_note() (#855 by @water-ghosts )

    • โž• Add steps for creating new keys (#856 by @hanzala-sohrab)

    • โž• Add folder_id argument to Client.copy() (#851 by @punnerud)

    • ๐Ÿ›  Fix typos in docstrings (#848 by @dgilman)


Previous changes from v3.7.0

    • โšก๏ธ Add Worksheet.insert_note(), Worksheet.update_note(), Worksheet.clear_note() (#818 by @lavigne958)

    • ๐Ÿ“š Update documentation: oauth2.rst (#836 by @Prometheus3375)

    • ๐Ÿ“š Documentation fixes (#838 by @jayeshmanani)

    • ๐Ÿ“š Documentation fixes (#845 by @creednaylor)

    • โž• Add Worksheet.insert_cols() (#802 by @AlexeyDmitriev)

    • ๐Ÿ“š Documentation fixes (#814 by @hkuffel)

    • โšก๏ธ Update README.md (#811 by @tasawar-hussain)

    • Add value_render_option parameter to Worksheet.get_all_records() (#776 by @damgad)

    • โœ‚ Remove requests from install_requires (#801)

    • Simplify implementation of Worksheet.insert_rows() (#799 by @AlexeyDmitriev)

    • Add auth.service_account_from_dict() (#785 b7 @mahenzon)

    • ๐Ÿ›  Fix ValueRange.from_json() (#791 by @erakli)

    • ๐Ÿ“š Update documentation: oauth2.rst (#794 by @elnjensen)

    • ๐Ÿ“š Update documentation: oauth2.rst (#789 by @Takur0)

    • ๐Ÿ‘ Allow auth to be None. Fix #773 (#774 by @lepture)