Unite provides visibility into synchronization activity and system-level diagnostics to help you validate your setup and troubleshoot issues.
Reviewing logs
Run logs for each workflow
From the Workflows Home Screen, access the log summary for each workflow via the Last Run timestamp column. These summary logs include:
- Sync status, such as "Completed Successfully," "Completed with Warnings," or "Failed"
- Sync duration and timestamp
- Number of records added, updated, or deleted
- Summary messages from the system APIs when errors are identified
These logs provide high-level insights but do not include row-level errors. For more detailed troubleshooting, refer to your sheet's Sync Errors column.
Sync error messages in the integrated sheet
The Sync Errors column captures row-level error messages returned by the external application. These errors often include details such as:
- Invalid field values or data types
- Missing required fields
- Unsupported operations, such as updating a read-only field or creating a record without associated line items
Keep this column visible in your sheet to identify and resolve integration issues, especially after changes to filters, field mappings, or system permissions. You can also build Smartsheet automations on the Sync Errors column to surface issues as they arise.
Troubleshooting
If your workflow is not syncing as expected or is producing errors, use the checklist below to isolate and resolve common causes.
Sync is broken after a permissions change Ensure the workflow owner retains access to both the Smartsheet sheet (as an Admin) and the external system's dataset. Losing access, such as being removed from a workspace or project, breaks the workflow.
Rows show errors in the Sync Errors column This column logs specific API error messages tied to each row. Use it to identify issues such as incorrectly formatted data, unauthorized field changes, or records that violate application rules.
Expected changes did not occur Inspect the workflow run logs to see how many records were updated or skipped. If changes were expected but did not happen, this may indicate an upstream data issue or a misconfigured mapping or filter.
Fields are not mapping correctly Mismatches between data types — such as mapping a date field to a contact column — or missing columns in Smartsheet can cause sync errors. Review and update field mappings.
The workflow syncs zero records A filter that is too restrictive or references a missing value can cause this. Double-check your filter logic and ensure required columns exist and are populated.
Sync is incomplete or failing on a large dataset Smartsheet sheets are subject to system limits (for example, 20,000 rows and 500,000 cells as of May 2025). Syncing datasets that exceed these thresholds may result in incomplete or failed syncs. Apply filters to reduce the data scope, or break large datasets into multiple workflows.