Unable to get hyperlink from a Cell - Google Sheets

Asked May 01 '20 at 10:22

Active May 01 '20 at 10:22

Viewed 41 times

I working on Google Sheets and wanted to get sheet hyperlink from a cell via Google API. It shows the text only, but has hyperlink too.

As the selected Cell is a link and showing link also. But in the bar above, it is showing Text only. I'm using Google Sheets API v4 to get the Cell value but it is also returning only Cell Value (Rather I tried value_render_option='FORMULA' too).

what is wrong here. Any type of help will be much appreciated. Thanks

asked May 01 '20 at 10:22

Farhan Shehzad

1

Is this thread useful for your situation? https://stackoverflow.com/q/53863752/7108653 – Tanaike May 01 '20 at 11:49
Yes, the case is as same as mine. But I want to scrape data using Python Script not the Google Apps Script. Or Is there any way I can send Google Apps Script via Python authorizations where I'm using it? – Farhan Shehzad May 01 '20 at 13:37
Thank you for replying. In that case, how about using Sheets API with python? – Tanaike May 01 '20 at 23:03
I couldn't find a solution to do this with Google Sheets API Directly. My findings conclude that Google API lacks this functionality. – Farhan Shehzad May 02 '20 at 07:16
Thank you for replying. I deeply apologize my comments were not useful for your situation. – Tanaike May 02 '20 at 08:52
No Problem mate. It's kind gesture of yours. – Farhan Shehzad May 02 '20 at 09:24

Unable to get hyperlink from a Cell - Google Sheets

0 Answers0