Google Sheets limits us to 2 million cells per document. Does anyone have any workarounds for this limitation?
We at Supermetrics would also be glad to know if someone has found a way to go beyond 2 million cells.
If not, we have our API product which might help in some cases: http://supermetrics.com/smapi/
According to the API product page, the product is not yet available. Any tentative dates in terms of the roadmap for release?
API product is still under development but if you would like to talk more about getting onboard as early user, please contact email@example.com.
-Jouni Hyötylä / Supermetrics
we are looking in to the possibility of uploading to Bigquery. As soon as we have something new about it, we'll let you know.
Thank you so much for your tips in this matter!
I currently use a Google App Script Job to move Google Spreadsheet Data to BigQuery. Of course it would take a few manual uploads to fill BigQuery with historical Data, you can automate the process of appending new data and query the Table afterwards.
Otherwise I use one Central Spreadsheet where I collect all Data for visualisation and pull only the data I need via IMPORTRANGE from other spreadsheets into that spreadsheet. The plugin IMPORTSHEETS could help, too. But it is not free. I would be nice if supermetrics offered a similar way to pull data from other sheets.
Hi, any update on this? (in terms of BigQuery + Supermetrics)
I'm also especially interested in the solution from the user Ad Analytics -> do you have maybe some additional material on how to convert federated views into native tables using Google Cloud Console? I have programming experience so I'm thinking of looking into this in the meantime.
unfortunately no news yet but we are working on a possible solutions. You'll get the new for example by following us on Twitter: @Supermetrics.
Google Spreadsheet does not distinguish between cells with data and empty cells. So, if you delete the columns you are not using, they won´t count towards the cell limit. I find it very hard to use up all the cells this way. This is by far the simplest workaround for this problem.
Thanks for your suggestion! Unfortunately for us, that's what we've already been doing to help with give us some extra cells. However we eventually hit the limit pretty quickly given the size of our data.
We have been looking to see when the API tool will be out of beta.
Any updates available?
We're closing in to the release date. Most likely within the next 2 months.