googleapis / googleapis/google-api-ruby-client
spreadsheet hyperlink value returning nil
- Dominant language
- Ruby
- Stars
- 2.9k
- Forks
- 888
- Avg merge
- 6m
- Merged PRs (30d)
- 218
Description
The state of Arizona publishes a fishing report via Google Spreadsheets, each cell in column A contains hyperlinks to google maps which im trying to obtain
https://docs.google.com/spreadsheets/d/1m4X4I-fhhPL26jeLw4IlB4zG5dM5NgdN_6eewpbCgNM/edit#gid=1253509900
I am able to successfully read the text value, but unable to read the hyperlink value - its returning `nil`
```ruby
p cell_data
#=> #, @formatted_value=" FOOLS HOLLOW LAKE", @user_entered_value=#>
p cell_data.formatted_value
#=> " FOOLS HOLLOW LAKE"
p cell_data.hyperlink
#=> nil
```
is there a way to get the hyperlink value? the clicked value is [this](http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=fool+hollow+lake+az&aq=&sll=37.0625,-95.677068&sspn=50.157795,73.476563&vpsrc=0&ie=UTF8&hq=&hnear=Fools+Hollow+Lake&t=m&z=15)
- OS: MacOS
- Ruby version: 3.1.2
Contributor guide
Assessment
This issue has not been assessed yet.