Encountering issues with your Google Sheets sync? This guide will help you troubleshoot common problems and get your workflows back on track.
In this article:
- Column-related errors
- Add-on is not configured error
- Formulas and sync failures
- Dates not syncing properly
- Avoid sorting Sheets when using filters
Column-related errors
"We’ve detected that mandatory columns have been removed from your google sheet. let’s get you back up and running."
This error message occurs when someone on your team modifies or deletes the Unito ID or Last Modified columns.
Solution: To prevent this from happening, you can hide the columns after launching your flow:
And remember to freeze the first row so that no one can modify your fields or columns:
That message or "The container configuration does not allow us to sync" indicate that your columns need to be recovered.
How to recover deleted UnitoID and Last Modified columns
If you accidentally delete the UnitoID or Last Modified columns in a live flow, you can undo that action with a quick Ctrl+Z (or Cmd+Z for Mac users). If that doesn't work, you can check your sheet's version history to locate a version that includes those columns and restore them.
To check your Google Sheet's history: File > Version History > See Version History.
Don't lock those columns: You can't lock these columns, since doing so will prevent Unito from making changes to them, which will in turn stop your flow from syncing.
Formatting: If the column to the far right of your spreadsheet has special formatting, the Last Modified column won't be created properly. If needed, insert a blank column before adding the Last Modified column through the Unito add-on.
Error: "2 columns couldn’t be added. Please retry in a moment."
If you see this error message while trying to add UnitoID and Last Modified to your sheet, simply type in those column names manually.
Some columns are no longer syncing
Double-check if the header cell names match the field mappings in your Unito flow. If you've changed a header name, update the corresponding field mapping in Unito. You can do this by loading your field mappings (or refreshing the screen) and checking to see if any fields don't have a link in the other connected tool or spreadsheet.
"Add-on is not configured" error
This often means your sheet isn't set up correctly. Make sure that
- The first row of your sheet is used as a header.
- Every column has a name.
- The first column is labeled UnitoID and the last column is Last Modified.
Formulas and sync failures
Excessive formula usage in your Google Sheet can cause sync failures due to Google API timeouts. Try simplifying your formulas or consolidating calculations to improve performance.
Unfortunately, there is no specific number of formulas at which your Google Sheet might stop working with Unito.
But if your Sheet runs noticeably slowly, that's a sign that it may struggle to connect to Unito properly.
Refer to Google's support documentation to streamline your formula usage.
Character limit exceeded: You won't be able to sync information into a cell if the source (i.e., the work item you're syncing to Google Sheets) contains more than 50,000 characters due to a limitation in Google Sheets.
Dates not syncing properly
Unito can sync dates to your spreadsheet as long as the format you're syncing to or from Google Sheets fits with one of the options in the table below.
Synced dates will typically include a timecode as well. You can remove it by following the steps outlined above (for adjusting the format in your spreadsheet directly)
|
Supported format |
Example |
|
dddd, MMMM D, YYYY |
Friday, July 22, 2022 |
|
dddd, MMMM Do, YYYY |
Friday, July 22nd, 2022 |
|
dddd, MMMM D, YY |
Friday, July 22, 22 |
|
dddd, MMMM Do, YY |
Friday, July 22nd, 22 |
|
MMM D |
Jul 22 |
|
MMM Do |
Jul 22nd |
|
MMM D, YY |
Jul 22, 22 |
|
MMM Do, YY |
Jul 22nd, 22 |
|
MMM D, YYYY |
Jul 22, 2022 |
|
MMM Do, YYYY |
Jul 22nd, 2022 |
|
MMMM D |
July 22 |
|
MMMM Do |
July 22nd |
|
MMMM D, YY |
July 22, 22 |
|
MMMM Do, YY |
July 22nd, 22 |
|
MMMM D, YYYY |
July 22, 2022 |
|
MMMM Do, YYYY |
July 22nd, 2022 |
|
D-MM |
22-07, 5-07 |
|
D-MMM |
22-Jul, 5-07 |
|
D-MM-YY |
22-07-22, 5-07-22 |
|
D-MMM-YY |
22-Jul-22, 5-Jul-22 |
|
D-MM-YYYY |
22-07-2022, 5-07-2022 |
|
D-MMM-YYYY |
22-Jul-2022, 5-Jul-2022 |
|
M-D |
7-5 |
|
M-D-YY |
7-5-22 |
|
M-D-YYYY |
7-5-2022 |
|
MMM-D |
Jul-5 |
|
MMM-D-YY |
Jul-5-22 |
|
MMM-D-YYYY |
Jul-5-2022 |
|
YYYY-M-D |
2022-7-5 |
|
dddd, MMMM D, YYYY H:mm |
Friday, July 22, 2022 12:00 |
|
dddd, MMMM D, YYYY h:mm A |
Friday, July 22, 2022 12:00 PM |
|
dddd, MMMM Do, YYYY H:mm |
Friday, July 22nd, 2022 12:00 |
|
dddd, MMMM Do, YYYY h:mm A |
Friday, July 22nd, 2022 12:00 PM |
|
MMMM D, YYYY H:mm |
July 22, 2022 12:00 |
|
MMMM D, YYYY h:mm A |
July 22, 2022 12:00 PM |
|
D-MM-YY H:mm |
22-07-22 12:00 |
|
D-MM-YY h:mm A |
22-07-22 12:00 pm |
|
D-MM-YYYY H:mm |
22-07-2022 12:00 |
|
D-MM-YYYY h:mm A |
22-07-2022 12:00 PM |
|
M-D-YY H:mm |
07-22-22 12:00 |
|
M-D-YY h:mm A |
07-22-22 12:00 pm |
|
M-D-YYYY H:mm |
07-22-2022 12:00 |
|
M-D-YYYY h:mm A |
07-22-2022 12:00 pm |
|
YYYY-M-D H:mm |
2022-07-22 12:00 |
|
YYYY-M-D h:mm A |
2022-07-22 12:00 pm |
You can also manually set the preferred date and time format you want synced from Google Sheets through advanced manual options.
Avoid sorting Sheets when using filters
If you use filters in your Google Sheets, avoid sorting them. That's because sorting will only impact unfiltered rows, which will prevent your Unito flow from accurately reading the information in them. If you do need to sort your Sheet, make sure that it has no filters whatsoever.