import xml - how to refresh a Google Sheet automatically

Question

Hi i Have 4 google sheets using import xml (because of google 50 import limits) on each which are sorting and then feeding data from a webpage to another 'summary' sheet. I just need a script for the 4 google sheets that refreshes the importxml every minute or so.

Either that, or to refresh the importxml when the specified information on the target (source) web page changes.

also, as this would be used from a mobile device some of the time, would the 4 sheets have to be kept open ?

clearly in answer given below, amend cells as appropriate

iggypop
– iggypop

2016-01-14 23:41:04 +00:00
Commented Jan 14, 2016 at 23:41 — iggypop
– iggypop, Commented Jan 14, 2016 at 23:41

iggypop · Accepted Answer · 2016-01-14 23:36:41Z

1

I eventually came across, sorry cant find the OP for it now - seems to do the trick ..

function getData() {
var queryString = Math.random();

var cellFunction1 = '=IMPORTXML("' + SpreadsheetApp.getActiveSheet().getRange('D1').getValue() + '?' + queryString + '","'+ SpreadsheetApp.getActiveSheet().getRange('E1').getValue() + '")';
SpreadsheetApp.getActiveSheet().getRange('D2').setValue(cellFunction1);


}

answered Jan 14, 2016 at 23:36

iggypop

295 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

import xml - how to refresh a Google Sheet automatically

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related