When making a master sheet that sums some values across hundreds of Google Sheets with the functions importrange, or query data across hundreds of Google Sheets' IDs, it takes longer time to load...
Is there a way to have a buffer like database in Google that is continuously updating the master sheet so whenever I open it the data has already been updated instead of waiting to execute the functions? In other basic words, as if the master sheet file is continuously open in my desktop. So whenever I need to look at it, it is already open and the
importrange function has finished doing the job. That will make the dynamic data calculation & synchronization much faster specially if you need to look for multiple filtered values and data.
Probably working with cloud database and keeping the sheets that have
importrange data and calculations in the database will solve the issue.
I found sites to work as linking a trigger of Google Sheet with another application but don't really solve my issues like https://integromat.com/ or https://zapier.com. I found similar question where something called SQL works as a cloud database for Google but I'm very primitive to it so far.