This article explains why a synced Google Sheet may stop updating or get moved to the Archive folder, and how to avoid common issues.
How Google Sheets sync works
ProBackup syncs your backed-up data to Google Sheets and updates the same file after each backup cycle. However, in certain situations, the existing sheet is archived and a new one is created in its place. The archived sheet is moved to the Archive folder in your Google Drive.
Reasons a Google Sheet may be archived
A Google Sheet is archived and replaced with a new one when:
New columns are added – if new fields (e.g. custom fields) are added to your project or board, the sheet structure changes and a new sheet is created.
The sheet exceeds 1.5 million cells – a new sheet is created with fewer columns to stay within Google Sheets limits. All records are still included.
The sheet template was modified – if you edit the main sheet (e.g. removing a column or changing the structure), ProBackup will archive it and create a fresh copy.
Reasons a Google Sheet may not be created
The dataset has more than 50,000 records – no Google Sheet will be created for that dataset. Your data is still fully backed up on ProBackup's servers.
Reasons a Google Sheet may stop updating
Your user was removed from the workspace – if your account no longer has access to the workspace in the connected app, the sync will stop. Ask a team member to re-add your account.
Can I edit the Google Sheets?
The main sheets are locked to ensure a reliable sync between ProBackup and Google Drive. If you edit a main sheet, it will be archived and replaced.
To build reports or analyse your data, use the Pivot and Charts tabs included in each Google Sheet. These tabs are editable and will not trigger an archive.
Note: Because structural changes to your app can trigger a new sheet, we do not recommend using Google Sheets sync as a primary reporting tool. Any connected reports would need to be re-linked to the new sheet.