When you refresh (or run) a report manually, or have SyncWith run it on a schedule for you, SyncWith's goal is to ensure you report runs successfully, but sometimes errors can prevent this.
Here are some of the errors that can happen, and what they mean and what you can do about them!
Error code | Description | What to do |
sheet-deleted | SyncWith believes the report's sheet (or tab) within your spreadsheet has been removed from the spreadsheet | If you manually refresh the report from with the SyncWith addon sidebar, it should re-create the missing sheet for you and resolve the issue. |
spreadsheet-deleted | SyncWith believes the entire spreadsheet (document) that your report was in has been deleted. | Please check your google drive to see if this spreadsheet has been accidentally deleted or not. |
spreadsheet-permission-error | SyncWith was unable to update the report contents in the spreadsheet due to a permissions problem. | Please make sure that Google account you use with SyncWith has write access to the necessary spreadsheet. |
invalid-cell-references | This can happen when you have configured a report to use cell references, and those are no broken | Please edit the report and update any cell references as necessary |
cell-reference-limit-exceeded | This can happen when you have configured a report to use cell references, and a cell reference range points to more than 10,000 values | Change your cell reference to point to fewer values |
rate-limit-exceeded | This happens when SyncWith hits a rate limit (or quota) when pulling data from the report source. | Usually SyncWith will retry for you. But you can retry yourself too. |
service-temporarily-unavailable | This happens when it appears that Google Sheets API is having issues and SyncWith is unable to update your spreadsheet. | Retry later. |
spreadsheet-cell-limit-exceeded | This is an error from Google Sheets, and it means when attempting to update your report Google Sheets calculated that the spreadsheet (entire document) would exceed the Google's limit of the maximum number of cells permitted. | Reduce the number of cells (even empty ones) in your spreadsheet. Another option is to re-create report(s) in a brand new blank spreadsheet. |
unsupported-filtered-out-row | This happens if you have applied filter(s) to the report data in Google Sheets, this prevents SyncWith from updating the report. | Please remove all filters from the report data so that SyncWith can update the report.
As a work around you can pull the report data into a another location, using a google sheets formula, and then filter the data in that new location.
You can use an array literal like
Failing that please try re-creating (or duplicating) the report. |
update-cells-end-before-start | This happens when SyncWith his an issue in your spreadsheet preventing it from updating your report. | Recreating the report in a new separate sheet/tab might be the best option |
merged-cells-in-range | This happens if you have merged cells within the report data in Google Sheets, this prevents SyncWith from updating the report. | Please unmerge all cells. Failing that please try re-creating (or duplicating) the report. |
range-exceeds-cell-limits | This happens when using cell references and you inadvertently reference a range outside the sheet limits. | Please edit the report, and review and fix your cell references. |
z-syncwith-named-range-missing | SyncWith maintains a hidden named range in Google Sheets for each report, this error happens when that range cannot be found for a given report. | Please re-create (or duplicate) the report. |
addon-uninstalled | This happens when SyncWith's Google Sheets addon has been uninstalled and means that SyncWith can no longer update your spreadsheet(s). | Reinstall the same SyncWith google sheets addon you used originally using the same Google account. |
token-expired | This means that SyncWith's access to your spreadsheet has somehow expired, preventing it from updating your report. | Usually opening the SyncWith addon sidebar in the relevant spreadsheet will resolve the issue.
Another potential solution is to setup background access for SyncWith. |
temporary-network-error | This means that SyncWith hit a network issue trying to pull data for your report, or insert data into your spreadshee.t | Usually SyncWith will retry for you. But you can retry yourself too. |