Auto-update

[avlysenko]

Hi!

Thx for your code!

I have question about auto-update.

Try run by timer this:
function myUpdate() {

var ss = SpreadsheetApp.getActiveSpreadsheet();
ss.setActiveSheet(ss.getSheetByName("AUPD"));

var testIt = ImportJSON("***");

var cell = ss.getRange("A1");
cell.setValue( testIt );

}

---

But result only in one cell A1.

---

How to properly do an automatic update on a timer?

[avlysenko]

Is it possible run ImportJSON from other function and paste result in cell?

[bradjasper]

Hello, this should be possible. Have you tried using the Logger to debug?

[xyzzy529]

See issue #49 as the updated version of this question.