Since the sheet has 14,000 rows, it's hitting timeout issues during loading which causes the Google Sheets connection to drop. This happens with large datasets because they're very resource-intensive to process.
Instead of trying to load it directly, you can set up a Google Script to forward the data to your previous sheet. This will handle the data transfer more reliably without timing out.
Here's how to set up the Google Script to forward your data:
1. In your new Google Sheet (source), go to Extensions > Apps Script
2. Copy this script:
function copyDataToAnotherSheet() {
// Source spreadsheet (your new sheet)
const sourceSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
// Target spreadsheet (your old sheet) - replace with your sheet ID
const targetSpreadsheet = SpreadsheetApp.openById('TARGET_SHEET_ID');
const targetSheet = targetSpreadsheet.getActiveSheet();
// Get all data from source
const data = sourceSheet.getDataRange().getValues();
// Clear target sheet and paste new data
targetSheet.clear();
targetSheet.getRange(1, 1, data.length, data[0].length).setValues(data);
}
```
3. Replace TARGET_SHEET_ID with your old sheet's ID (find it in the URL between /d/ and /edit)
4. Click Save and Run
5. First time you run it, authorize the script when prompted
You can also set this to run automatically:
1. Click the clock icon (Triggers)
2. Click "Add Trigger"
3. Choose when you want it to run (hourly/daily/etc)
Just let me know if you have any issues! :)
.png){kind=logo}
