95% of all sync errors with Google Sheets in QuotaPath are a direct result of missing requirements below. If you are getting a sync error with your Google Sheet, follow the steps below to troubleshoot.
1) 'id' column
One column must be labeled 'id', lowercase. Upper case will cause errors.
Every row in that id column must be unique, no duplicates allowed.
Every row with data must also have a value in the ID column.
Do not use row count or a sequential method that will change a rows id when a new row of data is inserted in the middle of the data set.
If you don't have a unique ID available to pull into your Google Sheet data, you can create one in your Google Sheet ID column using the =CONCATENATE( ) formula. This lets you string together cell values, text, and punctuation to ensure every row will always be a unique ID value and will remain unchanged if a new row is inserted into the middle of a data set.
2) Formatting
All dates must be formatted YYYY-MM-DD. Sometimes as new data is added, formatting is not correctly applied to the bottom rows.
All amounts and number values must be formatted 0000.00. No currency symbols or commas allowed.
Member email address should be lower case.
No table or pivot table formatting. Only flat spreadsheets are accepted.
3) Duplicate column or tab names
More than one tab with the same name will cause issues.
In each sheet, no two columns should have identical names.
4) Cell formula errors
Ensure no cells show formula errors. Use IFERROR( ) formulas to return 0 or null if a formula errors out.
Once you have fixed any issues and are ready to try resyncing your Google Sheet to QuotaPath, simply go into QuotaPath and click Sync and Refresh on your Google Sheet connection. This can be done on the Integrations tab or in the drop-down Data Source Sync Status window in your header.