title: Google Sheets "You do not have permission to call appendRow"
body: <pre><code>function myFunction() {
      var url = 'https://api.github.com/users/chaimf90/repos'
      var response = UrlFetchApp.fetch(url);
      var json = response.getContentText();
      var data = JSON.parse(json)
      var sheet = SpreadsheetApp.getActiveSheet();
      sheet.appendRow(['Repo Name', data[0].name]);
  }
  </code></pre>
  
  <p>When I execute this function from the script editor it runs as expected, but when I try to call this function in the sheet itself by calling <code>=myFunction()</code>, I get an error saying that I do not have permission to call <code>appendRow</code>.</p>
  
  <p>Why can I call this function from the script editor, but not from the sheet itself? </p>