title: Google app script adding a function to new columns
body: <p>First time time writting, long time reading.
  I have a google sheet that is always being updated with three columns at the end.
  I want to write a script that will add the three colums at the end and then add a function to each new columns and pull the fuction/formula down.
  This is what I have so far. Any help would be greatly appreciated.
  Thank you.</p>
  <pre><code> function myFunction() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sh = ss.getActiveSheet();
    var column = sh.insertColumnsAfter(1, 3);
    var cell = ss.getRange(&quot;&quot;);
    cell.setFormula();
  }
  </code></pre>