I’ve been working with a number of scripts on pulling and pushing data between spreadsheets, but I am looking for…

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.

9 Comments

Leave a Reply