title: Google Sheets App Script - Get values from formula instead of writing to cell
body: <p>My script sets the values of a whole sheet by using an arrayformula.</p>
  
  <pre><code>sheet.getRange("A2").setFormula("=ArrayFormula(UNIQUE(FILTER(Furniture!$A$2:$S$15000,ISNA(MATCH(Furniture!$A$2:$A$15000,Shopify!$F$2:$F$50000,0)))))");
  </code></pre>
  
  <p>Is it possible to get these values as an array, without updating the sheet? At the moment, the best I can think of is getting the values from the sheet after applying the above formula. There must be a more efficient way.</p>