Publishing to Google Sheets beyond its limits


Aggregate can publish data to Google sheets. What happens if it goes above the current limits (5 million cells)? Anyone has an idea?

Normally, if I upload a file (XLS or CSV) which has more data than 5 million cells, Google sheets does not open it (keeps loading and loading for hours, and then says not possible). If a default aggregate publishing sheet goes above it, does this mean our data is lost?

If anyone has hit this limit, please feel free to share.


From what i know it just doesn't add new data.

Some time ago I tested this behavior and it works as you described it's slower and slower.

No, because your data is not cleared when you publish it.