Hacktoberfest 2026: the issues maintainers tagged for October, open and beginner-friendly. Browse Hacktoberfest issues

spreadsheet hyperlink value returning nil

Open
#10,777 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
35/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Stale
Tech stack
ruby
Domain
api

Research direction

Reproduce the nil hyperlink value using the reported Google Sheets cell and the google-api-ruby-client Ruby objects shown in the issue. Check whether the Sheets API response contains a hyperlink and whether CellData exposes it; done means establishing where the value is lost or confirming the reported behavior.

Written by the indexing model from the issue text.

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

p cell_data
#=> #<Google::Apis::SheetsV4::CellData:0x000000010d3a9040 @effective_value=#<Google::Apis::SheetsV4::ExtendedValue:0x000000010d3a1700 @string_value="   FOOLS HOLLOW LAKE">, @formatted_value="   FOOLS HOLLOW LAKE", @user_entered_value=#<Google::Apis::SheetsV4::ExtendedValue:0x000000010d4192f0 @string_value="   FOOLS HOLLOW LAKE">>

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

  • OS: MacOS
  • Ruby version: 3.1.2
Dominant language
Ruby
Stars
2.9k
Forks
888
Avg merge
8m
Merged PRs (30d)
241

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from googleapis/google-api-ruby-client

All issues in googleapis/google-api-ruby-client

Similar issues

More Ruby issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.