Linking Smartsheet as a source
This source is currently in alpha. The interface and available tables may change.
Enter your Smartsheet API access token to pull your Smartsheet data into the PostHog data warehouse.
Adding a data source
- Go to the sources tab of the data pipeline section in PostHog.
- Click + New source and then click Link next to Smartsheet.
- Generate a personal access token under Personal Settings → API Access in your Smartsheet account. The token inherits your account's read access; the
userstable additionally requires a system administrator account. - Back in PostHog, paste the token in the
Access tokenfield and click Next. - Select the tables you want to sync, set the sync method and frequency, then click Import.
Once the syncs are complete, you can start using Smartsheet data in PostHog.
Available tables
| Table | Description | Sync method |
|---|---|---|
sheets | Sheets in your account | Full refresh |
reports | Reports in your account | Full refresh |
workspaces | Workspaces in your account | Full refresh |
users | Users in your account (requires a system administrator account) | Full refresh |
contacts | Contacts in your account | Full refresh |
templates | Templates in your account | Full refresh |
Incremental tables sync only new or updated records on each run. Full refresh tables reload all data on each sync.
Configuration
| Option | Type | Required |
|---|---|---|
Access token | password | Yes |
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
sheets | Metadata for a sheet the account can access (the grid where rows and columns of data live). | Full refresh | — | — |
reports | Metadata for a report — a filtered, cross-sheet view of rows the account can access. | Full refresh | — | — |
workspaces | Metadata for a workspace — a container that groups sheets, reports, and dashboards. | Full refresh | — | — |
users | A user in the Smartsheet organization (requires a system administrator account). | Full refresh | — | — |
contacts | A contact in the account's personal contact list, usable when assigning rows. | Full refresh | — | — |
templates | Metadata for a template the account can use to create new sheets. | Full refresh | — | — |