How to analyze big data in google sheets?

Question

Google Cloud Platform

I'm working on the project. Through the API, I download data directly to a Google spreadsheet. Further, on the basis of these data in the same file, all sorts of reports are considered and graphs are built.

The problem is that there is more and more data and the table starts to slow down.

Maybe someone knows how to organize automatic loading and storage of data not in a Google spreadsheet, but so that Google spreadsheet has constant access to them and can build reports and graphs?

Answer 1

As options:
- look at the solution from Google BigQuery.
- you can take data from the Google table via API, process it (for example, in python, js) and write the results back to the table.
- or write data via API to the database, process and write the results to a Google spreadsheet.