Smartsheet Private Preview
Smartsheet is a spreadsheet application for collaboration and work management.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| Row filtering | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step Smartsheet setup guide to connect Smartsheet with your destination using Fivetran connectors.
Initial sync
The initial sync retrieves data from the sheets that you selected as tables in the fetched schema during connection setup.
During the initial sync, Fivetran syncs all sheets for which you granted read permission in your Smartsheet account. We import each sheet in full before moving onto the next sheet. Depending on the number and size of sheets to be imported, initial sync can take a while.
Schema information
The schema is dynamically built from your sheets' and workspaces' structure. Each Smartsheet workspace maps to a schema in the destination. Each Smartsheet sheet maps to a table in the destination. Each sheet column maps to a column in its target table. Besides the columns from your Smartsheet sheets, Fivetran also creates additional columns to successfully track changes: _row_id, _fivetran_synced, and _fivetran_deleted.
Naming
If you change the name of your workspace or sheet, the connection will not be affected since we use the unique IDs of each object to track them. If you rename a column, we create a new column in the destination table with the new name, and the old column with its values remains.
Type transformations and mapping
Smartsheet does not enforce strict data types on its columns. For this reason, Fivetran treats all columns as strings.
Updating data
Incremental syncs
During incremental syncs, Fivetran discovers new sheets, rows, and columns in your Smartsheet source, checks for updates in the sheets already synced to the destination, and syncs them based on the sync frequency that you defined.
Currently, Fivetran does not capture deleted rows or columns from Smartsheet.
Excluding data
You can exclude workspaces, sheets and columns from being synced by removing them from the connector configuration in the Fivetran dashboard.