In this article, we will review common synchronization issues while working with the Google Sheets Data Provider and the most effective solutions for each.
If a synchronization problem occurs, you will see an error message. Clicking View Error Details will provide more information.
Error 42709 - Sheet not found.
This error may pop up if you:
Renamed the connected Sheet
Deleted the connected Sheet
The Sheet name will be presented in the error details so you can check where the problem lies.
To resolve it, either rename the sheet back to its original name and sync again or reconnect the spreadsheet using the updated sheet name.
Unexpected Error
This error may occur due to:
The Spreadsheet permissions may have changed if someone modified the file permissions at Google Drive. If the file was accessed via URL, the first thing to check if it is still publicly shared.
For the case a social account was being used to access the Spreadsheet, it could happen that the Google social account was unlinked from your team. If this happens, the account will no longer appear in the modal. To resolve this, reconnect a Social Account with access to the file or share the spreadsheet publicly and add by URL.
If the connected spreadsheet has been permanently deleted from Google, it cannot be recovered. In this case, you will need to recreate the file.
If you're unsure how to proceed, you can contact us and provide a screenshot of the error details for further assistance.