Linking Smartsheet as a source
Alpha release
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 |