spreadsheet hyperlink value returning nil

[alilland]

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

[alilland]

Is this a limitation of the underlying REST API?

[drLoom]

@alilland ,
It is possible. You need to explicitly specify what data to fetch via fields key. Links for formatted text stored in textFormatRuns prop:

fields = 'sheets.data.rowData.values(userEnteredValue,textFormatRuns)'
ranges = ["Shhet1!A1"]

sheets_service.get_spreadsheet(spreadsheet_id, ranges:, fields:)

Tip: Use with include_grid_data set to true, #get_spreadsheet(spreadsheet_id, include_grid_data: true)
to get all data and then you can inspect result structure.

Tip2: To add data with formatted links see this stackoverflow answer