title: Looking to automatically replace http:// with https:// for any pasted URL
body: <p>I am looking to use a function/script in Google Sheets that will look at a column where folks are pasting URLs and take any links with http:// and replace them with https://</p>
  <p>This is for a UTM link building spreadsheet and I want to make sure we are using secure URLs every time.</p>
  <p>Any insight would be awesome!!</p>
  <p>I tried to use the following script but had no success</p>
  <pre><code>  var FILE = SpreadsheetApp.openById(&quot;xyz&quot;);
    var CONTENT = FILE.getSheetByName(&quot;Sheet1&quot;);
    var A1 = CONTENT.getRange(&quot;I17&quot;);
    A1.createTextFinder(&quot;.&quot;).replaceAllWith(&quot;&quot;);
  </code></pre>