net/py-gspread: Update to version 5.0.0
Notable Changes:
- Avoid IndexError when row_values() returns an empty row
- Add Worksheet.index property
- Add ability to create directory if it does not exist before saving the credentials to disk
- Add functions for defining, deleting and listing named ranges
- Implement open sheet within Drive folder
- Fix get range for unbounded ranges
- Remove potential I/O when reading spreadsheet title
- Replace raw string "ROWS" & "COLUMNS" to Dimension named tuple
- Replace raw string "FORMATTED_VALUE", "UNFORMATTED_VALUE", "FORMULA" to ValueRenderOption named tuple
- Replace raw string "RAW", "USER_ENTERED" to ValueInputOption named tuple