Chips and Hyperlinks

[denis-tsariov]

It happens to me quite often that I need to read google sheets that have chips and hyperlinks. I even created a personal gspread wrapper for this use-case.

I would like to contribute to this project by bringing this feature to gspread!

After a quick review of the code-base, I'm not sure what method to extend to get this behaviour... I was thinking about .get() but I'm not sure if that's gonna make the method too bloated.

I also considered extending gspread-dataframe with this feature but figured it would be best to add this feature at the source.

Let me know if it is a good idea and what you think would be the best way to go about doing that (again to reiterate, I have the code to do this, I just want mentorship on where would be a good idea to put this feature)

[alifeee]

hi :] thanks for the suggestion

please see #1570

[antoineeripret]

Hey @denis-tsariov,

Can you explain what you'd like to achieve with this new feature?

Thank you !

[silasary]

I am currently trying interact with a spreadsheet that has rich text hyperlinks in cells.
When trying to access this via gspread, I currently just get a cell with .value = "Blue Text", and no way of accessing the url behind it.

Extending .get() probably won't work, as it's far too messy. But being able to see the rich text via a Cell accessed with .range() or get_all_cells() would allow me to actually read the data I need.