7shifts
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect 7shifts to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Create an access token in 7shifts under Settings > Developer Tools. Enter the matching company ID.
Configuration
| Option | Type | Required |
|---|---|---|
Access token | password | Yes |
Company ID | text | Yes |
Linking 7shifts to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select 7shifts
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
locations | Company locations with addresses, time zones, and opening hours. | Incremental, Full refresh | modified | — |
departments | Company departments and their locations. | Incremental, Full refresh | modified | — |
roles | Work roles with department assignments and job codes. | Incremental, Full refresh | modified | — |
users | Company employees with contact details, status, and wage settings. | Incremental, Full refresh | modified | — |
shifts | Published shifts with assignments, scheduled times, and deletion status. | Incremental, Full refresh | modified | — |
time_punches | Employee time punches with breaks, approval status, and declared tips. | Incremental, Full refresh | modified | — |