I’ve been working with a number of scripts on pulling and pushing data between spreadsheets, but I am looking for something lightweight for creating dashboards of many different spreadsheets. I would simply use Importrange, but it is too unreliable and I can’t have dependent importranges (meaning, a dashboard of other dashboards).
Does anyone know of a lightweight script I could use to approximate importrange wherever I needed it in the sheet and then use a menu option to “refresh” the data?
Thank you for any help you might be able to provide.
Bit out of the box but try Geckoboard?
Bit out of the box but try Geckoboard?
Bit out of the box but try Geckoboard?
Take a look at cloudlab.newvisions.org – the last two scripts on the page (pushData and sheetSpider) may do what you want. The other scripts on that page will help you do things you didn’t know you wanted to do.
Take a look at cloudlab.newvisions.org – the last two scripts on the page (pushData and sheetSpider) may do what you want. The other scripts on that page will help you do things you didn’t know you wanted to do.
Take a look at cloudlab.newvisions.org – the last two scripts on the page (pushData and sheetSpider) may do what you want. The other scripts on that page will help you do things you didn’t know you wanted to do.
Thank you so much for these suggestions. I hadn’t seen the pushData script yet. Nice!
Thank you so much for these suggestions. I hadn’t seen the pushData script yet. Nice!
Thank you so much for these suggestions. I hadn’t seen the pushData script yet. Nice!