Source sheet and destination spreadsheet are connected via a connection. This connection may break for several reasons. These can occur on either the source sheet or the destination spreadsheet.
- Source sheet or destination spreadsheet use an excessive amount of cells. A Google spreadsheet can only hold 2 million cells. Use this addon to check the size of the source sheet and destination spreadsheet. Make sure there is sufficient space in the destination and the source is not too big.
- Source or destination spreadsheet rely a lot on formulas. If you frequently see a loading progress bar in your spreadsheet, this is a good indication that your spreadsheet is very heavy. Try to simplify or remove some formulas. Sheetgo needs to wait until all formulas are processed but then it may run into a Google server timeout because it didn't have enough time anymore to transfer the data.