Connect your Smartsheet account to import sheet data into Atlas. Browse all sheets you have access to and sync data automatically when changes occur.
Connect to Smartsheet
- Click Add data in the Layers panel
- Go to the Connections tab
- Select Smartsheet
- Click Connect with Smartsheet
- Sign in to your Smartsheet account and authorize Atlas
After authorization, Atlas creates a connection to your Smartsheet account.
Working with Data
Once connected, browse all sheets in your account. Select sheets to import as datasets. Atlas preserves column types including dates, checkboxes, and picklists.
Supported Column Types
| Smartsheet Type | Atlas Type |
|---|---|
| Text/Number | Auto-detected |
| Date | Date |
| Checkbox | Boolean |
| Picklist | Single Select |
| Multi-Picklist | Multi Select |
| Duration | Duration |
Sync Settings
Connected sheets sync automatically. Atlas detects changes using the sheet's last modified timestamp and updates your data when the source changes. Configure sync intervals in Layer Settings.
Smart Sync (merge on key)
By default, each sync replaces all rows in the dataset. Smart Sync instead merges incoming rows onto a unique key column, preserving any manual edits, geocoding, and geometry you have added in Atlas between syncs.
To enable Smart Sync when importing a sheet:
- In the import dialog, open Data sync settings.
- Select a Unique key column — the column whose values identify each row.
- Complete the import. Future syncs will merge rows on that key rather than replacing the dataset.
Rows deleted in Smartsheet are removed from the map on the next sync.
Troubleshooting
| Issue | Solution |
|---|---|
| Authorization Failed | Ensure you're signing in with the correct Smartsheet account. |
| Sheet Not Found | Check that the sheet still exists and you have access to it. |
| Sync Failed | Verify your Smartsheet authorization is still valid. Re-authorize if needed. |
| No Sheets Listed | Confirm your account has sheets. Check access permissions. |