Read hyperlink from a cell in Google Sheet

Hi Everyone!

Help needed. I have installed the UiPath.GSuite.Activities -package and GoogleSpreadsheet.Activities -package. I’m trying to make an automation, where the robot should be able to open a specific hyperlink from Google Sheets. The hyperlink would lead to a Google Docs -file. I could not find the right activity to retrieve the value of a hyperlink in Google Sheets.

I’m looking for the same. Any Ideas?

The only way to make this work for me was to download the google sheets file and open it in excel, where you can read the hyperlink easily.