title: How to refresh a sheet's cell value in Google Apps Script
body: <p>I'm experimenting with <a href="https://www.blockspring.com/" rel="noreferrer">Blockspring</a> which provides a Google Sheets add-on which can, for example, run a function which returns data from a webservice e.g.</p>
  
  <pre><code>=BLOCKSPRING("get-stock-current-stats", "ticker", "MSFT")
  </code></pre>
  
  <p>I want to refresh a cell's data but don't see a 'refresh' call in the docs.</p>
  
  <pre><code>function onOpen() {
    createTimeDrivenTriggers()
  }
  
  function createTimeDrivenTriggers() {
    // Trigger every minute
    ScriptApp.newTrigger('myFunction')
        .timeBased()
        .everyMinutes(1)
        .create();
  
  }
  
  function myFunction() {
    Logger.log('I ran'); // can see this in the logs
    SpreadsheetApp.getActiveSheet().getRange('B4').getValue() //presumably returns a value to the script
  
  }
  </code></pre>