title: Open a column of links as new tabs in Google Sheets
body: <p>I have a column of links in Google Sheets, let's just say they're in C2:C11 for now. What I want is a cell that when clicked on or executed or whatever will go through the list and open all of them as webpages. I'd prefer to open them in Chrome, but the default browser (which is also Chrome) works too.</p>
  <p>I know that the equivalent in python would be:</p>
  <pre><code>for link in column:
      webbrowser.open(link)
  </code></pre>
  <p>but not how to translate that into Sheets functions.</p>
  <p>Edit:</p>
  <p>With @DevenRamini, I was able to write the following:</p>
  <pre><code>function myFunction() {
    
    var range = SpreadsheetApp.getActiveSheet().getRange(&quot;H2:H7&quot;);
    var links = range.getValues();
    for (var i = 0; i &lt; links.length; i++){
      var link = links[i][0];
      console.log(link);
      var html = &quot;&lt;script&gt;window.open('&quot; + link + &quot;');google.script.host.close();&lt;/script&gt;&quot;;
  
      var userInterface = HtmlService.createHtmlOutput(html);
  
      SpreadsheetApp.getUi().showModalDialog(userInterface, 'Open Tab');
    };
  
  }
  </code></pre>
  <p>It almost works, but it's only opening one tab and that tab is the last link in the column.</p>