How to click hyperlink

How to click hyperlink in Gsheet where in a column each cell has different hyperlink name means how to use click activity dynamiclly inside a loop when the hyperlink name differs in each cell


You can use macro for this,

  1. get total rows
  2. put for each on those rows
  3. write a logic to click a hyperlink.

plz explore on google, you could find a solution.