Summary
Encountering error when syncing data to GSheets due to cell limit issue, incorrect row count, and data insertion problem
Question
Hi everyone,
I am constantly encountering the same error and I don’t know what I am doing wrong. I am trying to connect one of my sources to a GSheets destination and it apparently works just fine. However, there are sometimes when the sync fails due to “This action would increase the number of cells in the workbook above the limit of 10000000 cells.”
This can’t be right as the amount of cells I am sending to the GSheets is nowhere near 10,000,000. When reviewing the logs, it says it attempts fetching 4435703 rows, even though the query only contains 80351 rows.
Furthermore, when sending the data to the GSheets, it seems like data is inserted in the top rows without deleting older rows, thus the GSheets file suddenly grows in size each day.
How can I solve this problem?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.