SyncWith for Google Sheets is a Google Sheets addon, and we use Google Apps Script to interact with your spreadsheets, so that we can insert new sheets (tabs), insert our status row, detect which cell is in focus etc.
Errors
There are a number of Google Apps Script errors we've seen that fall into the same category:
Exceeded maximum execution time
We're sorry, a server error occurred. Please wait a bit and try again.
Service Spreadsheets timed out while accessing document with id <spreadsheetId>
Service Spreadsheets failed while accessing document with id <spreadsheetId>
We're sorry, a server error occurred while reading from storage
When these Google Apps Script errors occur, often its along with a message from our Google Sheets addon about what it was trying to perform, examples include
An error occured while preloading the status row
Possible solutions
Often these errors are temporary, and if you retry your steps right away or after waiting some time then often the error won't happen again. If you're seeing one of these errors happening repeatedly, then please try creating a brand new empty spreadsheet, and try recreating your report there. You can make a new spreadsheet by visiting https://sheets.new
When helping some users we've seen that sometimes a given spreadsheet (document) somehow gets into a state where our addon is unable to interact with it, and switching to a new spreadsheet can work around this.
This is definitely not ideal, and we are still hoping to find a better solution to these issues, but we don't have much visibility into whats going on and we don't have an explanation as to why these errors happen when using Google Apps Script to interact with your spreadsheet.