CODEWITHSUNDEEP
google-sheets
POLLOX
POLLOX

Reputation: 302

Google Spreadsheet row update

I need update a row with function =importxml() every 3 minutes to refresh MAP gadget.

I setup function redROWs trigger to every 3 minutes but it doesn't work. Any idea?

Upvotes: 1

Views: 5278

Answers (2)

BrnKd
BrnKd

Reputation: 49

The importXML() is updating every 2 hours by it self and you can't trigger it from a script. Then you have to write the function into your script..

The best solution I found is to add the GoogleClock() to the URL. It makes the ImportXML update every minute automatically. Also when the spreadsheet is not open.

Like this: ImportXML("URL"&GoogleClock(),"div...")

Upvotes: 4

eddyparkinson
eddyparkinson

Reputation: 3700

getActiveSheet() only works when you have the spreadsheet open - use openById

https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#openById(String)

to trigger =importxml , write something to the sheet.

Upvotes: 1

Related Questions